set default value

[gambhir]

How do you set a default value in Table2, column 2 so that every time a new row is added to Table2, the last value from Table1, column1 is inserted into Table 2 for that new row just added.

Basically I am need to set the last PK incremented value from Table1, and set it as the default value as the FK for the last row in Table2 so that when I insert a add a row in Table 2 the default value for the record is set.

Thanks guys and gals,

gambhir

 

[DougP]

you could do this with a stored procedure and a trigger. DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[DWarren]

Could someone give a specific example for a trigger that would accomplish this task? I have not been successful in writing one.

 

[Cagliostro]

isn't easier just to insert the needed value value?
for example

insert into table2(...)
values(a,b,c, (select max(x) from table1))
John Fill

ivfmd@mail.md