Hey u do have views in Access right instead of the temp table store the result in the view and then query the view( i.e you save the query that you write on the access these themselves act as views)

Query the saved query which would act as a temp table

Hope this helps:D

Rgds
pratap

http://www.codeproject.com/cs/databa..._databases.asp

The following works in Access - I tried it.

Modify the ParentChild table as follows.

id int identity not null
father int null
mother int null
description varchar(100) null

Query

SELECT ParentChild.description AS Name, ParentChild_1.description AS Father, ParentChild_2.description AS Mother
FROM (ParentChild LEFT JOIN ParentChild AS ParentChild_1 ON ParentChild.father = ParentChild_1.id) LEFT JOIN ParentChild AS ParentChild_2 ON ParentChild.mother = ParentChild_2.id;

Best wishes,



Rand