Hi guys, i am having a trouble with making 4 subcategory for my app. As you can see in this pic
On the database sheet, i have customers, ASC and unit model column while on the 2nd pic on the detail commodity sheet, i have P/N based on the unit model
The plan for my app is to set the ASC column as the main category, Customers column as the 2nd category, Unit model as 3rd category and P/N as 4th category.
So when i open the ASC tab on my app, it will show all the customers list for that ASC, then when i tap the customers, it will show all the unit model that they have and when i tap the unit model, it will show all the P/N based on that particular unit model.
I am having no trouble making the relation between the ASC and customers column but im stuck when tried to tie the customers with the unit model and so on.
The database sheet itself is a connected with Form Button on my app, so when the user fill the form, the database will updated. Can someone help me with this problem?