AnsweredAssumed Answered

Trouble with portal and table relationships

Question asked by arronman on Mar 13, 2014
Latest reply on Mar 28, 2014 by philmodjunk


Trouble with portal and table relationships


     I have tables "Table" and "Shops". They are related via 2 fields ("Shop Name" and "Suburb")

     I have a layout which displays fields from "Shops" and contains a portal with fields from "Table". Creating a new record within the portal works, however I need for the data in field "WW" to be automatically copied, - as well as Shop Name and Suburb - but this doesn't happen.

     I tried adding a third relationship:- Table::WW to Shops::WW, however the portal no longer displays records data correctly or completely. The portal returns to normal when the 3rd relationship is removed.

     What am I missing? What can I do?