Hi Guys,
This is Kelvin and I am new to this access.
I was creating a access web app for my company and want to create a data for its product. Each product will have multiple colors and different material are used for each color. The number of colorways for a product varies.
We want to be able to select a product and a lookup field will appears for us to choose its colorway.
Can you guys kindly give me some hints on what structure in should use for data like this?
Thanks in advance.
Kelvin