Ok @piano0011, we need to talk. Enough is enough.
That’s not the first time someone gave you that advice. In fact I’ve lost count of how many times people have told you this. Heck, somebody even gave you a much better database design on a silver platter and even gave you a several queries as examples of how to use that improved database design.
And yet you completely ignore all of this and keep going with your flawed design, which as you’re discovering now is getting harder and harder to work in, because the foundation (namely your database design) is actually working against you, instead of helping you.
Here’s the thing. All of us are here on these forums to help other people with development questions they can’t figure out for themselves. We do this for fun and because we like to solve puzzles. However, if a piece of advice given over and over again is being ignored as you are doing the fun starts to fade and as you may have noticed it’s starting to rub people the wrong way.
So, this is where we draw the line. Before you do anything, you really must fix your database first, both to preserve your own sanity as well as that of everyone who is helping you.
What that means is that
- I will close this thread, we will not help you any further down this road
- You must fix your database design, and are free to ask for any help with that over in our Databases forum. There are a lot of knowledge people there that can help you get back on track.
- Any thread you start that still uses the old, incorrect database schema will be made invisible on our forums, meaning no-one but you will be able to see it.
Once your database schema in order you are free to continue as you please.
With that said, thread closed.