My problem is two fold.
1) I want it to show details relevant to a customer when their name is selected from 3 separate filters. I have built some filter method already, using VB, so for example when Mr is selected from a combo box all surnames in the next combo box are filtered by Mr. That is working… I just need the details for that customer (address, telephone) to be shown on the form.
2) Then, once the details are loaded from the ‘Customer’ table I would like to enter a new order (for a magazine) on the same form. This new order placement would submit to a separate ‘Orders’ table, but is related to the customer previously specified. (I have already sorted the relationships…. I think
)
1) I want it to show details relevant to a customer when their name is selected from 3 separate filters. I have built some filter method already, using VB, so for example when Mr is selected from a combo box all surnames in the next combo box are filtered by Mr. That is working… I just need the details for that customer (address, telephone) to be shown on the form.
2) Then, once the details are loaded from the ‘Customer’ table I would like to enter a new order (for a magazine) on the same form. This new order placement would submit to a separate ‘Orders’ table, but is related to the customer previously specified. (I have already sorted the relationships…. I think
)
