select field from related table without enabling "create a new register"

Discussion created by renti on May 23, 2014
Latest reply on May 23, 2014 by renti

Hi Again,


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.....