Incase it is helpful here is the background to my problem
I have a database that manages inventory & populates a website, in one of the layouts I have a [1 Sold] button, when clicked it reduce the available stock number by 1 (no problem here).
Im trying to add a feature where 1 record can represent a multiple items (a pack or group)
when the user clicks [1 sold] I need to reduce the stock number for each item in the group.
I have a field where the user enters the ID of each item in the group. When the [1 sold] button is clicked I loop though the ID's
this is where I am stuck. For each ID I need to find its record, modify stock number and repeat the process
Some business log such "kits" as separate (do not inventory) items. In FileMaker you can set up a related table that lists the individual items (and their quantities) that make up such a "kit" entry. You may want to consider those ideas for a future upgrade to your design.
To answer the specific question (which I would not have had a clue how to answer until you posted your follow up post...):
I am also assuming that you have to modify records in a related table to update your inventory. Let me know if this is not the case.
Go to Record/Request/Page [first]
Go To Related Record [Show only related records; From table: Inventory; Using layout: "Inventory" (Inventory)]
#put steps here to update inventory.
Go to Layout [original layout]
Go to record/Request/Page [next; exit after last]