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

Populating a field automatically

P: n/a

I have a small database with a primary key similar to a social security
number (SSN). The tables are tied to the primary table via the SSN-type
field with referential integrity.

I have a number of click buttons that allow the user to navigate
between screens. When I go to enter data on these forms (which use the
child tables), how do I get the SSN-type field to be automatically
populated upon data entry? I don't want the user to have to key in the
number which is rather long and cumbersome each time that they add a
record to these child tables.

Thanks.

Jeff

Sep 16 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

ma*****@email.uc.edu wrote:
I have a small database with a primary key similar to a social security
number (SSN). The tables are tied to the primary table via the SSN-type
field with referential integrity.

I have a number of click buttons that allow the user to navigate
between screens. When I go to enter data on these forms (which use the
child tables), how do I get the SSN-type field to be automatically
populated upon data entry? I don't want the user to have to key in the
number which is rather long and cumbersome each time that they add a
record to these child tables.

Thanks.

Jeff
If you're using the SSN-type field as the foreign key in the child
table, you should get it by simply declaring the relationship between
the two tables or setting the LinkMaster/LinkChild fields to the name
of the SSN-like field.

Sep 17 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.