SQL insert record problem,

lygcla

Is there a way to make the default value of a field of a table based on a certain field of a newly inserted record as a parameter, query another table to get the value to insert the field? Can I use stored procedures or views? Take an example!

michealhenry

Use triggers!

terrorlin

trigger