Thank you all for reading this post.
i have a little problem and I hope I can get a solution here.
i have a database containing three tables, clients, items, invoice, in client layout, a portal of items related to clients table by client_fk, in the first field a drop down menu of items, my goal is to be able to choose an item fromdrop down list, get the price of the item selected in the next field of the portal and then set a button on the same portal row to transfer these data to invoice table.
If this is a simple operation please excuse my ignorance since I am new in file maker and still learning.
thank you all.