Solved SYNCHRONISED DATA BETWEEN FORMS

[dubiousp]

Good morning Im building a DB with form access that I can run on PC tablet, I should also add appologies Im a newbie. The main form contains basic information but then should set the trend index for the other data

For example the basic for has a button that opens second form called OBS1 whilst my first form contains data the second form does not sync with the id so the data is all over the show..

Would appreciate any help many thanks

 

[MajP]

Your tables are not correct so this does not make any sense.
I am assuming you have multiple observations per incident. So you shoud have a table Incidents ( "Basic") and a single table of Observations. In this table you would have a field Observation Number 1st, 2nd, 3rd ... . This table should have a field IncidentID_FK which is a foreign key relating to the incident "Basic". Now you have a 1 Incident to Many observations.

 

[MajP]

Also this is normally done in a Main form with a Subform. Then you can see all the Incident information above and all observations below. Then it is easier to "Synch" an observation to an incident.

 

[dubiousp]

Is it then possible to make the sub form pop up in a seperate form so data entry looks more pleasant

 

[plog]

Is it then possible to make the sub form pop up in a seperate form so data entry looks more pleasant

You need to put away the forms, you are a long way from working with them yet. What you need to focus on is your tables. No point building amazingly beautiful input screens if you are just throwing the data that gets put in them down a hole.

The process of setting them up properly is called normalization:

Database normalization - Wikipedia

en.wikipedia.org

.

Check out that link, do a few tutorials and then apply the principles to your tables. When you are done, complete the Relationship Tool, expand all the tables so you can see all the fields, take a screenshot and post it back here.