NickLes518
Registered User.
- Local time
- Today, 15:55
- Joined
- Mar 12, 2010
- Messages
- 11
Ok, bear with me on this explaination as it is hard to put into words, so i have a working database (attached below).
The NewEntry form allows people to enter data for a new job. In this form I have a cascading combo box 'Materials' which displays the available materials when a plumbing 'Category' is selected.
My goal is to build on the NewEntry form to be able to select multiple materials that relate to the category and job I have selected. Basically, I want everything to display similar to what I have now, only instead of having the multiple materials display in a my qryDatasheet or table Datasheet in the 'Material' field as [Material#1, Material#2, Material#3] I want each material to display in its own row in the 'Material' column. My reason for doing this is, I want to reverse-populate the 'TotalMaterial' and 'TotalLabor' values from the Category to a Material and Labor value for each Material using a percentage I select for that Material. The format I would like for my query or datasheet can be seen in my second attachment excel doucment 'EstimateFormat' (everything above the black line needs to be 1 record as it is all part of the same job)
Does anyone know how to obtain this? Is there anything like a sub-query that can do this?
Also, I know I will have to make format changes and probably change the material combo box to a list box, so please ignore that for now, I am more concerned with the format of my query and data at the moment.
Thanks for the help!
The NewEntry form allows people to enter data for a new job. In this form I have a cascading combo box 'Materials' which displays the available materials when a plumbing 'Category' is selected.
My goal is to build on the NewEntry form to be able to select multiple materials that relate to the category and job I have selected. Basically, I want everything to display similar to what I have now, only instead of having the multiple materials display in a my qryDatasheet or table Datasheet in the 'Material' field as [Material#1, Material#2, Material#3] I want each material to display in its own row in the 'Material' column. My reason for doing this is, I want to reverse-populate the 'TotalMaterial' and 'TotalLabor' values from the Category to a Material and Labor value for each Material using a percentage I select for that Material. The format I would like for my query or datasheet can be seen in my second attachment excel doucment 'EstimateFormat' (everything above the black line needs to be 1 record as it is all part of the same job)
Does anyone know how to obtain this? Is there anything like a sub-query that can do this?
Also, I know I will have to make format changes and probably change the material combo box to a list box, so please ignore that for now, I am more concerned with the format of my query and data at the moment.
Thanks for the help!
