Displaying Item Options in a Dropdown Based on Received Order Table

Need help
1

I have a database structure that looks like this:

Receive Order

  • Detail: text
  • item: List of Item
  • quantity: number

Item

  • Name: text
  • Detail: text

How can I display item options in a dropdown element, where the choices are based on the list of items in the Receive Order table? The type of choice for the options needs to be “Item”.

1 Like
2

Hey, If you want to create a dropdown menu showing items from the Receive Order table, first fetch the list of items linked to receive orders and remove duplicates to avoid repetition.

Use each item’s name as the display option while keeping the full item details as the value for accurate data handling. This ensures a clear, dynamic dropdown where choices are directly tied to the Item type.
Thanks.