A field represents a foreign key. How to create a box of items (combobox) of the information of the other table so that the user can select a specific element?
Hi @vincent
Can you explain a little more detailed what are you trying to achieve? Are you trying to create a dynamic select/drop-down menu?
Is not it. It is a crud where I have a list of items in the table items (with id, name and category). The category is a foreign key of the table category (with id and name). In this way, the category must be selected in a list (a select html) whose text is the name of the category table.
Sorry but your explanation is a little confusing.
Can you explain a little more detailed or provide an example of what you need to achieve?
The database has two tables: products and category. The products table has the fields (id, description and id_categ). The categ table has the fields (categ_id and name_categ). The id_categ field is the foreign key of the categ table. I want to register products in products table. The id will be generated by the database. The product description will be informed by the user. The category will be selected from a list of names. These names originate from categ table. The category list is a combobox, where each item is a text that is the name_categ field of the category table
Please check how to create an insert record form:
And also how to create a dynamic dropdown menu: