SOLVED

Mixing organisational data types

Copper Contributor

I some oragnisational data types setup. They are all working fine in isolation. I am wondering if there is a way to use them in conjuction with each other. For instance:

 

Supplier_A belongs to a group called Account_1 (1:* relationship) both these bits of information are stored in the supplier data type.

 

Further Account_1 information comes from the Account data type.

 

When I create a table with Supplier_ID, then returning the Account_ID from the supplier data type, I would like to make that piece of data access the Account data type so i can return Account level information.

 

2021-05-03_15-02-12.jpg

 

Any help appreciated. I get that I might be wanting to achieve too much here and that its just not doable with a reasonably new technology.

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@samdthompson 

I guess you are asking about nested data types which are not supported, at least so far.

ah right. Thanks mate.
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@samdthompson 

I guess you are asking about nested data types which are not supported, at least so far.

View solution in original post