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

i am sorry how to do that

thankx
"fredg" wrote:

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


In Design View select the condtol and display it's property sheet.
click on the Format tab.
Set HideDuplicates to Yes.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail