Form

B

bdehning

-- Not sure if I posted this as I have computer issue.

I have Form that I am trying to create that will allow users to search
previous table information for Account Information and a location and then
create a new record based on this location and previous table information.

They would then complete the remaining fields on the form. I need all
fields to go back into the tables as new records.

I have a 3 table database with 1-many relationships and have tried subforms
which gets me close but I keep getting errors that this will create duplicate
field data.

The issue is trying to use existing data and then pull and create and use
with a new
record? Want to avoid entering in the previous information.
 
B

bdehning

Almost got it but I have one field that is still an issue. I used a form
based on main table and then placed subforms on the main form.

My issue is that my middle table of the (3) 1-many table relationship has a
field called Location Servicing Division which has records already assigned
to certain users. By me using this table to show and pick up already entered
fields creates a situation when I use my last subform which is based on table
#3. I need to use the field Location Servicing Division again but not change
the existing records. I have reports based on forms filled out with the
field from the 2nd table used.

If I use the form as is there is no way for a user who was not the original
assigned person to get the record after the form is filled out with the
Location Servicing Division for the person completing this form as it will
use the previously established data.

Do I need to use some sort of union query to be able to collect the data in
the 3 rd table but feed it back to the 2nd table fields, or is my table
structure more the issue possibly for this one field?
 
Top