Recent content by jw195

I am building a database to track and balance incoming and outgoing orders of crops. I have 3 tables right now. "Products" is a list of products in the database "Incoming_Orders" is a list of incoming orders with the following fields; "Order#", "Supplier", "Order_Date", "Ship_Date"...

What? That wouldn't make any sense. It would take an insane amount of time to sort through every order and calculate the amount of product ordered for each different product and manually do that arithmetic. I would be better off doing the whole thing in excel than that.

Hello, I posted a few days ago looking for some help for blocking duplicate records in an inventory & order tracking data base. I was kindly helped quickly and have been making progress slowly but surely. I am now at the point where I (think) have all the tables I need and the data is...

Added Flower ID as a primary key. Followed your steps and it worked! Thank you! I will surely be posting many more questions. As I'm sure you can all tell I a have very little experience and I'm basically building this from the ground up.

Correct, if something is sourced from more than once supplier I have it indexed under "Multiple" I definitely recognize this isn't best practice though. As for price though, how would you suggest I store that data? For the most part products of the same size are the same price. This isn't...

Hmm. I'm not sure I see how that could cause a problem. 4" Fancy Leaf Begonia supplied by Ball would be a unique record from 4" Fancy Leaf Begonia supplied by Proven Winners. Although you have me thinking and it may not be necessary to keep have supplier as a field in the product list.

I realized that the text representation is uneasy on the eyes so here's a screenshot of the table. Thanks again.

I am building an inventory and order system that will need to pull product information from a list of 200+ different products/product types. I have built a master product list which details the different products (Flowers). In the Master Product Table I have five fields. "Species", "Variety"...