How to work with relational tables?

Ask the community
, ,
1

Hello all
i would like to build an online store , for variety type products.
as shown in the screenshot , lets say i have 3 tables… how to work with this situation , as i know table normalization is a good practice and its not good to put all these things in one table
could you please some one guide me how to get around this.

many thanks

2

sorry i missed the screenshot

764×355 9.74 KB

3

You can use reference fields. Click here to learn more about it.

4

Thanks that was a good info