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

    Insert of a foreign key

    Urs Wagner Novice


      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?