Search the Community
Showing results for tags 'self join'.
Found 1 result
Hi: I'm a Novice user of Filemaker 11 getting trouble finding a solution to link 2 tables from a set of values located in a Value List. The first table Products:Product_ID holds the list of products The second one Products_to_Products is used to show in a portal the products that have the same specs and that can be considered as "similar" or "compatibles". I need to create the link between this two tables using a Value List. Example: 4 products has been selected and the value list contains the Product_ID for each one separated by a CR: myValueList 1 2 3 4 Now, based on this list, I need to create in the table Products_to_Products the records that will hold the pk's for each combination of the members of the Value List. The only constrain is to avoid the association between same products. The needed result is this: Product_ID1,Produc_ID2 1,2 1,3 1,4 2,1 2,3 2,4 3,1 3,2 3,4 4,1 4,2 4,3 There is any Function in Filemaker 11 that will make easy to solve this? Any help will be greatly appreciated.