Relationships 1

[abbottboi]

Hi,
I have a table of donors and a table of donations. Since the relationship is one-2-many with each donor making more than one donation how to I link the donation IDs to the donor ID.

I haven't used access in soo long... any help would be great!

 

[PHV]

The donations table should have a Foreign Key (allowing duplicates) referencing the Primary Key of the donors table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[abbottboi]

Thanks, that will work great.

one more thing. I have donor IDs.

In my form i want to be able to select the ID and have the donor_firstname and donor_lastname auto-populate based the on the same table as the ID.

Wbat would the relationship be? or how do i link that?

thanks