Would be fantastic if someone could help me here. I am not a complete novice but the fact that I am getting this error message tells me I am not as good as I thought I was....
I have two tables as follows -
Customer Addresses
Salesmen
I have created a form that has a combo box on it that lists salesmen from the Salesmen table and should store them on the customer addresses table in a field called Our Rep.
I have a relationship between each table with the field Salemen ID linked with a one to many relationship (autonumbered in the salesmen table.
Other than the error I receive, I note that the two tables aren't sharing the autonumbered field, ie the Salesmen ID field on the Customer Address table isn't showing the number from the Salesmen ID on the salesmen table.
I hope this all makes sense, any help would be much appreciated.
Rob