I have 2 tables:
- address id, customer id, and address (customer’s can have more than one address they use)
- a table where they type in a customer id. They then need to add an address. I want to display the address id table and let them pick from there or enter an new address. I only want them to see address that have already been assigned to that customer id, but I am seeing all address.
It is a dependent dropdown type of list.
so enter customer then see all address for that customer from table 1, and be able to add a new on if no choosing from list.
Addresslist[Address] is what I put in the Suggested values for the address on the 2nd (input table) but I still see all addresses from table 1.
I appreciate any help! thanks