Display list of field values, then click button to show rest of record
I'm new to FM and I have searched like mad, but it's hard when you don't really know what to search on.
I have a table called 'ingredients'. There fields 'ingredientName', 'purchaseQty', 'purchaseAmt', and 'costUnit' (and about 10 more)
I am trying to find a way to have a screen that would list all the values from the 'ingredientname' in something that looks like a portal with a vertical scrollbar, and when an ingredient is selected, the other fields would populate to the right. I'm ok with clicking a button next to the ingredient name.
This way a user could scroll through the list of ingredients, select one (click name or button) and then the details would appear on the layout. They could then edit the other fields if necessary.
I assume this could probably be done with another table that just held the ingredient name (it's unique) and related them, and use a portal to show the ingredient names, but I just can't get it.
Any and all help would be appreciated. I attached a cruddy non-working mockup.