create a new query from the table that contains only ID's
i've added also the other fields from other tables related to the main table with ID's
so now on the query i have :
Code:
[tblroomlist].[room] [tblbuilding].[building] [tblfloor].[floor] [tblarea].[area] [tblData].[roomid] [tbldata].[buildingid] [tbldata].[floorid]
Leave a comment: