It would be great to implement the search that spans across multiple tables.
Here's the scenario: - I have a **Customer Status Table**, as one customer can have multiple statuses. - Additionally, one customer can have multiple orders, and each order can have multiple order details.
I'd like to filter based on the following criteria: - Customers living in **NJ** or **NY**, - OR customers in **TX** who made a purchase in **December 2021** or **November 2020**, - AND have a status of either **Gold** or **Bronze**.
the idea is that same you did here on a single table you do it across multipul tables and its all for the end user choose to select
Would this be something Developer 46 can work on?
Sami Shamma
@Reply 2 years ago
Hi Abraham
Developer 46 is in the realm of the unseen (only Lord Richard knows what is in it) we are all waiting for the big reveal. lol.
Having said that, Richard has done something similar to what you are looking for in his ABCD seminar if you want to check it out.
Abraham BreuerOP
@Reply 2 years ago
thanks
which part of the ABCD?
Sami Shamma
@Reply 2 years ago
ABCD Core Part 4
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Developer 26.
