By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,953 Members | 1,131 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,953 IT Pros & Developers. It's quick & easy.

Auto fill help

P: n/a
What is the trick to allow auto filling?

I have two tables that look something like:

table1
SSN Text
Lname Text
Fname Text

table2
SSN Text
Lname Text
Fname Text

I'm trying to simplify this here. table1 is my data entry table. If my user
types SSN of 111-11-1111 I want the remainder of the fields to fill from
table2. Specifically Lname and Fname. How do I do this? This doesn't have to
be done through code right? If it matters I am using Access 2000.

Thanks


Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
First of all, it is rather bad practise to be using the tables as your data
entry tool. So if this is what you are doing, no, you cannot retrieve data
from another table like that. A form of sometype is required.

Mike Storr
www.veraccess.com

"Scott Simonson" <sc*********@wi.rr.com> wrote in message
news:DP*******************@twister.rdc-kc.rr.com...
What is the trick to allow auto filling?

I have two tables that look something like:

table1
SSN Text
Lname Text
Fname Text

table2
SSN Text
Lname Text
Fname Text

I'm trying to simplify this here. table1 is my data entry table. If my user types SSN of 111-11-1111 I want the remainder of the fields to fill from
table2. Specifically Lname and Fname. How do I do this? This doesn't have to be done through code right? If it matters I am using Access 2000.

Thanks

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.