Member Avatar for Aussie_Here

I've got the following tables :

Em_table

Em_No nchar(3) Primary key
Em_type nchar(20) , (values it can be inserted into that column are 'P', 'T' and defaults to Work_table(w_type))
.
.

Work_table
w_No ......
w_type nchar(20) values it can be inserted into that column are 'P', 'T' )
.
.
Could you please give me a way to assign the aforementioned default to that column ??

  • 2 Contributors
  • 1 Reply
  • 79 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by sknake
Member Avatar for sknake

Are you wanting a default value based on the data in another table? If so use a trigger. If not then please clarify what you are asking

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.