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