how to I access the value of an unstored calculation of related table for auto-entry calculations

[lflueck]

Hi,

I have two related tables. In the first table I did calculate the max value of a number field in related records of the second table (max function). This value+1 should be used as an auto-enter value if a new related record in the second table is created. However I did not succeed as apparently the unstored calculation value from the first table is not accessible for the auto-enter if a new related record is created in the related second table.

The final result should be the following:

The first table defines groups (1-m)

The second related table members of groups (1-n)

I would like to create 'names' for group members in the form

The 'trick' using Get(FoundCount) for the members does not work for me, as as soon as a member is deleted one would get redundancy in the names! So, if always the max of n +1 should be used for each new member of group

G1-1

G1-2

. . .

. . .

G1-n

........

G2-1

G2-2

. . .

G2-n

........

Gm-1

Gm-2

. . .

Gm-n

Any idea how I could solve that issue is highly appreciated!

[bcooney]

"This value+1 should be used as an auto-enter value if a new related record in the second table is created."

NO! Stop right there. Do not derive key values using a calculation. There are many posts that explain in depth all the pitfalls of such an approach.

[Søren Dyhr]

I would like to create 'names' for group members in the form

This is where you explanation gets blurred, what is the context and purpose of this?

--sd