Aug 3, 2001 #1 VBXL Programmer Jul 10, 2001 198 GB How do you enter a default value where it is a combination of values ? I want a default value to be entered into a field every time a create a new record. The field will contain the "primary key number" + username Cheers GazC
How do you enter a default value where it is a combination of values ? I want a default value to be entered into a field every time a create a new record. The field will contain the "primary key number" + username Cheers GazC
Aug 3, 2001 #2 rajeevnandanmishra Programmer Jun 1, 2001 379 IN Hi GazC, You should create a trigger on insert and there update the reuired field with "primary key number" + username. Upvote 0 Downvote
Hi GazC, You should create a trigger on insert and there update the reuired field with "primary key number" + username.
Aug 3, 2001 Thread starter #3 VBXL Programmer Jul 10, 2001 198 GB Cheers it worked GazC Upvote 0 Downvote