As an example, take a table named
Client containing fields
ClientName) and associated primary key (
ClientId). What we want to achieve is to have the form display the Client Name in a Listbox, but actually use the corresponding ClientID in the underlying table to write that value elsewhere. It is therefore necessary to declare the field where this data is going to be saved, associate a SQL query to the listbox and setup the field of the table to be used for display as well as that for saving the data.