Dynamic Dropdown Lists

[Bloody_Lemming]

I’m trying to use one dropdown list to populate (or filter) another dropdown list.
Say I have an inventory of produce. The produce is separated into categories, Like Fruits and Vegetables. I’m trying to build a dropdown list with these categories (Fruits, Vegetables) so when you select Fruits, a second dropdown list will be populated only with types of fruits.

Thankyou kindly

[Wanderer]

Search for cascading list boxes

https://forum.openoffice.org/en/forum/viewtopic.php?f=83&t=46470

Simple List Box Filter

I have replaced a Table Control column with a List Box. I would like to filter the contents of the List Box by using an int field on the MainForm. The SQL command I’d like to use is something like: SELECT "street1", "address_id" FROM "addresses" WHERE "customer_id" = "MainForm.customer_id" For my odb specifics, I’ve set up 3 tables: customers, addresses, and payment_methods. Each customer can have multiple addresses. One of the addresses needs to be assigned to a payment_method. The Form desi…

Cascading List Box filters

How to set a cascading list box filter with a many to many relation? I want to make a form base on a many to many relation middle table, but i’m really lost with it. I saw this post link text and tried to implement it into my DB. But with no success. I can’t figure out witch is the subform filter to use. Is the same for the Mainform or instead the filter to the filter-table should I use the filter with the middle many-to-many table witch is primary key is a compound key with to foreign keys? …

[RobertG]

Might be this helps: Chapter 9 Macros - see “Hierachical Listboxes”.