November 30, 200421 yr Newbies Hi, as you can see, I am new to this group. We are a small company and develop software for biologists. Except coding software I am responsible for almost all other areas in our company and that includes our Contact database. Over the last two weeks I improved it a lot but now I stuck a little bit. To provide a better overview between certain contacts (relationships between people) I want to link a record with other records within one table. I played around with relations (which I already use for other issues) but I stuck. Linking records in one direction is fine but how can I automatically create the link back to the original record so it works in both directions? Thanks very much, Christian
November 30, 200421 yr Welcome Christian! If you're using a join table as the "link" between two Contacts in the same table, then to make a two-way relationship (for use in the same portal,) you'll need two join records, one for each direction. I have an example of this here: http://www.fmforums.com/threads/showflat.php?Cat=0&Number=135019 Though you won't be able to port the custom functions that set the reverse real-world relationships without FM Developer.
December 1, 200421 yr Author Newbies Thanks a lot Ender for the quick and useful answer :-) Best, Christian
Create an account or sign in to comment