G
Guest
I tried this awhile back and gave up. Trying again.
I made a form with two tables, customers & calls.
When I enter the phone number from the customers table that exists it
populates the form the way I want it and I can save the form or add a new
record and I think it is saving it in the calls table.
If I enter a phone that doesn't exist and try to exit or enter a new record,
I get the following.
The microsoft jet database engine cannot find a record in the table
'customer' with key matching field(s) 'Phone#'.
What I am trying to do is save the form even though it doesn't find a
matching field.
I made a form with two tables, customers & calls.
When I enter the phone number from the customers table that exists it
populates the form the way I want it and I can save the form or add a new
record and I think it is saving it in the calls table.
If I enter a phone that doesn't exist and try to exit or enter a new record,
I get the following.
The microsoft jet database engine cannot find a record in the table
'customer' with key matching field(s) 'Phone#'.
What I am trying to do is save the form even though it doesn't find a
matching field.