Home
»
Community Groups
»
Rollbase
»
Forum
»
"Nature" of Relationship
"Nature" of Relationship
Know More By
Logging In
Log In
Forgot Password
NOT A MEMBER?
REGISTER NOW
Search the community
Search
Search Options
Search Everything
Search Rollbase
Member Options
Share this
RSS
Thread Details
3
replies
751
subscribers
Posted
over 7 years ago
Related Tags
ABL Rollbase API selectQuery
ABL Rollbase API selectQuery Rollbase
api
field
javascript
lookup
newui
page
Portal
record
REST
Rollbase
Rollbase application
selector
Trigger
Overview
Forum
Wiki
Documents
User Help
Ideas
Blog
 Forum
"Nature" of Relationship
Posted by
Rollbase User
on
25 Jun 2011 21:14
I need to indicate the "nature" of Relationships. For example, assume I have two Objects, Projects and People... with a "many to many Relationship." Mike has a Relationship with Project One and a Relationship with Project Two, as follows: Mike is Manager on Project One Mike is Asst. Manager on Project Two In this simple example, "Manager" and "Asst. Manager" indicate the "nature" of Mike's Relationships to the Projects. I realize I can create an Object to serve as the "middle man" for the Relationship... but, I was wondering how others deal with this situation in Rollbase apps. In apps we have developed in the past... we allowed entry of and stored a "Nature of Relationship" in tandem with the related Object IDs. Of course, that requires two descriptions of each "nature," i.e. one for each side of the Relationship. For example: "is Manager of" / "is managed by" but, I'm sure there are many ways to accomplish the same thing. Thanks!
You have posted to a forum that requires a moderator to approve posts before they are publicly available.
Posted by
Admin
on
25 Jun 2011 21:46
If you just want to indicate that object A has something to do with object B - use relationship. But if you want attach some attributes to the same fact - use intermediate object C which has relationships with both A and B.
Rollbase has a feature: convert "simple" relationship into relationship through intermediate object.
You have posted to a forum that requires a moderator to approve posts before they are publicly available.
Posted by
Admin
on
25 Jun 2011 21:48
Example: Job candidate and Job (Requisition). Relationship between candidate and job may have many attributes attached. So it is advisable to have this data schema:
Candidate Job Application Job
You have posted to a forum that requires a moderator to approve posts before they are publicly available.
Posted by
Admin
on
26 Jun 2011 7:23
That's what I figured... thanks.
You have posted to a forum that requires a moderator to approve posts before they are publicly available.