Mr Confused !!!

[Naveed Pathan]

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

 

[fredg]

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?

 

[Naveed Pathan]

i am sorry how to do that

thankx

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?

 

[fredg]

i am sorry how to do that

thankx

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?

In Design View select the condtol and display it's property sheet.
click on the Format tab.
Set HideDuplicates to Yes.