Hello, i am new to filemaker. Recently, i am working on the portal.
The relationship of the tables is People -> order-> order line item<- product
so my question is when i input data in order line item and some of fields are looking up data from product table when they are selected.
After i updated the data in product table. the value chosen in order line item will not update. so how could i update the data of look up fields?
or i should use the product fields directly in the portal table.
i am using filemaker 15. if my description is not clear enough, please tell me, i will explain it as clear as possible.