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 realtionships and have tried subforms
which gets me close but I keep getting errors that this wil create duplicate
field data.
The issue is trying to existing data and then pull and use with a new
record?
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 realtionships and have tried subforms
which gets me close but I keep getting errors that this wil create duplicate
field data.
The issue is trying to existing data and then pull and use with a new
record?