How Do I Handle Foreign Keys Through List Controls?


Author
Message
John Kujur
John Kujur
StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)
Group: Forum Members
Posts: 5, Visits: 12
This has got to be really simple, as I have been doing this throughout my coding years, but I can't make it happen using SF.



I have an Organization BO, a Group BO, and a GroupOrganization BO. An Organization can belong to many groups and a Group can have many organizations. I want to use the GroupOrganization BO to handle this. (The GroupOrganization table just has two fields -- GroupId, and OrganizationId which are foreign keys referencing the primary keys in the respective tables).



On the GroupOrganization BO, I just want to have a list control displaying all available Organizations, and one more list control displaying all available Groups. I want to be able to choose a Group, then choose (multiple) Organizations and click 'Save', resulting in proper records which look like (GroupId, OrganizationId) where both of these are composite primary keys.



I need some guidance how to go about achieving this through SF.



Thanks, and let me know if I can be more descriptive.
Replies
John Kujur
John Kujur
StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)StrataFrame Beginner (15 reputation)
Group: Forum Members
Posts: 5, Visits: 12
Thanks Trent, Ben And Team.



Yes My PKs are TinyInts as the number of records will never cross two digits here; and I have them auto-incrementing as it is a simple solution. It is just a little application I'm doing to test out SF. So yes, since these are converted into Bytes it all makes sense now.



I haven't gone through the example yet, I'll be doing that now and will let you know.



I was just curious about whether other SF users should also have these new DLLs? Is this going into an update/release?



Thanks Again.
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
I was just curious about whether other SF users should also have these new DLLs? Is this going into an update/release?

Only a few.  These DLLs contain the changes that will be released on Friday.  But it is stable as we are using this ourselves and anyone that is having specific problems we are letting have these DLLs.

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
John Kujur - 19 Years Ago
StrataFrame Team - 19 Years Ago
John Kujur - 19 Years Ago
John Kujur - 19 Years Ago
Trent L. Taylor - 19 Years Ago
                         Thanks, I'm attaching the package file.
John Kujur - 19 Years Ago
                             I will check this out....just curious, I noticed that your primary...
Trent L. Taylor - 19 Years Ago
                                 John, Attached are two things....some updated StrataFrame DLLs and a...
Trent L. Taylor - 19 Years Ago
                                     Thanks Trent, Ben And Team.

Yes My PKs are TinyInts as the...
John Kujur - 19 Years Ago
                                         [quote]I was just curious about whether other SF users should also...
Trent L. Taylor - 19 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search