[Base]: Subform inside the form including two tables

[z3dom]

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?

[Ratslinger]

Hello,

First, I don’t see any value as to the tables ‘SEX’ or ‘Availability’. This is already in the main table ‘SHOES’. You can use a list box to transcribe the values to something more meaningful.

For selecting the subform records just use a table filter. See this post for explanation & many examples. Your main form would have two list boxes with the required selections & tied to the filter table record. The subform is based upon a query using this filter record. A button on the subform is used to refresh the data when listbox choices are made.