Hi there,
I started using this software this very month and I don't have the basics nor the knowledge to truly understand the way Microsoft Access works. I apologize for the lack of synthesis.
I created a form with two subforms that contain two main tables with 380k and 180k records. Now I'd like to link this two subforms to a set of combo boxes to filter data and display the result in the form in table view. I'd like to give you some background so that maybe it will be easier for you to help me out with this:
we are an automotive parts company and I work in the marketing department. What I would like to achieve for my market analysis is a database that can tell me what is the potential market of my Part Number's. Each PN has its own potential market according to: (the number of vehicles the PN is linked to) * (the Population of those vehicles in that particular market).
I'm following two markets right now: Italy and Greece (couldn't have better markets uh). So I created two different subforms, one for each country. These big tables have no primary keys, but they do have indexes in those fields I use to filter data. The fields are:
Part Number (indexed); Discount Group (indexed); Product Group 1 (indexed); Product Group 2 (indexed); FAS-key (indexed); FAS-Population; Vehicle type.
Note that the FAS-Key is the code for the Vehicle type. Each one of these codes is associated to one or more PN's.
The DB has the following structure:
tblItaly: 380k records
tblGreece: 180k records
tblDG-PG1-PG2: a table that contains 99 Discount Groups, 60 Product Group 1 and 89 Product Group 2.
frmAnalysis: the main form
subfrmAnalysis IT: the subform for the Italian market
subfrmAnalysis GR: the subform for the Greek market
I wanted to illustrate you the DB structure because I guess it is not efficient at all, so if you have suggestions...
Apart form that, I managed to add a combo box for the Discount Groups, cboDG, by using those master-child links as a option in the subform. Problem is, when i add more combo boxes (cboPG1 and cboPG2), they all stop working.
Do you have any suggestion/consideration to make it work?
I started using this software this very month and I don't have the basics nor the knowledge to truly understand the way Microsoft Access works. I apologize for the lack of synthesis.
I created a form with two subforms that contain two main tables with 380k and 180k records. Now I'd like to link this two subforms to a set of combo boxes to filter data and display the result in the form in table view. I'd like to give you some background so that maybe it will be easier for you to help me out with this:
we are an automotive parts company and I work in the marketing department. What I would like to achieve for my market analysis is a database that can tell me what is the potential market of my Part Number's. Each PN has its own potential market according to: (the number of vehicles the PN is linked to) * (the Population of those vehicles in that particular market).
I'm following two markets right now: Italy and Greece (couldn't have better markets uh). So I created two different subforms, one for each country. These big tables have no primary keys, but they do have indexes in those fields I use to filter data. The fields are:
Part Number (indexed); Discount Group (indexed); Product Group 1 (indexed); Product Group 2 (indexed); FAS-key (indexed); FAS-Population; Vehicle type.
Note that the FAS-Key is the code for the Vehicle type. Each one of these codes is associated to one or more PN's.
The DB has the following structure:
tblItaly: 380k records
tblGreece: 180k records
tblDG-PG1-PG2: a table that contains 99 Discount Groups, 60 Product Group 1 and 89 Product Group 2.
frmAnalysis: the main form
subfrmAnalysis IT: the subform for the Italian market
subfrmAnalysis GR: the subform for the Greek market
I wanted to illustrate you the DB structure because I guess it is not efficient at all, so if you have suggestions...
Apart form that, I managed to add a combo box for the Discount Groups, cboDG, by using those master-child links as a option in the subform. Problem is, when i add more combo boxes (cboPG1 and cboPG2), they all stop working.
Do you have any suggestion/consideration to make it work?
