On Fri, 3 Jul 2009 05:01:01 -0700, Naveed Pathan wrote:

hiiiiii i am so confused about the table design what i want to do can't ;
for example i want two table which all about invoicing such as

TABLE ONE
[INVOICE #]

TABLE TWO

[INVOICE #]

[SNO]

[ITEM]

[PRICE]

SO I WANT TO PRODUCE AN INVOICE LIKE THIS FOR PRINTING BUT I AM CONFUSED HOW
TO DO LIKE THAT

INVOICE # SNO ITEM PRICE

1 1 APPLE 3
2 BANANA 2
3 MANGO 10
4 ORANGE 7
5 CHERRY 4

Note : i don't want to repeat the [invoice] though [SNO] SHOULD BE REPEATED
NO PROBLEM

THANKX

Did you try setting the [Invoice] control's Hide Duplicates property
to Yes?
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail