My form is linked to my jobs table. currently its showing the foreign keys from other tables rather than the name. How do I make it show the name?
I want to display names rather than the keys.
I've tried many different ways. when using a query it seemed to work how I wanted, but I would change the name on one record and all of them would change.
Any tips?
thanks, andy.
edit: I want to pick a name from a combo box then the ID for that name to be stored in the jobs table.