Auto-populate from another table

[Palladian1881]

Okay--I have a table of scholarships, and each one has fields for primary contact, secondary contact, tertiary contact, etc., in which the names of the contacts associated with each scholarship are stored. What I need to do is to have every name pulled from this table and listed--each as its own row--in another table. I'd like it to do this automatically so that if a new name is added to the scholarship table, it will create a new row in the other table. Is this possible???
Thanks in advance.

[rpeare]

It sounds like you are using a non-normalized table. Where your contacts are stored horizontally

i.e.

tblScolarships
ScolID  ScolName  Contact1 Contact2 Contact3 ----> more contacts

instead of

tblScholarships
ScholID ScholName

tblContacts
ScholID ContID ContName

You can see in the second example you can carry any number of contacts for a specific scholarship and not be bound by a predetermined number of contacts. In the first you have to allow for the maximum possible number of contacts, which, in all likelyhood, will leave you with a bunch of empty spaces.

If I'm correct you need a union query to 'normalize' this data set

So in your case it would be something like

SELECT ScholName, Contact1 as Contact FROM tblScholarships
UNION 
SELECT ScholName, Contact2 as Contact FROM tblScholarships
UNION 
SELECT ScholName, Contact3 as Contact FROM tblScolarships
...
and so on for all of your possible contact fields.

[Palladian1881]

Genius. Thank you so much.