Want to select Donor and have address fields in fill in automatically
I've done this before, but I can't seem to get it to work this time:
I've put together a database for an upcoming event. Here are the tables:
Donors - Individual and Org. Donors
Tickets - Ticket purchase info
Ads - ad sales info
Board Staff - listing of board and staff
I want to select the a donor in the tickets layout (pulled from donor table) and have the address fields fill in. I've related the donor_id in each table. The Donor Names are value list (one for ind. one for organization) pointing to the corresponding fields in the donor table. The address fields in the tickets layout point back to the donor table.
I tried this a couple of weeks ago with a different database and it worked, but for some reason, when I select the name the address fields are blank.
I hope that's clear. Thanks for any help.