HNY to you too and see how you like it!
That's what you get for not following my advice.... just kidding.
Seriously, though, your first step, if you want this relationship to work, is
to fix your tables manually, and make SURE that there is an owner record for
every referral. If you have a referral without an owner, you have two choices:
1- delete the referral, or 2- create an owner. Also, you must delete any
duplicate owners. Your second step MUST be to generate the autonumbers
(Primary Key) for the owners table, and MANUALLY populating the referral
tables (Foreign Key) with the correct owners. If you don't take these
critical first steps, your relationship is definitely headed for the rocks.
And I'm not kidding!
Message posted via AccessMonster.com