4 Replies Latest reply on May 23, 2014 7:00 AM by renti

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

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