I am new to FMP (3 weeks). I am developing an inventory control application that has a many-to-one relationship. Example - inventory item "steel" has many "lots" associated with it. Lot 1001, 1002, 1003, etc.
I am working on a data entry layout where the user will enter "steel" the inventory item, then tab to the lot field. When the user searches for the lot, I would like the application to only show a list of lots associated with the previously entered item "steel". The user would then be limited to choosing from these lots.
Any guidance on how to approach this would be greatly appreciated.