Связанные списки (например: Страна > Область > Город)

//SQLExecute('DROP TRIGGER IF EXISTS my_log_insert'); // how to remove trigger

    //триггер при вставке новой записи
    SQLExecute(
    'CREATE TRIGGER IF NOT EXISTS my_log_insert AFTER INSERT ON Uchet '+
    'BEGIN '+
    'INSERT INTO Logs(ParentId, datetimeEvent, operation, log_id_naimenovanie, log_id_proizvoditel, log_id_model, Log_ser_number, log_inv_number, ' +
    'log_date_realese, log_date_of_input, log_id_sluzba, log_id_kabinet, log_id_otvLico, log_dop_opisanie, log_id_dolznost, log_aurum, log_argentum, log_platinum, log_palladium) '+
    'VALUES (NEW.id, datetime(''now'', ''localtime''), ''Новая запись'', '+

  [b] '(SELECT Naimenovanie.nazvanie FROM Naimenovanie WHERE Naimenovanie.id=NEW.id_Naimenovanie),'+[/b]
   // '(SELECT Naimenovanie.nazvanie FROM Uchet u LEFT OUTER JOIN Model ON Model.id=Uchet.id_Model LEFT OUTER JOIN Proizvoditel ON Proizvoditel.id=Model.id_Proizvoditel LEFT OUTER JOIN Naimenovanie ON Naimenovanie.id=Proizvoditel.id_Naimenovanie WHERE Uchet.id=u.id AND Naimenovanie.id=NEW.id_Naimenovanie), '+
   [b] '(SELECT Proizvoditel.proizvoditel FROM Proizvoditel WHERE Proizvoditel.id=NEW.id_Proizvoditel),'+[/b]
  //  '(SELECT Proizvoditel.proizvoditel FROM Uchet u LEFT OUTER JOIN Model ON Model.id=Uchet.id_Model LEFT OUTER JOIN Proizvoditel ON Proizvoditel.id=Model.id_Proizvoditel WHERE Uchet.id=u.id),'+

   [b]//'(SELECT Model.model FROM Model  WHERE Model.id=Uchet.id_Model),'+[/b]
    '(SELECT Model.model FROM Model WHERE Model.id=NEW.id_Model),'+
    'NEW.ser_number, NEW.inv_number, NEW.date_release, NEW.date_of_input, '+
    '(SELECT Sluzba.sluzba FROM Sluzba WHERE Sluzba.id=NEW.id_Sluzba),'+
    '(SELECT Kabinet.kabinet FROM Kabinet WHERE Kabinet.id=NEW.id_Kabinet),'+
    '(SELECT OtvLico.lico FROM OtvLico WHERE OtvLico.id=NEW.id_OtvLico),'+
    'NEW.dop_opisanie, (SELECT Dolznost.dolznost FROM Dolznost WHERE Dolznost.id=NEW.id_Dolznost), NEW.aurum, NEW.argentum, NEW.platinum, NEW.palladium); '+
    'END;'
    );