Dynamic Defualt Values on Tables

[pdevito3]

Hi everyone,



Does anyone know if it is possible to have a dynamic default value for a text field on a table? For example:

I have a list of 10 items in my "Name" field called W-1,W-2,W-3,...W-10. I want the next field to automatically say W-11 and the field after that to say W-12, etc.

It might be worth noting that I can not use my primary key as reference, because it will not always match the "W-" value.

Thanks in advance!

[June7]

You want to create custom unique ID. That requires code. This is a common topic. Search forum. You could have code in the record BeforeUpdate event set the DefaultValue property. Would also need code in the form Open event to set the starting value. Be careful, generating unique ID by code is risky with multiple users.