ok this is the sql union code
the names of the tables and forms are different in my db
i used tbl1,tbl2 for exemple
Code:
SELECT "tbl1" as tablename, [id], tbl1.[lastname], tbl1.[firstname]
FROM tbl1
union
SELECT "tbl2" as tablename, [id], tbl2.[lastname], tbl2.[firstname]
FROM tbl2
Union
SELECT "tbl3" as tablename, [id], tbl3.[lastname], tbl3.[firstname]
FROM tbl3
Union
SELECT "tbl4" as tablename, [id], tbl4.[lastname], tbl4.[firstname]
FROM tbl4
Union
SELECT "tbl5" as tablename, [id], tbl5.[lastname], tbl5.[firstname]
FROM tbl5
Union
SELECT "tbl6" as tablename, [id], tbl6.[lastname], tbl6.[firstname]
FROM tbl6 ;
the names of the tables and forms are different in my db
i used tbl1,tbl2 for exemple