Access

  • Thread starter Thread starter Sonny
  • Start date Start date
S

Sonny

Please Help

I want to design a form that will take info from a table
in the same data base a input it in anthor table in the
same data base with using pull down field.
example the same address for a company into a form using
company name, address, ect.. To use a combo box or a
list box that I came make a selection on company name and
will fill the other fields with adress, phone ect...

Thank You
 
Please Help

I want to design a form that will take info from a table
in the same data base a input it in anthor table in the
same data base with using pull down field.
example the same address for a company into a form using
company name, address, ect.. To use a combo box or a
list box that I came make a selection on company name and
will fill the other fields with adress, phone ect...
Click to expand...

If you're talking about copying all these fields from one table to
another table... DON'T.

As a relational database, Access uses the "Grandmother's Cupboard
Principle": "a place - ONE place! - for everything, everything in its
place". If you have a Company table with the name, address, etc. then
that should be the ONLY place where that information is stored; if you
need information about the company in association with some other
table, just store the CompanyID (using a combo box) in the second
table. You can *display* the information on a Form in a number of
ways, but storing it in your second table is neither necessary nor
prudent.
 
Back
Top