AnsweredAssumed Answered

Field dependent search logic

Question asked by scottcincy on Dec 29, 2015
Latest reply on Dec 29, 2015 by mikebeargie

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.