Hi guys! My question is: is there a way to synchronize two forms for data entry? My first form is used to personal information (Patients) then I have a button that opens another form to enter clinic information using tabs (Call logs, treatment, etc....), it worked great when there was data already entered, but when I erased the examples dope! They were no longer sync because there is nothing to link them. How can I make the second form coincide with the first? Both have a primary (auto) Key! Un auto the key on the second form? Help!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
syncronizing two forms for data entry? 1
- Thread starter Jeddiah
- Start date
-
1
- #2
thornmastr
Programmer
Are you using a main form subform configuration, or are you using multiple independant forms tied to one underlying record. A little more information, please. Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com
- Thread starter
- #3
These are two independent forms. The link is patientID. There are two tables:
Table1
PatientID (autoKey)
PatientName, etc.....
Table2
ClinicID (autoKey)
PatientID (Index-duplicatesOK)
Other Info........
Query with these tables combined for form 2. The main form uses table1.
Table1
PatientID (autoKey)
PatientName, etc.....
Table2
ClinicID (autoKey)
PatientID (Index-duplicatesOK)
Other Info........
Query with these tables combined for form 2. The main form uses table1.
thornmastr
Programmer
Thanks for the additional information. I would suggest you use a main form sub form combination with your main form attached to your first table, and the sub form attached to table 2. The linking field, of course, is patientid. Make sure the allow additions properties of both forms is set to yes and that you have related your tables and that you are using referential integrity.
Now, even when you have two empty tables, when you open the form, both the main form and the sub form will come up in add mode. You add a record to the main form and then go to your sub form and add all the information. You can certainly have multiple entries to your sub form that will relate to one main form record source. The underlying record of the subforms will pick up the forward key from the main form automatically.
Hopefully this will get you going rather nicely.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com
Now, even when you have two empty tables, when you open the form, both the main form and the sub form will come up in add mode. You add a record to the main form and then go to your sub form and add all the information. You can certainly have multiple entries to your sub form that will relate to one main form record source. The underlying record of the subforms will pick up the forward key from the main form automatically.
Hopefully this will get you going rather nicely.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com
- Thread starter
- #5
Sounds doable, but my main form has a page break in it, seperating personal information and insurance information, form2 has tabs controls that seperates the clinic vists information, appointments, treatment, cost etc. What if I use a few fields from table2 on my main form, will that generate a record in table2, creating a link thus allowing me to open form2 in sync with my main form? Or suggest anothe setup.
- Status
Similar threads
