1- Yes, you are correct, some IDs can’t or shouldn’t be defaulted. Parts is a good example as usually there is some other schema driving this ID sequence. Either an engineering planned format, following a supplier sequence or some other pre-established method of determining the user viewed id (ie, part number) 2- Yes, the create new version of the user record is hard to modify using a trigger, you will generally have problems trying to control this unless you do it from a custom view or some other custom method which often negates the usefulness of the form being utilized. Depends on what you are trying to control or validate though. 3- Yes, once the ID is saved (Customer ID, Customer Order Number, Purchase Order Number, Part Number, Voucher Number, etc) it cannot be changed. In fact, on any given view, there can be more than just the ID that becomes set once the initial record is saved. I refer to them as one way doors, once crossed, there is no return. To control, there is onl
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.