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?