With Firebase seems that the relational documents seem to work when set but in Supabase I cannot get this working at all.
Example 3 tables -
Table 1 jobCategories -> fields = id, name
Table 2 subCategories -> fields = id, jobCategoriesID(Key to jobCategories),name
Table 3 Jobs -> fields = id, customer, jobCategory(key to jobCategory), jobSubcategory(key to subCategories), status
I cannot build this query in list view for example
Customer
jobcat, subcat, status
_____________________________
How this looks
Matt
1, 3, Open
__________________________
Vs How I would normally pull it programmably
Matt
Delivery, At Home, Open
I hope this makes sense. I am new to FF and mobile I would normally have an array of categories and subcategories and display on a where statement.