G
Guest
This is probably a quick one. I have a subform for Orders.
One this there is an address drop down, so you can pick the address for
the order. The main form is for the customer.
So a customer has multiple orders. There is another subform on a tab
for addresses. A customer may have multiple addresses.
The combo box on the orders subform should filter to only the address
on the address subform. More precisely, the address combo should
filter to just the addresses for that customer.
Any ideas on how to make this work?
I'm under the gun to get this done.
Thanks for any help.
One this there is an address drop down, so you can pick the address for
the order. The main form is for the customer.
So a customer has multiple orders. There is another subform on a tab
for addresses. A customer may have multiple addresses.
The combo box on the orders subform should filter to only the address
on the address subform. More precisely, the address combo should
filter to just the addresses for that customer.
Any ideas on how to make this work?
I'm under the gun to get this done.
Thanks for any help.