I have a table called tbl Company and it holds :
Company Text (100 characters)
I have another table called tbl Participants that holds CompanyID amongst other fields.
Is there a way to use a Combo box that has the bound field no shown but the company name shown and if it doesn't appear in the tbl Company table to put it there.
My problem is that Access tells me that the bound column must be visible, my bound column is in fact the CompanyID.
Am i up for deleting the Autonumber field in tbl Company and just have the company name in here as well as the table tbl Participants, in this way of course the company name is recorded in both tables, somthing i was trying to aviod.
Hope this makes sense.