invoice

[tty]

hi there,

I am trying to create a very simple order invoice from two tables. Every
thing was looking good. but not any more. how can i create a additional line
items for the invoice like

Item Code Description Qty U/price T.price

xxx x xxxxxx xxx xxxx
xxxx


(probably atleast 12 more lines)
so that users can add more item on a single invoice


total
Grand Total

Also want to implement a proceedure that, if user just input the item code
then the other field can filled automatically like description and unit price.

Any exaple, article or any other kind of help be greatly appreciated.

thanks
(e-mail address removed)

 

[Larry Linson]

Subform and Subreport Controls are the usual approach, provided you have
your data laid out properly -- that is, with a separate InvoiceDetails or
Items table for the lines you want to show in multiples. See the training
material at http://office.microsoft.com if you aren't familiar with those,
and if Help isn't adequate.

Larry Linson
Microsoft Access MVP