Sync Navigation Tables to Reflect Current Client

[wes9659]

A brief history I originally created a flat table to house funeral client informational data but I started having to limit myself I was over the 255 field limit. Someone suggested I break apart the data base into various tables and link other tables to those. My relationships are set to one to one, for the mere fact that one client can one chose one field (i.e. Client can only have one cemetery) I have created two forms frmClientDemographics which is parent form and hosts my autonumber field and frmCemetery so far and one frmProjectNavigation form. My issues are as follows:
1) When looking at data in the frmProjectNavigation form the field are not synced so when I go from frmClientDemographics form which created my Client Number it is not showing up on corresponding frmCemetery. Basically I want the autonumber to be reflected from the frmClientDemographicson to the frmCemetery, ClientID Field and the First, Middle and Last Name to correspond as well.
2) I originally tried to alter the record source for the project but it did not work I set it back to original. I could have done it wrong.
3) I have tried to comply with Access Naming rules



I uploaded the project to dropbox link is below
https://www.dropbox.com/s/7cbf9f0c62...HomeForm.accdb
I also attached it in zip folder here named Help I posted before but changed relationships back to one to one. I am using Microsoft Access 2013 64bit. I did download a project redone by Burrina but relationship fields SSN were in header of that nav form and was not sure how he did it.

Bill

[ItsMe]

Forms do not store data. Data is stored in tables. Use queries to retrieve data that is stored in tables. Use forms and reports to display data to users (GUI).

If a specific form is not displaying data that is in a table, adjust the form's recordset. Check the query your form is based on. Adjust the query to retrieve the desired dataset. Another thing that affects the data displayed on a form is the form's Filter property.

[wes9659]

Thank you ItsMe Ok Novice here. My forms I thought were based on the tables I originally created which store my data. If I create one massive query it says I have too much information to query. Should I create a query for each form? As far as record set how would you change it? I know where it is but what would you change it too? I would greatly appreciate if someone would change form and re-upload it so I can visualize and follow along with steps as to what occurred.

[ItsMe]

Should I create a query for each form?

You do not have to. You can use a table object as a form's Record Source. If you are using a table as the form's Record Source, all data in the table will be available through the form's recordset. In effect, you have what is referred to as a table dump.

As far as record set how would you change it?

Using a query allows you to be selective about what data is retrieved from the table(s). Using a query, you can Join two tables together and then SELECT certain columns of data without selecting all of the columns available. You can also add criteria to the query. For instance, you can retrieve data that matches criteria greater than 12 or less than 200.

I know where it is but what would you change it too?

In order to create queries, you need tables. Your tables should be Normalized in their structure. If you understand basic principles of RDBMS, creating queries is much easier than if you do not.