Adding all the rows in my product table to my orders table

Ask for Help
1

Hey Gliders Guys,

Can someone help me with this little bit?

I have an order form where a customer fills in details and then chooses a product from a dropdown that is sourced from my Price List Table.

How do I get the complete product with all columns including price to pull into the orders table once order is submitted?

Thanks alot for all the help so far.
Great Community

2

Assuming you are writing a Product ID to the order table, you can use it in a Relation column to link to the Price List table and then add Lookup columns to retrieve the values you want from the price table through the relation.

3

Thanks Jeff
I had some figuring out to do there, but I won.