Hi, i’ve created a new menu item with a url diriectly pointing to the add page for a table "Menu Editor URL = tempilavoriadd " and it’s working almost fine.
temp_lavori, is a detail table with master lavori.
So, when i add a row in tempi_lavori with the menu link everything is working fine,
but if i add a new time with the menu link after i’ve added a time in the master/detail page the master/detail field remain as if i was adding the row in the master/detail table.this is a simplified version of the two table:
CREATE TABLE lavori (
id INT PRIMARY KEY AUTO_INCREMENT COMMENT 'ID (PRIMARY-AI)',
indirizzo VARCHAR(255) NOT NULL COMMENT 'Address',
);
CREATE TABLE tempi_lavori (
id INT PRIMARY KEY AUTO_INCREMENT COMMENT 'ID (PRIMARY-AI)',
id_lavoro INT NOT NULL COMMENT 'Lookup from lavori.id',
ore INT NOT NULL COMMENT 'Number of hours',
FOREIGN KEY (id_lavoro) REFERENCES lavori(id)
);
In Master/Detail i have: ‘lavori’.‘id’ = ‘tempi_lavori’.'id_lavoro’1) add tempi_lavori from master/detail → everyting good
2) add tempi_lavori from URL (tempilavoriadd) → everything good
3) add tempi_lavori at first from master/detail and after another one from the URL → id_lavoro is not null but keep the value from the previous master/detail add. I need to set this null.Any idea to resolve this?Thanks a lot