I have a little shop with shoes.
I have table SHOES with columns MODEL, SEX, AVAILABILITY
MODEL SEX AVAILABILITY
model1 1 1
newmodel 2 1
best2 1 3
...
And I have table SEX
ID SEX
1 male
2 female
And table AVAILIBILITY
ID AVAILTY
1 yes
2 no
3 unknown
So I made simple form based on table SEX, and subform based on table SHOES
In this form I can change sex and look, what shoes for each sex I have.
Now I want to filter by availibility too, so I need to have two fields (from SEX table and AVAILIBILITY table), and subform with SHOES table. But form can include only one table…
How can I make subform filtered by conditions from two different tables?