I have issue regarding the update of qty in my database. Here is what i wanted to achieve. I have 2 table Product and Product line. I made a layout based on Product and made a portal into it for Product line. there is another table name items.
Product is related to Product Line which is related to Items.
after i insert the all the required products in Product Line. I want a button which updates the qty in items table for each item inserted in Product line.
Can some pleas help on it? Have very little experience in on Filemaker.
I have Filemaker 12 Pro.