E
Eddie Ward
Mental block here!
I have a table for companies and a table for company contacts and I want to
create a form whereby when I select a company from a drop down it changes
the next drop down to only pre entered contacts from that company.
Thus when I am adding an order record via a form I select the company first
then it filters down the company contacts to that company - I then select
one of those contacts and the next fields are updated to display that
company contacts contact details (which are already in his table record)
I hope this makes sense
Ed
I have a table for companies and a table for company contacts and I want to
create a form whereby when I select a company from a drop down it changes
the next drop down to only pre entered contacts from that company.
Thus when I am adding an order record via a form I select the company first
then it filters down the company contacts to that company - I then select
one of those contacts and the next fields are updated to display that
company contacts contact details (which are already in his table record)
I hope this makes sense
Ed