G
Gary
I have 2 tables.
tbl_Customer
tbl_Contact
I have created a form (frm_Customer) that contains the fields from
tbl_Customer. And within this form, I have a subform (subfrm_Contact) that
has fields from tbl_Contact.
The subform has a navigation buttons bar as does the form frm_Customer.
One customer may have several contacts associated with it.
Properties -- frm_Customer has a record source: qry_SrchCustomer
Properties -- subfrm_Contacts has a record source: qry_Contact
qry_SrchCustomer & qry_Contact has the 2 tables and their respective fields
tbl_Customers:
CustID (primary key)- autonumber
CustDate
CompName
tbl_Contacts:
ContactID (primary key)- autonumber
CustID
CompName
ContactName
The join properties between the 2 tables (link: CustID to CustID) in this
query are:
"Include ALL records from tbl_Customer and only those records from
tbl_Contacts where the joined fields are equal."
In subfrm_Contact - I would add a new contact for a given customer. The
navigation buttons bar naturally acknowledges this addition by indicating
eg. 2 of 2.
PROBLEM: When this addition happens, I notice the navigation buttons bar
for frm_Customer also adds another record number to its count. The count for
this should always show 1 of 1 no matter how many additional contacts I add
(in subfrm_Contacts) for this 1 customer. Help.
Note: The relationships window has no links between the two tables. The
linking between the two only occurs in the query's mentioned above.
tbl_Customer
tbl_Contact
I have created a form (frm_Customer) that contains the fields from
tbl_Customer. And within this form, I have a subform (subfrm_Contact) that
has fields from tbl_Contact.
The subform has a navigation buttons bar as does the form frm_Customer.
One customer may have several contacts associated with it.
Properties -- frm_Customer has a record source: qry_SrchCustomer
Properties -- subfrm_Contacts has a record source: qry_Contact
qry_SrchCustomer & qry_Contact has the 2 tables and their respective fields
tbl_Customers:
CustID (primary key)- autonumber
CustDate
CompName
tbl_Contacts:
ContactID (primary key)- autonumber
CustID
CompName
ContactName
The join properties between the 2 tables (link: CustID to CustID) in this
query are:
"Include ALL records from tbl_Customer and only those records from
tbl_Contacts where the joined fields are equal."
In subfrm_Contact - I would add a new contact for a given customer. The
navigation buttons bar naturally acknowledges this addition by indicating
eg. 2 of 2.
PROBLEM: When this addition happens, I notice the navigation buttons bar
for frm_Customer also adds another record number to its count. The count for
this should always show 1 of 1 no matter how many additional contacts I add
(in subfrm_Contacts) for this 1 customer. Help.
Note: The relationships window has no links between the two tables. The
linking between the two only occurs in the query's mentioned above.