1 Reply Latest reply on Aug 16, 2007 11:37 AM by Andrew Rubinger

    primary and secondry table insertion

    kavi arasu Newbie

      Hi
      i want to insert value for primary and secondry table through bean itself or using trigger,
      can any one help


      table 1
      eno-primary key

      table-2
      eno-foreign key
      address-
      esino-primary key for this table


      i want to write bean that table1.eno is autogenerate value that want to insert into secondry table and the same value want to assigned to table2.esino which is the primary coloumn for table 2. and wnat to inser the value for table2.address too from jsf.
      is it possible through trigger or
      i want to attain it through bean itself
      thank you
      regards
      kaviarasu