How do I use Lookup in a form to pull in multiple fields from the reference form?

How do I?
1

For example in a Stock Trade form I would like to search the stock table for a Ticker to trade and, in addition, when I find the correct one I would like to pull in and show on the trade form the ticker, stock name, and price. In the Lookup examples I seem to be pulling in only one field. What am I missing? Thanks

2

Hi @bernie

The lookup field is designed to pull data for only one field. To obtain values for multiple fields, you may find it useful to refer to our previous response to a similar question. : Get data from one table to another table in a form - How do I? - Five Community Forums
Let me know if this helps