Populate field with recordnumber of record

T

Tamu Scott

Hello everyone,
I have created a form that contains a subform. Several
records can be entered in this subform.

Each record is numbered to keep track as if it were a line
item on an invoice or something. But, I would like for
each line for each record to automatically number itself
with the actual record number the line corresponds to
(have I lost you yet?).

For example,
the subform looks something like this:
1 datafield1 datafield2
2 datafield1 datafield2

the corresponding table is:
linenumber (number)
datafield1 (text)
datafield2 (text)

I want linenumber to automatically populate with the
corresponding record number.

Can this be done and how?

Thanks in advance,
Tamu
 
Top