Auto populate fields in a table

[dta87]

I am trying to modify someones existing Access database that has multiple years worth of data. There are no forms in the database as it is built only with tables and queries (and the few reports that I have been able to add). Inputting data into this database has always been done manually through the various existing tables. One of the main uses for the database is tracking product downloads This is done with a 3 field "Pick-up" table (Customer (First and Last Name (appended from a Contacts table)), Product, and Pickup Date) that is linked to multiple other queries and tables. The issue is the downloads are tracked via e-mail address (also in the Contacts table) so all the data is input manually by polling the e-mails from a separate program and manually inputing each download to the corresponding name in the table.

What I want to do is add an email field to the 'Pick-up" table and have the Customer field auto-populate (again all in a table). Is this possible?

 

[GinaWhipp]

What you are talking about is done via a Combo Box on a form, not in a table. You might be able to *fake it* using a query joining the two tables together and when you look up the eMail Address from one table (in the query) it will show the related information from the other table (in the query).

 

[dta87]

That is what I figured (the need for a form).
I was just trying to be lazy since we have hundreds of entries to make for each product we have, the easiest way to update the database would be to take the adresses from an excel printout and paste them into the table. With a form it would still end up being individual record entries for each "pick-up".
Had the original database been put together based upon e-mail addresses instead of appending the first and last name fields I could find an easier way around this.

 

[monplankton]

why don't you create a table of E mail address with a reference primary key and apply that to each product then you to group it?

 

[dta87]

Thanks for the help