Jump to content
Sign in to follow this  
Jason Stratford

Help me please!!!! I am desperate. My goal: I want a list of organisations and how they relate to each other (subsidiary/parent/custom er/supplier etc) I have an Organisation Table, I have a

Recommended Posts

Help me please!!!! I am desperate.

My goal:

I want a list of organisations and how they relate to each other (subsidiary/parent/customer/supplier etc)

I have an Organisation Table, I have a link table to record who links to who and what type of link it is.

My problem comes when I try and display this in a layout.

I can easily show the links in a portal, but they are always from the point of view of the organisation I am editing. So links that come from another organisation show the wrong side of the link.

e.g.

my link table is setup as..

isrelatedto

isrelatedfrom

type

so I setup a link from org a

isrelatedto = org b

isrelatedfrom = org a

type = issubsidiary/hassubsidiary

I then go to org c and setup the following

isrelatedto = org a

isrelated from = org c

type = customer/supplier

Now when I go back to org a and look at the link portal I need to see...

org b

org c

However I can only get it to show

orb b

org a

or

org a

org c

because they are the values in isrelatedto or is relatedfrom. The direction on the second link needs to be reversed when looked at from the perspective of org a.

Now I can work out a way to do this using a calculated field that changes which field it contains either isrelatedto or isrelatedfrom, but....

And here is the problem... I can find no way to get the value of the id field of the organisation I am currently editing to use as a reference to determine direction of my links.

Does this make sense to anyone?

It seems like such a simple thing to do... but I just can not work out a way to get at the fields in the currently open record of the layout.

Please help I am going crazy on this one at the moment.

Oh and there is a second problem to do with being able to list the organisations I am not linked to and also exclude the organisation I am looking at.... a whole other problem to come onto if someone can help me sort this first one!

Many thanks

Jason

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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