Hi,
I've got a bit of a problem and hope someone can help me.
Database Overview
Okay, so the database has to record each client, and every sale for each client (every client may have more than one sale). For every sale, we may also need to record other information (such as payments, contact history etc).
The Set-Up so far
The database has one main form [Customers] which has a subform on it [Sales], this subform is used to record all the sales. There is also another subform [Payments] on the main form BUT it is linked to [Sales] subform, so for every sale we are able to record individual payments for each sale (so if I click on sale one in the [Sales] subform it will only show me the payments for that in the [Payments] subform and so on.
The Problem
I need to add another two sub-forms to link in the same way [Payments] is linked to [Sales], preferably on a tab page on the same main form [Customers]. Originally the database was made by someone else and I can't get in touch with them right now but I have been able to do the following so far:
- Created subform [History] on the [Customers] main form
- Linked it (Link Master Field/Link Child Fields) to [Sales]
BUT it doesn't work in the same way [Payments] does. What is happening is, even though I have got more than 1 sale, it doesn't create a seperate file for each sale within the [History] subform, it only takes into account the first sale and when I click on the 2nd/3rd file the same data is showing up. Also when I try and create it on a tab page (tab control) it only lets me link the subform to [Customers], is there anyway around that.
Also, thanks in advance
I've got a bit of a problem and hope someone can help me.
Database Overview
Okay, so the database has to record each client, and every sale for each client (every client may have more than one sale). For every sale, we may also need to record other information (such as payments, contact history etc).
The Set-Up so far
The database has one main form [Customers] which has a subform on it [Sales], this subform is used to record all the sales. There is also another subform [Payments] on the main form BUT it is linked to [Sales] subform, so for every sale we are able to record individual payments for each sale (so if I click on sale one in the [Sales] subform it will only show me the payments for that in the [Payments] subform and so on.
The Problem
I need to add another two sub-forms to link in the same way [Payments] is linked to [Sales], preferably on a tab page on the same main form [Customers]. Originally the database was made by someone else and I can't get in touch with them right now but I have been able to do the following so far:
- Created subform [History] on the [Customers] main form
- Linked it (Link Master Field/Link Child Fields) to [Sales]
BUT it doesn't work in the same way [Payments] does. What is happening is, even though I have got more than 1 sale, it doesn't create a seperate file for each sale within the [History] subform, it only takes into account the first sale and when I click on the 2nd/3rd file the same data is showing up. Also when I try and create it on a tab page (tab control) it only lets me link the subform to [Customers], is there anyway around that.
Also, thanks in advance
