How Do I Handle Foreign Keys Through List Controls?


Author
Message
John Kujur
John Kujur
StrataFrame Beginner (5 reputation)StrataFrame Beginner (5 reputation)StrataFrame Beginner (5 reputation)StrataFrame Beginner (5 reputation)StrataFrame Beginner (5 reputation)StrataFrame Beginner (5 reputation)StrataFrame Beginner (5 reputation)StrataFrame Beginner (5 reputation)StrataFrame Beginner (5 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.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




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

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

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search