"reeve13" wrote
I have a form I need to enter basic info into, and would like to know
Iif there is a way based on the primary key id when I enter info on an
individual's account, the rest of the info will get updated, i.e.
contact info, full name, etc.?
Most often, you keep the account and contact information in separate tables,
and store a "foreign key" to join those tables in a query when you use the
information. In many instances, such as an order or invoice, you use a form
embedded in a subform control to display that related information.
You might want to visit
http://office.microsoft.com and follow the links to
Training -- there are some very good (and free) online courses for Access
end-users. You might also look at the
http://www.mvps.org/access site, where
I think you will find suggestions on useful self-study books.
One comment that I'd make: what databases are about is data stored in
tables, so usually for anyone to answer a question, you need to describe the
table arrangement, not the forms you are using.
Larry Linson
Microsoft Access MVP
