Leroy-

I left out some info.

>Yes, you can, but you have to write the function yourself, and then, if you table belongs to a DBC, which I recommend, declare the function as your default value.

...by MODI STRUC the table, the selecting the field, and putting something like

GetID( "Customers", "CustomerID", "CustomerID" ) in the Default Value box.


Note that if you are using referential integrity, you'll want to address the issue of how to update the FK in child tables when you add records.

I usually use table buffering on both the parent and child. I assign the parent id on an add, which results in "wasted" IDs if the user cancels, but my IDing routine recycles thru IDs so they eventually get used. Then I have the FK for the child table.

HTH.