Peter Peterson
Member
- Local time
- Tomorrow, 08:29
- Joined
- Sep 14, 2020
- Messages
- 38
Good morning,
I have searched the Forum for an answer including:
data-entry-form-w-subform-creates-extra-records.313520/ which I don't think is related to my problem.
I am using Office 365 Pro on latest version of Windows 10.
This simple Access database is to help me manage my clients (outgrown the suitability of MS Outlook Contacts.
I have two tables, "Clients" and "Meetings" with a relationship one (client) to many (meetings).
I have set "Enforce Referential Integrity", not "Cascade Update Related Fields", nor "Cascade Delete Related Records"
Join Type is set to "Include ALL records from 'Clients' and only those records from 'Meetings' where the join fields are equal"
The Client table includes a List of where the Client is in my process - noting if I have a 'Lead', I have no Meetings in the "Meetings" table.
Not sure if this were my issue is but my Forms are showing the records in my tables correctly.
I have a "Clients" form and a "Meetings" subForm which is on the fourth tab of the "Clients" form.
I have four (4) Client records in my Clients table
one of which has two meetings recorded;
two of which have one meeting recorded each; and
one of which has no meetings recorded.
My Clients Form record navigator shows there are "4 of 4" records, however, it is counting (and showing) the Client with two meetings twice and not counting (or showing) the Client with no meetings. When using the 'next' record selector, the Form displays my second Client details twice, yet on the meeting sub-form the first meeting date is displayed twice, noting the sub-form record selector notes there are two meeting records (correctly). Clicking on the 'next' record on the sub-form works.
I have attached form images if this helps.
I look forward to learning the errors of my ways...
I have searched the Forum for an answer including:
data-entry-form-w-subform-creates-extra-records.313520/ which I don't think is related to my problem.
I am using Office 365 Pro on latest version of Windows 10.
This simple Access database is to help me manage my clients (outgrown the suitability of MS Outlook Contacts.
I have two tables, "Clients" and "Meetings" with a relationship one (client) to many (meetings).
I have set "Enforce Referential Integrity", not "Cascade Update Related Fields", nor "Cascade Delete Related Records"
Join Type is set to "Include ALL records from 'Clients' and only those records from 'Meetings' where the join fields are equal"
The Client table includes a List of where the Client is in my process - noting if I have a 'Lead', I have no Meetings in the "Meetings" table.
Not sure if this were my issue is but my Forms are showing the records in my tables correctly.
I have a "Clients" form and a "Meetings" subForm which is on the fourth tab of the "Clients" form.
I have four (4) Client records in my Clients table
one of which has two meetings recorded;
two of which have one meeting recorded each; and
one of which has no meetings recorded.
My Clients Form record navigator shows there are "4 of 4" records, however, it is counting (and showing) the Client with two meetings twice and not counting (or showing) the Client with no meetings. When using the 'next' record selector, the Form displays my second Client details twice, yet on the meeting sub-form the first meeting date is displayed twice, noting the sub-form record selector notes there are two meeting records (correctly). Clicking on the 'next' record on the sub-form works.
I have attached form images if this helps.
I look forward to learning the errors of my ways...