Access

[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

 

[John Vinson]

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...

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.