Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

relationship problem

Status
Not open for further replies.

aspnet98

MIS
May 19, 2005
165
US
I have a report that runs the way I need it to run. I have no access to the single data source it feeds from but I can link to it.

The report displays various activities by username group on a group id and a week id.

I have another table called configs that has settings i need to select on per user (one for record for every user in the group id). I need to make some type of select list from this based on the settings.

the configs has a field called email 1 or 0. i need to select all of the group ids that have this in the report.

I cannot link the group id to groupid from configs to the main table, they are not relational and cause the data to double/triple etc.

How can I use the one table to formulate a set of ids then use those as selection criteria in the second report???

best regards.
sql server 2000 and i do have access to the sql commands.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top