Hi,
I know this is probably a dumb question, but here goes:
I have 3 tables:
REGION
REG_ID
REGION
LOCATION
LOC_ID
REGION
LOCATION
EMPLOYER_FIELDS
employee_id
location
region
I need to create a form that will update the employer fields.
I created a form based on a general query of the table, put the fields
and several buttons. There are 2 fields, however that need to be combo
boxes that lookup values and then update the employer_fields table.
I need the location to be updated only for it's specific region. I
used 2 combo boxes and can get them to do this, but they get their
values from the 2 lookuptables (and not the table that is being
updated) and I need to take those 2 values selected and when the add
button or save button is pushed (those are on the form already), the
record on the employer_fields table is updated with the values chosen
from the comboboxes in the form.
Any ideas?
Thanks.