|Posted: 12/04/2002, 3:48 PM
I am creating a customer support site. When someone calls in a software
issue, I'd like to be able to have the user select the customer name
(table1) then choose add task. I'd like to have the task form display the
customer name and below that have a popup showing just the contacts (table2)
for this customer. The task gets stored in table3 along with the ids for
table1 and table2. Here's a summary of the tables.
I can get the customer name to show just fine but the pull down for the
contact name shows every contact record for all customers. Any attempt to
limit it results in an error message. Any ideas?
Thank you, Michael