Forum Post: How do you implement Multi level dependent picklists using relationships /...

  • Thread starter Thread starter spope-linx
  • Start date Start date
Status
Not open for further replies.
S

spope-linx

Guest
We need to be able implement a Multi level dependent picklist for an accomodation booking system we are working on. In our "accomodation request" object we need to be able to select: Hotel/Property Room type Room rate / Service Level First Effort was using Standard Picklist for Hotel/ Property, then Dependent picklists for the 2 lower levels. This works in a fashion, but is not as user friendly, or as maintainable as we need. So we want to do this using relationships and other objects. If there is a best practice way of doing this in Rollbase please let me know. We have created new objects for Hotel, Room Type, and Room Rate/Service level, and set up the relationships between them. We can get the Edit Screen for our accommodation request do a picklist. lookup instead of a Selector, but we are having troubles with it displaying as a multi-select picklist when we want it to be single select picklist. If we make the Relationships 1-1, The picklsts look right on the screen, but you cannot relate multiple accommodation requests to the same hotel etc, which is a major problem. If we make the Relationships 1-Many, we are forced to use the multi-select picklist, which is not what we want. Is this a bug? The Old Rollbase in Action Doco suggests we can pick either picklist, or multi-select picklist from the page level properties of the lookup fields, but we are only getting "Picklist", and the multi-select behaviour appears to be being controlled by the type of relationship. Any assistance would be greatly appreciated. Also: Do we need 3 Objects, or can this be done using 1 Object with all 3 columns in it? There has to be a way of doing this simply.

Continue reading...
 
Status
Not open for further replies.
Back
Top