Basic info table

[Guest]

I need to set up one table of basic information for our physicians that can
be the start of several other tables. However, I will need all the other
tables that are formed from this basic table to update whenever a new
provider is added to the initial basic information table.

 

[Duane Hookom]

I doubt anyone has a real good idea of what you are asking. You need to
review your data and determine a good, normalized table structure that meets
your needs. There are some links at Jeff Conrad's web site
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101

 

[John Vinson]

I need to set up one table of basic information for our physicians that can
be the start of several other tables. However, I will need all the other
tables that are formed from this basic table to update whenever a new
provider is added to the initial basic information table.

If you're talking about having a template table, and making many
identical tables with the same structure and storing the basic table
data redundantly in all of them - STOP. That's not how relatonal
databases work! Read the reference Duane provided, and redesign.

If that's not what you're talking about, please repost and explain in
more detail. How would this "basic info" table be used?

John W. Vinson[MVP]