I receive this from trying to relate the following:
ItemAssignmentData:Product ID Match to > Products:Product ID Match
It made me make a new one called Products 2
But as you can see it allowed me to relate both the the Serials Table.
FM does not allow circular relationships.
I am not understanding how it is circular.
If you could connect along the direction of your red arrow then there would be two paths between Products and ItemAssigments Data TOs
one direct and one through Serials and Invoice Data
So if you were on ItemAssignmentsData and you wanted to show related products, how would you or FM decide which path to take? Either one would give you different results so what results would you want? You'd have no way to express which route to take.
Remember that the Graph is not an ERD representation or an ERD tool.
What I was trying to do was assign my clients ItemAssignment table to products so that she can
push out what items need to be installed.
But when i do it had me make the Products 2 table
That is OK. Name this Products TO: PRODUCTS by Clients ItemAssignment for example or anything meaningful to you.
So how can i pull items from my products table and not the Products 2 table
for ItemAssignment to the Techs?
Products and products 2 are the same table. They are both occurrences of the same data source table. By creating a new occurrence of the table, you gain a new way to refer to the same table and can use it in different relationships than the original occurrence.
For more on the subject:
Tutorial: What are Table Occurrences?
Given Product and Product 2 are the same table just pull the item from Product 2. I will be the same as pulling from Product because both tables are Occurrences of the same table.
Retrieving data ...