Hello, hello.
I am trying to work up a query report for some purchasing data analysis, but the problem is that my crappy old version of access can't handle enough inputs.
Here's the current setup.
The table purchase.tbl is filled in via a form purchase.frm. purchase.frm has 10 items with 1) Item number 2) item material 3) item description 4) item cost 5) supplier number 6) Purchase Number (50 total fields for each of the 10 items w/ supplier number and purchase number being a single value)
I would like to be able to query a supplier number and pull up all of this information, but my version of access simply cannot handle it (upgrading isn't an option)
Does anyone know a good workaround for my problem here?
I was thinking of doing a query for just the 10 item numbers, 1 supplier number, and 1 purchase number and then use text boxes on the report to pull in the rest of the corresponding data, but I don't even know how to do that anymore.
Let me know if you know a good solution or if my idea might work and how I might go about implementing it.
Thank you!