sdjames1979
Registered User.
- Local time
- Today, 18:05
- Joined
- Jun 16, 2015
- Messages
- 25
Hi
I have three tables:
Clients (list of)
Items (electrical items within Clients building)
ServiceHistory (Service history dates, etc for each item)
When I go into the Clients table (under Datasheet view), the Items that belong to the Client are shown in the subdata sheet. The Items Table (under Datasheet view) shows the Service History in the subdata sheet. All good.
However, I have created a form, based on the 'Clients' table, looks great and has the 'Items' table in a subform at the bottom of the page. Unfortunately, the 'Service History' subsheet doesn't appear under the relevant Item - no subdata sheet available.
Please help.
I have three tables:
Clients (list of)
Items (electrical items within Clients building)
ServiceHistory (Service history dates, etc for each item)
When I go into the Clients table (under Datasheet view), the Items that belong to the Client are shown in the subdata sheet. The Items Table (under Datasheet view) shows the Service History in the subdata sheet. All good.
However, I have created a form, based on the 'Clients' table, looks great and has the 'Items' table in a subform at the bottom of the page. Unfortunately, the 'Service History' subsheet doesn't appear under the relevant Item - no subdata sheet available.
Please help.
