Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Default Values

Status
Not open for further replies.

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
 
Hi GazC,
You should create a trigger on insert and there update the reuired field with "primary key number" + username.


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top