Display data from another table

Ask the community
1

I’m using softr against a MySQL database. I need to update one table but also display data from another

Example
I want to update quantity on an order table but show information alongside the editable fields from a product table.

Product ID (updateable, order table)
Quantity (updateable, order table)
Description (view only, products)
Price (view only, products)

Is this possible? It’s a very basic requirement but struggling to find a way to do it

Thanks
Mike

2

Yep, just use different blocks (each with a data source). Make it look like it’s all one block to the end user. Or use SQL joins.

3

Thanks for taking the time to answer. I really wanted it to be a grid as there are a lot of rows potentially

How can you use SQL joins in a component? That would be perfect to be honest