Hello, I ask for advice,
I have a master table(Pratiche) with fields: PK_ID, register, object, state.
Detail table: id_anag, fk_id(manster), surname, name, date.
In the page list Pratiche (MASTER) I want to have a surname search field in the details table.
At the moment I duplicated the field PK_ID Master and then with lookup table I associate id details, but it is impractical.
Other more elegant and correct ways?
Thanks for everything