🚀 go-pugleaf

Sergio,

The best way to do this is an AFTER INSERT trigger on the Items table. 
Do you also need an AFTER DELETE?

Allen

In article <3decf30f@newsgroups.borland.com>, shg@sion.com says...
> hello there! I'm a very begginer in SQL and have this problem.
> Just in case: I'm using IB 6.5 with Delphi 7
> Sorry if this message is too large. And sorry for my English!
> 
> I have these tables
> 1) ITEMS (id, description)
> 2) TCOST (tcost_id, description)
> 2) COST (id, tcost_id, percent) (id is FK to ITEMS and tcost_id is FK to
> TCOST)
> 
> ie:
> 
> ITEMS
> 1        SCREW
> 2        HAMMER
> 
> TCOST
> 1        TAX
> 2        SHIPPING
> 
> COST
> 1    1    nnn%
> 1    2    nnn%
> 2    1    nnn%
> 2    2    nnn%
> 
> Each time I insert a record in TCOST, I need to insert one record per each
> row being in ITEM in the table COST.
> 
> Can I do that with a simple SQL instruction? How can I do it?
> I supose that I should write a trigger in TCOST (after insert)
> 
> THanks.
> 
> Sergio.