Microsoft Access Child Record with Multiple Parents: Getting - Microsoft Community

hi all,

working on access database tracking donation information.

give gist of how have set up, have parent table donors make donations tracked in child table called donations. each donation may associated campaign or event, each of has separate tables. thus, each donation record serves child donors, events , campaigns.

while tracking donor's attendance @ event can done manually via donor-event junction table, interested in 2 things.

1: display list of donors have made donations associated event. can donations associated event unsure how map event donations extract matching donor information donor table.

2: interested in populating event-donor junction donors have made donations (as bound have attended event) , allowing end-user add in additional attendees see fit (basically donors attended did not end making donation).

looking forward help/suggestions end.

, donor name recorded in donations (a foreign key donors table in donations table).

first names not key field can have duplicate names. tablers should this:

tbldonors

donorid pk autonumber

donorfirstname

donorlastname

other donors

tblcampaignsandevents

campeventid (pk autonumber)

campeventtypeid (fk) (eitherevent or campaign etc)

campeventtitle

other info (you might need separate tables info unique campaigns or events.)

tbldonations

donationid (pk autonumber)

donorid (fk)

campeventid (fk)

donatedate

donation

other info

to listing of donors specific campaign or event, you  join 3 tables , list donor info specific campeventid

Office / Access / Microsoft Office Programming / Office 2016