Problem Sharing data between 2 forms

[Guest]

I'm in the process of combining two seperate databases to eliminate unneeded
repetion and I'm having problems with forms. I'll try to explain this as
bext I can. I currently have two forms FPY and NCR that are linked to tables
titled FPY Table and NCR Table. I want to set it up where the user puts
information into the FPY form and then clicks a button if he needs to fill
out the NCR form as well. Some of the same information from the FPY form is
contained on the NCR form. I would like that information to already be
filled in on the NCR form to eliminate extra work. For example, the user
enters in the shop order # on the FPY form amongst other items. Then the
user clicks the "Create NCR" button which brings up the NCR form with the
shop order # already entered. The user then proceeds to fill out the rest of
the form. I hope this makes sense. Thanks for your help.

 

[Douglas J Steele]

Data on forms comes from tables. You should never store data redundantly.
That means that once FPY has stored the data in the table, NCR should get
that data from the table.