Greetings all,
I've been tasked with modifying our DB a bit to add in another search feature for another set of equipment in our inventory.
First off, everything is pulled from one main table: Full_Inv
Initially, I did like I always do... I copied an existing Query, Form & Report and edited them accordingly so they would reflect the new items.
OK, after copying and editing the Q, F & R, I view it to see how it's going. Broken. It's still got some hidden link to a previous Query for other equipment. I have edited EVERYTHING that I normally do step-by-step just as I have have done previously and it is still asking for the wrong data from the Query.
So, I nuke those copies and generate new ones from scratch. This time, it actually halfway works, but I still get that stupid Query popup window asking for a field which is NOWHERE in my Query search or ANY of my other docs. It's asking for Full_Inv.Id .... WHY?
I'm not using the ID for anything in the searches. Why on earth would it be asking for a field which was not even added to the Query criteria in the first place?
So I nuked that report and this time made sure I had my Query highlighted, clicked Report Wizard (again), selected the correct query from the drop down list (again) and done... same results. Still asking for Full_Inv.Id (attached PNGs)
I can upload whatever, but this is just annoying. I haven't done anything different than the previous times. Once I got the sequence down when building this DB, I wrote down all of my steps that I went through to create each Form, Query, Report, etc.
I follow it verbatim and have done so since the initial creation of this DB... and now for some reason it just doesn't want to do anything correctly.
Below are some snapshots of my Query, Report and the popup window asking for crap that doesn't exist. As you'll see, there is nothing in there pertaining to the ID field, so I'm at a loss as to why it would even try to ask for something that hasn't even been specified in the criteria.
Please advise.
Regards.