Search results

I need to know whats on hand whenever I decide to check it. In the morning, in the afternoon whenever. Thing is we are a pretty small company and we get jobs in at various times. There are orders that get put in and the parts for orders do have specific materials that go with it but sometimes in...

I know storing a calculated value is not advised but I need to know what we have in stock at any given time. I am sure I typed more than just those statements backwards I haven't had any real training in Access just a lot of google and youtube help to figure things out. For the last part of...

Hi all, I have a table called tblPackingMaterials and a table called tblMaterialQuantities TblPackingMaterial has a number field called StartingQTY tblMaterialQuantities has: IDMaterial (a one to one relationship with MaterialID in tblPackingMaterial) AdjustmentQTY QTYinShop From these 2...

I do not understand Allen Brownes description of how to do this and I cannot find a model on that one site that a lot of people send others to. All I want is for packing materials to be added and subtracted and to add or delete paint and see its usage by order. There is no financial...

Hello, I have a database that I use to put in orders for our shop and keep track of our part informations as well as paint and packing materials. Everything works good on this but I am trying to create a table for adjusting quantities on hand for packing material based on the part quantities...

I think the department should go into the Orders table because a part can be run on either the line or batch depending on how busy we are and the only thing it would be specific to is the order. If an order has multiple parts all of those parts are run in the same department.

Ok so I created a Part entry form based off of the parts table and put tblpartpacking as a subform on that so when I put a new part in I can just put the packing materials too. Does this sound right? I also created a form for each table. I am thinking, for order creations Can I make...

I do have 2 questions, How do I create a new order? I know i will create a form but from which table? Also, I wanted to be able to filter the orders by status and department. Before I just created lookup fields in the orders table and filtered the orders with a query that specified which orders...

Thank you so much! this is awesome and exactly what I needed. Thanks for taking the time to help me with this! I understand where I was going wrong with what I had and it was so frustrating, I have been working on this a month...

A. In the foam table that designates a huge roll, correct? And when you use it for a part you tear off part of that roll, the size of which depends on the part it is used for, correct? Yes, each part has a specific length for foam strips B. When one part is packaged can it use more than one...

Ok I took out table plugs. After talking to my boss he doesn't think it is necessary to keep an inventory of them. I put in some info for foam, bags, and paint. Thank you so much for all of this help I am seeing now that i was looking at this the wrong way!

I forgot here are the changes I made, I left Bag size in tblparts because I was not sure.

1. tblBags, tblPlug, tblFoam: Whats the difference, in purpose, between ID and ProductCode in all those tables? Where/how does product code get assigned? Can a Part have more than one Bag, more than one Foam or more than one Plug? The ID I just put in there because I thought I needed it, it has...

Ok here is what I got. I thought about adding quantity fields in the paint, bag, foam, and plug tables but honestly I do not know how that should be done... Also, should I have created an orders table?

For the most part. A part is going to either be bagged or stacked with foam, EVERY part will have one or the other. There are different sized bags and each part has a specific bag size but each bag size can be used on different parts. There are not a whole lot of parts that require masking...

Customers can place multiple Orders Yes, customers can place multiple orders 1 order is comprised of one company and multiple Parts Yes, some orders may only have one part but most orders have a few Each part has only one type of Paint Yes, the paint can be used for multiple parts but the...

Ok, thanks for being so patient. With this database I need to be able to enter in jobs for our shop and keep track of part information. I get a purchase order, put the info in(the fields in tblProcessOrder), and I had a query that pulled active orders and I created a shop schedule from that so...

I enjoyed reading that but it does not have anything about filling in fields based on a selection from another. I will post a database with a few sample data pieces in it. I think I fixed my table structure which is really all I have right now for this but basically from the ProcessOrder Form...

Sorry. After I read over your Post I took a look at my tables again and created a new test database using ID auto number Fields. I took out all Spaces and changed all fields that I could to numeric. I was able to enable referencial integrity with cascading update and restrict delete. I will...

The Part ID cannot be numeric, some parts are just a number and some have letters attached. [LM-4563] is a sample part number. Should I have an auto number ID assigned to the parts also? For tblpaint The PaintID is the product code given on the box of paint. I added the auto number ID because...