Updating a 1-2-1 relationship in both directions

Need help Database
1

Hi

sorry for the simple question, this should be a so easy… but i’ll prefix this with the statement that i was a developer for years, and an oracle DBA for even more years, so perhaps my internal ‘how to’ is skewed away from how bubble handles this.

if i was explaining it in relational DB terms…

I have a table ‘property’ which has the field ‘tenant’ to show the current tenant in the property, i also have the table ‘tenant’ which has the field ‘property’ for the property the tenant is currently in.

basically, same data stored inverse on two different but related tables.

i’ve created a simple form with a tenant name and a drop down for property. enter the tenant name, select the property, workflow to update the name and property on the tenant record, boom, all good. but how do i then update the property record with the tenant?

i’ve fiddled for about an hour and cannot suss it out!

2

When you created tenant as a field in the property object … you joined both objects.

The same when you created a property field in the tenant object. Both are joined.

So … assuming that each of them have a name text field … and … since the objects are joined both ways … a “bubblish” expression could be “tenants’property name” … or a “property’s tenant name”.