I have Two tables...
Field2(from table 4) is Invoice No nad
Field1(from qry_invoice_main_sub) is items of invoice
Now suppose i create 1 Invoice with 5 items ...
And when i generate query with the help of form .... it shows me 5 duplicate entries.
SELECT Table4.Field1 AS FirmCode...