Increment numbers and codes on a subform

[dataside]

I need to increment numeric numbers and test codes on 2 subforms.

We have Documents (GSOP1234) and each document has many Version Codes (01) and each Version has many copy numbers (1)

The link to the main form is via a primary key but these codes need to be sequential as a subset of the primary key.

One is for the Version codes that has the text format 01, 02, 03 etc.

The other is for the Copy Numbers - numberc 1, 2, 3 etc.

I can't get auto number to do it as these codes and numbers need to be sequential as a subset of the prymary key and are keyed at different times.

Peter

 

[Aivars]

Hi, Peter!

Create multi links between main and sub forms.
For example:

Me.subTest.LinkChildFields = "DocumentID;VersionCode;CopyNumber"
Me.subTest.LinkMasterFields = "DocumentID;VersionCode;CopyNumber"

Aivars

 

[dataside]

Aivars,

Thanks for thae advice.

I can get the links to work fine.

Problem is I can't get the numbers to increment. If I key them in manually they are fine, but I need to force them to be sequential i.e. 1, 2, 3, 4, 5 so the operators don't have to key them (and make mistakes).

Peter