I have a table that contains customer addresses and a table that contains information on different events that a customer can take part in. The customer addresses table can contain multiple addresses per customer. I created a view, joining the tables on the shared value 'customer_ID'.
What I want to do create a submission form that will allow the customer to sign up for an event, and have a lookup table based on the customer addresses table that will filter the addresses to only show the addresses that are associated with that customers customer_ID. This way they don't have to scroll through all the addresses in the customer address table.
Is this doable?