I’m trying to simplify my inventory lookups each week and wondering if anyone has suggestions. My database has one table for each month that lists my orders from distributors. Each week I receive a list that may include items from 5 or more different...
I’ve created a customer database that lists each of the periodicals my customers are subscribed to. Sometimes, a customer subscribes to periodicals by a grouping. For example, they might select “Gaming” as a category which means they want a selection...
Justin_Barrett:
You might be better off having someone design a custom API-based solution. The code behind such a solution would have a far easier time pulling only the needed data each week, which means less work for you to build each week’s re...
While I appreciate the input so far, the suggestion to have one table for our data isn’t feasible for a number of reasons, the least of which is each table contains about 3500 records and our workflow for ordering would take longer if this were all i...
Thank you SO MUCH. This is very clear and very helpful! I’m going to try this with the latter option of “category includes” and see how that works for us.
Greatly appreciated!
