better
03-10-2006, 11:35 AM
Hey gang,
As the title implies, I'm trying to compile a task list for MS Project from fields in several tables. Here's the structure...
Tables: Columns: Relationships: 1:Many
ACS (CPU, PS, AP, SVR, WS, Location, JN)
CCTV (RK, CS, DVR, MUX, MAT, MON, CTR, FIX, PTZ, Location, JN)
IDS (CP, IM, OM, AM, PS, CON, PIR, GB, PB, KP, SI, Location, JN)
SvcDrops (HWAC, SOAC, DOAC, QOAC, PH, NW, Location)
Locations (ACS, CCTV, IDS, Location, JN)
The tables for each of the systems (ACS, CCTV, IDS, SvcDrops) are populated with numeric values. Each table also has a PkID (Primary Key). What I need to do is to create a task list table and pupulate it with data from these tables in a specific format:
Location 1
"ACS"
Access Point 1
Access Point 2... (through value of [ACS.AP] record related to Location 1)
"CCTV"
Fixed Camera 1...
PTZ Camera 1...
Monitor 1...
Controller 1...
...and so on and so forth for IDS and SvcDrops. However, records in the new table need only be created if the corresponding column value is not 0, and the systems need only be listed if the value of the corresponding system in Locations is 1.
Can anyone help get me pointed in the right direction with this?
Thanks alot!
Bart
As the title implies, I'm trying to compile a task list for MS Project from fields in several tables. Here's the structure...
Tables: Columns: Relationships: 1:Many
ACS (CPU, PS, AP, SVR, WS, Location, JN)
CCTV (RK, CS, DVR, MUX, MAT, MON, CTR, FIX, PTZ, Location, JN)
IDS (CP, IM, OM, AM, PS, CON, PIR, GB, PB, KP, SI, Location, JN)
SvcDrops (HWAC, SOAC, DOAC, QOAC, PH, NW, Location)
Locations (ACS, CCTV, IDS, Location, JN)
The tables for each of the systems (ACS, CCTV, IDS, SvcDrops) are populated with numeric values. Each table also has a PkID (Primary Key). What I need to do is to create a task list table and pupulate it with data from these tables in a specific format:
Location 1
"ACS"
Access Point 1
Access Point 2... (through value of [ACS.AP] record related to Location 1)
"CCTV"
Fixed Camera 1...
PTZ Camera 1...
Monitor 1...
Controller 1...
...and so on and so forth for IDS and SvcDrops. However, records in the new table need only be created if the corresponding column value is not 0, and the systems need only be listed if the value of the corresponding system in Locations is 1.
Can anyone help get me pointed in the right direction with this?
Thanks alot!
Bart