4 Replies Latest reply on Aug 31, 2011 11:45 AM by philmodjunk

    Want to select Donor and have address fields in fill in automatically

      Title

      Want to select Donor and have address fields in fill in automatically

      Post

      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.