How to create a table with a relation

[Dan]

I have a table with our member's personal information and
I am creating another table with the accounts recievable
information. I want the accounts recievable one to be
referenced to the table with the members personal
information table but I only want it to have the members
that ows us money stored in it. How do I create the
relation between the tables and have them automatically
update.

I want it so that when the user changes the
field 'Status', that is located in the members personal
information table, to "Accounts Recievable" that it will
insert a row into the 'account recievable' table and
bring up another form so that the user can insert the
information.

 

[Martin SChukrazy]

You dont need a relationship what you need is a insert, update and delete
trigger on the member table, which inserts new entries in the accounts
recievable table (or deletes)