Re: Writing to multiple tables with WebDb

Hi!

[Quoted] You can build a form on one table and with insert trigger on this table [Quoted] update all the necessary tables.

UrRa

ceophs wrote:
>
> I need to produce a form that will write the data entered in the fields
> to several tables, some of which are join/link tables, using Dynamic
> LOVs. What is the best way to do this? Master / Detail won't work as it
> only populates two tables.
> I presume the best way is to create either a procedure, or view, that
> will write the data to multiple tables, and then build a form on it?
> I also want to know is it possible to use the concatenate symbol ||
> and outer join (+) in the select SQL for Dynamic Lovs by replacing them
> with their html equivalents, e.g.
> e.g. | | for the || symobl.
> ( +) for (+)
> All suggestions greatly appreciated,
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Mar 24 2000 - 15:57:19 CET