CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Customer Support Application - tying 3 tables together

Print topic Send  topic

Author Message
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


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.