There are 2 tables:

  1. "Warehouse" with the fields "code", "name"
  2. "Products" with the fields "name", "quantity", "warehouse code"

Warehouse fields. Code and Products. Warehouse codes are related by a one-to-many relationship.

How to create a drop-down list (for the "Storecode" field of the "production" table form) in which instead of the numerical designation of the warehouse code would be their names? As the value attribute of the HTML <select><option value="КодСклада">Названия складов</option></select>

    1 answer 1

    Register this table (or table-based query) into the rowsource of the combo box. Note that the controlsource remains the same number. Since boundcolumn defaults to 1, the first field displays the key, and to display the text value in a minimized form, enter in the column widths as many zeros, separated by a semicolon, how many columns you want to skip.