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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top