Multiple Tables updated from one form

[Guest]

Access 2007
I may be going about this the wrong way, but I have 4 tables:
Customer; Farm; Field; Main.

1. I have a form that I want to be able to enter a customer name, farm name,
and field name into and after clicking an "Add" button, I want the associated
values (i.e. IDs) to be entered into the main table. If the Customer Name is
not in the Customer Table I want it automatically added. The same with Farm
and Field. (The IDs are auto numbered) My combo box on my form is tied to
each respective table and also to the combo box before to filter down the
list.

2. I also want a form off of the main table that shows the Customer, Farm &
Field Names but are protected to keep from any accidental changes but still
be able to update other parts of the form.

My questions are how do I setup my form so that it updates the main table
but is not the form directly linked to it and what code do I use to enter
these values into my customer table?

Any help would be appreciated, I am a novice at access.

 

[Jeff Boyce]

It all starts with data (not forms)...

If you want to get the best use of Access' relationally-oriented features
and functions, you have to feed it well-normalized data (and not 'sheet
data).

The answers to your questions are "depends" ... it depends on how your
tables are designed and related.

If the topics of Normalization and Relational Database are also new to you,
spend some time away from your Access application learning about these. If
you already understand these, please post back a description of your
tables/relationships.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP