S
skrappySenior
I have a data base that requires a large amount of information (we will call
census data) which has over 75 columns in a single table. The information
has to be updated on an annual basis - so the census table is a one-to-many
relationship to the client table, with the primary/foreign respectively being
the client ID. There are also some tables I would like to generate
automatically from the initial entry of the new client form and the first
census table(s)
I would like to separate the types of census data. What VBA code can I use
to have each separate census table pick up the related client ID from the
client table automatically without user selection in each table. I would
also like to have some background code that will automatically put the first
visit date and client id in a separate table, and create an autonumber as
secondary client code for a different reporting system.
census data) which has over 75 columns in a single table. The information
has to be updated on an annual basis - so the census table is a one-to-many
relationship to the client table, with the primary/foreign respectively being
the client ID. There are also some tables I would like to generate
automatically from the initial entry of the new client form and the first
census table(s)
I would like to separate the types of census data. What VBA code can I use
to have each separate census table pick up the related client ID from the
client table automatically without user selection in each table. I would
also like to have some background code that will automatically put the first
visit date and client id in a separate table, and create an autonumber as
secondary client code for a different reporting system.