multiple tables update

[jjatcal]

Hello, I have the following tables created from fields of a paper application form:

Personal (address, phone, etc)
Organization Type
CourseWorkCompleted
PreferencesConstraints
Education
Ethnicity/Gender
....

When I receive an application, I need to take this information into Access. If I create a form that includes ALL the fields from ALL the tables, is that the best way to ensure that all information for a given applicant gets added to the many tables I have.

There are also times when only one table in addition to the main table (Personal) gets updated. For example, ApplicantTracking. Should I create a form with all the fields from Personal and ApplicantTracking?

Thanks.

 

[dhookom]

Please check my response in another thread you started. I would normalize and then use subforms on a multi-page tab control for each of the related tables. Your main form would be based on the Personal table and the other tables would be contained in subforms.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.