I´ve 2 table in the project: Owners table and Warehouses table, and 2 layouts, one for each table.
Fields in the Owners table: Id_owner (serial number), name (text), surname (text), others (text)
Field in the Warehouses table: Id_warehouse (serial number), Id_owner (number), name (text), location (text), others (text)
How could i select a Id_owner for each warehouse from the warehouses layout, without enable "Create a new register for owners table" on the relationships diagram ? ( if i enable it, i will have a lot of duplicate Id_owner in my owners table).
i´ve been stuck with this and i can´t find me way out.....