Michael Davidson
|
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.
table1
cust_id
name_c
table2
contact_id
custlink_id
name_c
table3
task_id
custlink_id
contactlink_id
taskname_c
description_c
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
michael@picturesquedesigns.com
|
|
|
|