Linking Records on a Form

[LClarke]

I am creating an events database where there are events and clients. These clients have a one to many relationship with the events. On the event details form (a split view form) I am able to select the ID (Client Reference) in a combo box so that it links with the event. However I think this is not ideal as it is not possible to remember the ID of each client so is there a way that I can instead have the client names in the combo box so the client name can be selected instead of their ID? I hope that makes sense.

[CJ_London]

is there a way that I can instead have the client names in the combo box so the client name can be selected instead of their ID?

yes. In your combobox:

1. set the rowsource to something like 'SELECT ClientID, ClientName FROM tblClients'
2. Set the number of columns to 2
3. Set the columnwidth to 0
4. Set the bound column to 1