Relationship Explained

[TC]

Tom, you will get nowhere starting a new thread like this. No-one has any
idea what previous thread you are referring to. That thread might be
seperated from your new thread, by hundreds of >other< new threads from all
over the world. And/or, the previous thread might have disappeared from the
reader's newsserver. It is a big ask to expect anyone to go back, searching
Google the previous thread, to see what you are on about.

I suggest you post back to the >previous< thread (whatever it was), or,
provide enough new information for your new thread to stand "on its own",
without any knowledge of or reference to the previous thread.

HTH,
TC

 

[Tom]

My earlier message was generically worded and confusing.

I will try again, one table is DONORS and the other is
DONATIONS.

When I enter a Donor No in an input form for a donation,
I want the Donor Name to show in the form to insure I
credit the donation to the correct donor.

Tom

 

[John Vinson]

My earlier message was generically worded and confusing.

I will try again, one table is DONORS and the other is
DONATIONS.

When I enter a Donor No in an input form for a donation,
I want the Donor Name to show in the form to insure I
credit the donation to the correct donor.

Tom

Create a Form based on the Donor table. Put the donor's name (and any
other desired donor information) on this form.

On that Form put a Subform based on the Donations table, using DonorID
as the master/child linking field.

Put a *combo box* on the Donor form, using the Combo Box wizard option
"use this combo box to find a record in my form". Rather than typing a
donor number, just *select* it from the combo - it will bring up the
name that already is there in your table, *and* link to the Donations
table in the subform.