Relationship Explained

  • Thread starter Thread starter TC
  • Start date Start date
T

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
 
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
 
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
Click to expand...

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.
 
Back
Top