Search results

Hi Carletto, While going through my data yesterday I did see those discrepancies you mentioned. I'm using excel data from our office managers to grab all of the relevant data, but they didn't have a clean way of processing it so I'm going to start from scratch and normalize their naming...

1. The process starts with a PO for what the customer needs that can go up to a year from now. After that, their purchasing department sends us "releases" on what parts they want 1 month/2 months from now. To answer your question, when we get that release we look at finished inventory first...

To better understand, here's how I'm reading these tables. Let me know if I'm missing the mark: - TblVendorPO: The transaction of material from vendor. - TblPartsInv: This will be where the inventory for the vendor purchased part would reside, tied to a PartID. Which I believe would be...

Hi Larry, Not a problem! 1) We are a thermoforming company, so 1 "sheet" is a plastic sheet that we put into a production tool to form our parts. 1 sheet could produce a variety of part combinations based off of how the tool is designed. 2) Orders are taken based off of a Purchase Order...

Hi Cotsworld, Thank you for the recommendations to learn more, I'll check these out. My intention is not to have the forum actually design my application. I'm the only one in my company that has experience with information systems but I haven't touched it much in over 5 years, so I'm hoping...

Hi GaP, 1. The material ID in my table is the individual combinations of size, type, and color that we order for our products and what uniquely differentiates the material from each other. It has a one to many relationship with our products since once size and color is used for a variety of...

Hi Gap, I figured as much, still learning how to create these relationships lol. - Material: Each Item will be consumed individually and tied to the Material ID. Descriptors that differentiate them are the Color, Size, and Material Type which defines things like grain and what kind of...

1) So my company is small and old school so we don't have any centralized system for our information. I'm working on building out a database so that we can have reports for our management team on the floor. The buckets I want it to tell me are Raw Material Inv (plastic sheet), Finished Goods...

Hi, I'm currently working on building out an access database to help my company with basically Inventory tracking. I have taken classes in the past with access so I'm not completely new, but haven't touched it in years so I'm running into some basic issues. Just want to get your opinions on...