>I use default value of the table to call a program eg.nextkey.prg to generate the primary key for the table.
>
>I put my program and data into 2 directory eg.sales program and production program.
>
>My problem is when I append a record into another directory table, it will pick up the currect directory nextkey.prg to generate the key. So, how can I force the table to pick it's own nextkey.prg?
>
>TIA.
Put nextkey as a function to its database (stored proc).
Cetin