look up data

[confused???]

I want to be able to pull data (multiple fields, i.e. last name, first name,
ssn, etc) from one table to another based on a selection from a look up
list????

 

[Jeff Boyce]

Why? What business need would you be satisfying by having the same data
(lastname, firstname, ...) stored in more than one place (i.e., table)?

Regards

Jeff Boyce
Microsoft Office/Access MVP