Table Trigger

[rufustaz]

I need to create a Table trigger in SL6. What I need to accomplish is when a CO line is added, I need it to check a table to see if the item exists. If it does, I need to add the lines from other table to be new records in the coitem table directly under the newly created item in the coitem table. I think that I need to make a CREATE Trigger but I am not sure.

 

[bulklodd]

not a create trigger but a write one. you can't check the existence of a record in the create trigger because most of the record's fields are empty at that moment. to distinguish between creating & updating in the write trigger you should use NEW function.

hth

 

[rufustaz]

Thanks, bulklodd.....That worked perfectly.

Thanks again for all of your help