Entering multiple records in one form

[Newtonboy]

I have my data in the following format:

Date ! Unit ! Account Code ! Product Code ! Description ! Debit !
Credit !

I enter data using a form.

As of now, for each entry i have to type in the date & unit every time.
Can't i have a system where for the same date and unit i update say 5
records and excel updates the Account code, product code etc. keeping
teh date and unit same ?

Pls Help.

 

[Bob Phillips]

That is just a design issue.

Have some boxes for the static data, put that in a frame say, then create
another frame with 5 instances of the variable data. You will then just
create the database from that input.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)