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