[AccessD] Increment Child #s

Arthur Fuller fuller.artful at gmail.com
Wed Nov 17 12:56:06 CST 2010


Assume:

T1 - parent file, say CustomerOrders
T2 - child file, say CustomerOrderItems

Goal:

Inherit the PK from T1, but add an Item# column that enumerates the Items on
said Order, so...

CO1
    Item 1
    Item 2
CO2
    Item 1
    Item 2

I wrote some code to do a Dmax() call using the Parent PK but yuk! I'm
trying to find a slicker way to do this, ideally so that I can default the
Item# value for the next new record. Any ideas how this might be done?

TIA
A.



More information about the AccessD mailing list