219k views
11 votes
List 15 set of object


User KadoBOT
by
5.1k points

2 Answers

5 votes

Example 1

The following example sets a choice list for a shipping field. If the shipping is overnight, then the choice list is set to shippers who can ship overnight. Otherwise, it is set to the standard shippers:

If([Shipments]Overnight)

OBJECT SET LIST BY NAME([Shipments]Shipper;"Fast Shippers")

Else

OBJECT SET LIST BY NAME([Shipments]Shipper;"Normal Shippers")

End if

Example 2

Associate the "color_choice" list as a simple pop-up/drop-down list named "DoorColor":

OBJECT SET LIST BY NAME(*;"DoorColor";Choice list;"color_choice")

// in this case, the 3rd parameter (constant) can be omitted

Example 3

You want to associate the "color_choice" list with the "WallColor" combo box. Since this combo box is enterable, you want for it not to be possible to use certain colors such as "black", "purple" etc. These colors are placed in the "excl_colors" list:

OBJECT SET LIST BY NAME(*;"WallColor";Choice list;"color_choice")

OBJECT SET LIST BY NAME(*;"WallColor";Excluded list;"excl_colors")

Example 4

You want to remove the list associations:

// removal of a choice list

OBJECT SET LIST BY NAME(*;"DoorColor";Choice list;"")

// removal of list of values that are not allowed

OBJECT SET LIST BY NAME(*;"WallColor";Excluded list;"")

User Rami Sarieddine
by
4.5k points
8 votes

Answer:

you are remobe at less 1 relationship when you create a formula

User Ulak Blade
by
3.6k points