Hello,
I have Customers recorded and a number of addresses associated with each customer.
They are in two tables linked by CustomerID and are shown in forms as frmCustomers & subfrmCustomerAddresses.
From frmCustomers, I open another form which records the orders maid by that customer. What I would like on this form is to select the customer address to be used for the order.
I can build a combo, but this shows all addresses on the database. What I would like for the combo to show only the addresses for that customer only.
I do not want two combos, one which selects the customer and then another which shows the addresses. This is not very user friendly to ask for the customer again. I would like one combo to show addresses for the customer on the form.
I would be grateful for any guidance on how I can achieve this.
Thank you.
I have Customers recorded and a number of addresses associated with each customer.
They are in two tables linked by CustomerID and are shown in forms as frmCustomers & subfrmCustomerAddresses.
From frmCustomers, I open another form which records the orders maid by that customer. What I would like on this form is to select the customer address to be used for the order.
I can build a combo, but this shows all addresses on the database. What I would like for the combo to show only the addresses for that customer only.
I do not want two combos, one which selects the customer and then another which shows the addresses. This is not very user friendly to ask for the customer again. I would like one combo to show addresses for the customer on the form.
I would be grateful for any guidance on how I can achieve this.
Thank you.
