I am having some problems with a form I am making.
-I want to use the form to find records that are in a table.
-I figure that I should base my form off a query, which will have all the fields from the table that I want on my form.
-I would like to use a combo box to help the user find the records quicker. The combo box will be a customer field.
-There will be no editing/adding of records, this is only for looking up data
Here is where things get tricky for me:
There are multiple records that will have the same customer (may end up using multiple combo boxes, so I may have to cascade<--I think that's the term). I would like it so that if the user selects a certain customer, all the records for that customer will show up on the form (maybe this will only work for certain types of forms?). Then they would be able to go through the records where the customer name matches what is selected in the combo box.
I do have a seperate table with a list of the customer names that I was thinking of using for the combo box and then join this table to the table with all the data. Both tables have customer name stored. My reasoning for this is that since the 'data table' has the same customer stored many times, in the combo box, the customer name would show up multiple times.
1) Is this process even possible using forms in access?
2) Which table should the combo box be based off?
3) do I have to bring both tables in the query (answer will depend on answer to question 2 I am sure)?
I am thinking that what makes this difficult is that more than one record will meet the customer name criteria, but I would like for them to view these results one at a time.
Thanks for any help!
Marcus
-I want to use the form to find records that are in a table.
-I figure that I should base my form off a query, which will have all the fields from the table that I want on my form.
-I would like to use a combo box to help the user find the records quicker. The combo box will be a customer field.
-There will be no editing/adding of records, this is only for looking up data
Here is where things get tricky for me:
There are multiple records that will have the same customer (may end up using multiple combo boxes, so I may have to cascade<--I think that's the term). I would like it so that if the user selects a certain customer, all the records for that customer will show up on the form (maybe this will only work for certain types of forms?). Then they would be able to go through the records where the customer name matches what is selected in the combo box.
I do have a seperate table with a list of the customer names that I was thinking of using for the combo box and then join this table to the table with all the data. Both tables have customer name stored. My reasoning for this is that since the 'data table' has the same customer stored many times, in the combo box, the customer name would show up multiple times.
1) Is this process even possible using forms in access?
2) Which table should the combo box be based off?
3) do I have to bring both tables in the query (answer will depend on answer to question 2 I am sure)?
I am thinking that what makes this difficult is that more than one record will meet the customer name criteria, but I would like for them to view these results one at a time.
Thanks for any help!
Marcus
