Drop Down Limit

[azwildcat4ever]

Please have a look at the screenshot file below before u start reading this.

what i want to do is limit the "Cost Type" drop down list.

The limit on drop down is initiated by Placement Type

So if you selected Placement Type = "Consultant", the "Cost Type" should be limited to the following
1) Consultant Wages X 14%
2) Consultant Wages X 4.5%
3) Consultant Wages

and therefore if you select "Other "on the Placement Type drop down, Cost Type dropdown should only show Sign on Bonus and other

i hope this makes sense.
thanks much in advance.

 

[GabrielR]

Yes, it does make sense, when I try to explain to others I use the example found on the car sales website, where you can select brand, and depending on that select a model, and so on...

That is Combo Box Cascade update, do a search in the forum, and there is also an example HERE

This is what I would do:

1. create a table with 2 fields one called CostType and the other PlacementType

2. Every row will have the the Cost Type and its respective Placement Type, so I can query what cost types belong to a given Placement Type.

3. Apply the example found on the website/here in the forum.

Hope this helps

 

[maxmangion]

There is a good example on combo boxes in the FAQ of this Forum ... here is a link for it.