AnsweredAssumed Answered

Draw Data from other table

Question asked by user2147901 on Nov 1, 2018
Latest reply on Nov 2, 2018 by philmodjunk

Hi, I am new to filemaker. I would like to pull the data from other table. I have several tables. Product line item table, Main, line item table1, line item table2, line item table3.


In product table, there are several fields, namely type, name and brand.e.g.

I would like to show the brand in main table and number of portal rows record, for example, A(4).

The relationship between tables are

product line item<-> main

main<->line item table 1(brand A)

main<->line item table 2(brand B)

main<->line item table 3(brand C)

line item tables are displaying different brands.


I have tried to relate product line item with main using type with fields in main(automatically enter data as A) and product line item id. But in that case, I have to create 1 TO for each brand. Is there any other ways to draw data from product line item table without the relationship.


Also, if I have another brand CC which is similar to C. Do I have to create another relationship for CC?


I am using filemaker 17.


My description may not be clear so I will explain further on request.