Forum Discussion
bensasse
4 years agoRegular Visitor
Table relationship with Dates not working
Both formatted as Date in the table and Query Editor and it STILL will NOT create a relationship between the two that I can filter off of..... What am I missing here? It will filter one table but not the other.
Just guessing
- Based on the screenshot, one is active many-to-many and other is inactive. You can test by making the other active (, automatically other will become inactive)
My 2 cents
- add one date table and then use it in the data model
1 Reply
- sevenhills
Super User
Just guessing
- Based on the screenshot, one is active many-to-many and other is inactive. You can test by making the other active (, automatically other will become inactive)
My 2 cents
- add one date table and then use it in the data model