I have two tables:
- Customer Master – which has Customer Name as a field
- Transaction Details – which has Purchase Date as a field
I would like to create a form in MS Access that will allow the user to select the Customer Name in a combo box and then select the Purchase Date in another combo box. The subform would then display all the purchases the customer made on that particular date.
When I add the combo box to look up the date, it is listing all of the dates in the Transaction Details table, including the duplicates, which is not what I need. I only need the dates that pertain to the Customer Name that the user has selected.
How can I go about doing this?
Please help as I am new to Access.