Jump to content

Updating fields two relations away w/portals


Rob Glaubitz

This topic is 7820 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I am working on a db with relational files two levels deep, ie. the first db relates to second db which then relates to a third db. Fields from the second db are displayed in the layout for db 1 within a portal. I would like to be able to update fields in the third db from the interface in the first db. However, the key between dbs 1 & 2 is different than the key between dbs 2 & 3.

I can figure out how to display the fields from db 3 in db 1 (using calc fields in db 2 and then adding those calc fields to the portal) but I can't update them. I tried to find a way to get the key between db 2 & db 3 to db 1 (using calc fields) so I could create a relation from db 1 to db 3 but, because of the portal, the calculation field in db 1 only displays the key for the first record in db 2 no matter what the active portal row is. Any ideas?

Hopefully, I explained it clearly enough that you can figure out what I'm trying to do...

Link to comment
Share on other sites

This topic is 7820 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.