Linked tables validation

[habbabub]

if i had two tables (A and B) which are linked by one feild eg. "user ID"

how would i make it so that when data for (table B) is typed into a form that if that "user ID" dosent exist in A then it will not add the record to table B?

 

[boblarson]

If table A is the ONE of a One-To-Many relationship and table B is that many of the one-to-many relationship, you can set your relationships in the relationship window to set Referential Integrity (RI) so that it won't let you add a record in B without a matching record in A.

 

[habbabub]

hows that done?

 

[habbabub]

thats alright i found out how.. but how can i make it so that it shows a msg box that i can type in my own error message?

 

[boblarson]

See if this helps:

http://www.functionx.com/access/Lesson17.htm

 

[habbabub]

but it dosent show how to create a msg command.

rather than have a generic error msg when the error arises i can type in a message that lets the user know what is wrong..

whould u know how to do ithis?