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.