Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Other Development Tools  Nested Recordset Equivalent

Author  Topic  benjiga Starting Member 1 Post Posted - 2007-07-30 : 16:11:15 Hi all, I need some help and the answer might be obvious to some of you. If you have a db that returns unassigned work orders and gives you the option to assign to one of many tech(s)that has the specific skills for that work order. Property Table >> JOB TABLE >> FIELD TECH TABLE w/ MATCHING SKILLS NEW WORK ORDER >> JOB TYPE >> Assign to Capable Crew 150 Burbank Ave >> Eviction >> CREW 1, CREW 2, CREW 3 (AS LIST/MENU) 1120 Garibaldi >> Clean Roof >> CREW 1, CREW 4 (AS LIST/MENU) I think I could achieve my desired reults with an iframe that has a recordset based off of passed variables but I know that isn't the smartest way to do it. Any help, Ben Thanks.