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.
Sounds like you just need to setup up a relational value list. Where by selecting an item, you get a related list of all lots associated with that for the user to select from.
Here's a quick youtube tutorial for setting up relational value lists: