[AccessD] Increment Child #s

Charlotte charlotte.foust at gmail.com
Wed Nov 17 13:12:17 CST 2010


What exactly is wrong with doing it that way?  If you have multiple users, you have to test for the existence of the proposed key before you actually try to write the record, but that's not difficult.

Charlotte Foust

Sent from my Samsung Captivate(tm) on AT&T

Arthur Fuller <fuller.artful at gmail.com> wrote:

>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.
>-- 
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com




More information about the AccessD mailing list