0 Replies Latest reply on Jul 10, 2006 2:25 PM by Urs Wagner

    Insert of a foreign key

    Urs Wagner Novice

      Hello

      I would to use import.sql to setup the data. When I use


      insert into Assortment (assortname) values ('Antiquitäten & Kunst')
      insert into Category (categoryname) values ('Antikes aus Glas')


      assortid is the foreign key of the category table. It is set to null. How can I set it to the assortment table?