Ask Your Question
0

[Base]: Subform inside the form including two tables

asked 2017-11-03 16:37:22 +0200

z3dom gravatar image

updated 2017-11-03 16:56:17 +0200

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-11-03 17:36:33 +0200

Ratslinger gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-11-03 16:37:22 +0200

Seen: 319 times

Last updated: Nov 03 '17