4 Table Filtered pick lists in forms

Question

I have 4 tables - "Farms" which has many "Parcels" which has many "crop zones" which has many "loads". When I enter a new load I would like to pick the "Farm" from one pick list, and the "Field - cropzone" from a pick list that is filtered based on the farm that was selected. I had this working a couple days ago, broke something and so far can not figure out how to get it back. The "Related Farm" pick list works fine. The "Crop Zone - Parcel Name" Pick list shows me the Crop zone Name - Acres, but does not show me the Parcel Name. When it was working I could pick a "Farm" such as Eitens, and then the next pick list would filter down so only the parcels that were part of Farms. So I would get an option in the 2nd pick list that looked like this 1st - "Eitens - Corn - 46 Acres", 2nd -- "Eitens - Soybeans - 30 Acres". Currently I get 1st "Corn -46 Acres" and 2nd "Soybeans - 30 Acres." Not a big problem in this case, but I could get a farm with 10 parcels in it that each has 2 crop zones in it. This would make the pick list pretty useless without filtering it further. Any Ideas how I can get this working again? The fewest number of Pick lists I can get away with would be great.

Thanks

chuckgrigsby · Answer

Might be something simple with the settings on the conditional drop-down. Double check the field settings on your second drop-down and make sure it's using the first drop-down as it's proxy to filter options

danflaherty · Answer

The filtering part is working correctly, its that I need one more field to get displayed in the 2nd dropdown. 2nd drop down was giving me a "Parcel Name - Crop Zone Name - Crop Zone Acres".

Now it is only giving me "Crop Zone Name - Crop Zone Acres". I lost the Parcel Name in that pick list somehow.

chuckgrigsby · Answer

Ah have you checked the record picker options for that table? Think you can use that or a report for the drop-down options

danflaherty · Answer

Yep, I've tried that too. &nbsp;I can pick Parcel Name, Crop Name, or the Crop Zone Acres field from the record picker, but that limits it down and only gives me whatever is chosen in the record picker. &nbsp;So I go from two out of the three things down to one out of the 3 fields I am after if I choose anything other than the standard record picker.

quickbasecoachd · Answer

You have two choices.

In the advanced properties for the table you can specify up to 3 Record Picker fields. Those are what will get offered to users by default when you allow a drop down to use the default Record Picker fields.

Alternatively, you can create any report you like. Including any sort and filter, Then set th form properties for that drop down field to use that report.

Forum Discussion

4 Table Filtered pick lists in forms

Related Content

Filter records based on table connection

Filter out some records on related table

Filter Table Entries In Another Table

Moving Fields from One Table to Another

Embedded Grid Edit Report Pre-filtered Conditional Dropdown