Stuart Taylor Posted September 12, 2006 Share Posted September 12, 2006 (edited) Hello, Maybe im being a dumb ass here, but for some reason i can't work this out. In FileMaker 6 i had a relationship for several of my clients that used a dumbish multikey The Multikey was in the contacts database and consisted of several variations of the contacts name and company name. The Multikey was related to itself. The Portal on the contact record displayed other addresses for the contact and other people at the company they worked for. (very useful for testing for duplicates or quickly seeing other contacts at an organization. When you clicked on a portal row it took you straight to that record. Question: Now that self-relationships create multiple tables how can i recreate this so that when you click on the portal row you end up on the other record in the same window on the same table? Do i have to do a summersult onto the related record on another table and then back via another relationship to the new record on the original table or is there an easier way? best, stuart. Edited September 12, 2006 by Guest Link to comment Share on other sites More sharing options...
comment Posted September 12, 2006 Share Posted September 12, 2006 Self-relationships do NOT create multiple tables - just multiple occurences of the same table. Try: Go to Related Record [ From table: “the other TO"; Using layout: ] Link to comment Share on other sites More sharing options...
Stuart Taylor Posted September 12, 2006 Author Share Posted September 12, 2006 Hi Comment I put this file together to prove to you that i couldn't get it to work ... but ofcourse it works just fine. It was actually in my WebWiki i couldnt get it to work and did a little gotorecord woraround but i just reopened it and tried again. Maybe something strange was going on on the layout or with the app. Or maybe as per usual it was user error and i was just tired. Have posted file as (it exists only for this post), anyone new to relationships may find useful as a simple demo. thanks stuart SelfRelatedPortal.fp7.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6570 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 accountSign in
Already have an account? Sign in here.
Sign In Now