Hi Graeme, thanks for the help, but sorry im still not satisfied with the query, for more clarification... - what i want is to run first the query then i will link a drawing, This Project... (Table with geometry column) Source: the query - then i can use the query toolbar selecting the TIME: 07:30, that should highlight the CLASSROOM drawing equal to the ROOMID selected from SCHED. - i dont want to merge all CLASSROOM drawings because i just want to tile vertically the MAPS for every CLASSROOM/BLDG coz it has different floors also, i just didn't indicate in my table. - attached herewith is the query that works (compliments from atomek) but it's for CLASSROOM1 only, how about linking with CLASSROOM2, or multiple drawings. from atomek: SELECT c.[geom (I)], t.* FROM [CLASSROOM1] c JOIN [SCHED] t ON c.[ROOMID] = t.[ROOMID] please help me again. Attachments: CLASSROOM_SCHED_query.map
|