I need some help with building an input form please. I have two tables, a client table and a transaction table. The client table has a unique client ID and other details like first name, last name etc. The transaction table has a unique transaction ID+fields relating to details about items purchased.
In my input screen for a new transaction I'd like the user to be able to select a client name (first name+last name) and then fill in the transaction details for that client.
I've been playing with a Picklist and a Column List but have not been able to get it to work yet. Any hints on how to achieve this please?