|
| |
|
|
cdrees
Posts: 42
Joined: 8/4/2004
Status: offline
 |
Display results from four tables - 8/7/2007 17:02:54
Hey all,
Quick question... I have a results form that has a main table (audit) and three other tables that contain model number, requestor and status. Each of those tables has a table_id, which corresponds to the table_id in the audit table.
In other words, the audit table has:
audit_inv_id
audit_srvNAme
audit_status_ID
audit_date
audit_modelID
audit_reqID
action
The requestor table has:
req_id
req_lastname
req_firstname
etc., etc..
In my main form I want to display
Server Name - Status - Model - Date - Requestor - Action
===============================================
Name 1 6 7/7/2007 3 Inserted
So basically, the actual records in the audit table contain just ID for status, model, etc. The labels (or names) for what they mean live in their respective table.
I want to lookup the value of each, and return those values in my form. For whatever reason, I not quite getting it to work...
I'm using Dreamweaver, ASP and SQL 2000 with IIS 6.0. Thanks!
Any help would be appreciated!!
Regards,
Christopher Rees
President,
Palaestra Training
www.palaestratraining.com
1-800-324-0946
|
|
|
|
cdrees
Posts: 42
Joined: 8/4/2004
Status: offline
|
RE: Display results from four tables - 8/8/2007 14:03:59
Actually I want to show a dynamic list.. no drop downs, so it's basically a dynamically generated table of just text - no fillable fields, with the data being pulled from 4 tables.
The main table has on the IDs for several fields, those IDs correspond to the field names that exist in the other tabels ("lookup" tables)
Thanks!!
| |
|
|
|
mar0364
Posts: 3072
Joined: 4/5/2002
From: Florida, US
Status: offline
|
RE: Display results from four tables - 8/9/2007 8:40:06
Sounds like you just need to write a SQL statement. I would try creating my statment in design view if your not real good with SQL.
_____________________________
Easy Web
“Stay committed to your decisions, but stay flexible in your approach.”
| |
|
|
|
rdouglass
Posts: 9187
From: Biddeford, ME USA
Status: offline
|
RE: Display results from four tables - 8/9/2007 9:57:43
quote:
Sounds like you just need to write a SQL statement.
I agree. I'd start looking at the UNION command. That's what it does.
<$.02>
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
