ID Number

W

willm16

I am doing a database with two tables. The first table has client info. In
this table, each client is assigned a unique number using the "AutoNumber"
feature. The second table has services the client requested. In this second
table I want Access to automatically enter the client ID number that was
issued in the first table. How do I do this? Thanks!
 
A

Arvin Meyer [MVP]

willm16 said:
I am doing a database with two tables. The first table has client info. In
this table, each client is assigned a unique number using the "AutoNumber"
feature. The second table has services the client requested. In this
second
table I want Access to automatically enter the client ID number that was
issued in the first table. How do I do this? Thanks!
Click to expand...

The only ways to do this automatically is with a Form/Subform which are
linked on the ID number, or through code, by writing a record to the second
table. The first is not only easier, it makes more sense from a relational
standpoint, not to build records when they are no needed.
 
Top