How to pull records from one table to add to a list

Hi Guys,

Im new to Bubble and im trying to build an application for my company. I know this may be simple but I have not found any tutorials on this. I have a data type in the database with products and skus.

What I would like to do is create a form where I can add multiple products from that data type to a list for product orders. How do I do that? also I would like to add each product on a separate line like a spreadsheet format. This is simple to do in access but I would like to do it in Bubble.

You can use repeating groups and tables, depends upon your needs but it will do the job.
You need to specify the data source properly in order to make it work

Thanks I was thinking that but how do I get the data from the products table into the list?

The table are the repeating group will so on the data from the table in list format itself. Say you have defined data type in a repeating group as product and source as do a search for product.

To create a form in Bubble for adding multiple products to order, use a Repeating Group to display items with dropdowns for selection, quantity inputs, and calculated subtotals. Manage the list with a custom state and buttons to add rows and save orders. Include dynamic subtotal and total calculations for a smooth workflow.