Anyone good with MS Access?
4 posts
• Page 1 of 1
Anyone good with MS Access?
Hey, quick question. Trying to set up a database in access. This DB has 3 tables: Customers, Items, and Orders. Customers has all customer information like name/address, etc. Items has possible items to order. The orders table has 4 fields I want to work with (there are more but only 3 are important for this question): Customer, Items, Quantity, and Order Total. Basically, I want to be able to enter a quantity in the quantity field, select whichever items the customer wants, and have the total show up in the order total field. The price of each item is listed in the Items table. Anyone know how to do this or have a quick way of explaining it? I usually just wing stuff like this or find reference manuals but I'm kind of stressing on time at the moment, and everything works nicely except for that Total field which would be very convenient to get working.
TIA!
Re: Anyone good with MS Access?
You will have to setup several databases for this and do something like a query.
Dogs Have Owners; Cats Have Staff
- NT50
- PROfessional Member
- Posts: 8220
- Joined: Sat Jun 19, 2004 4:46 pm
- Location: Jackson, TN USA
- Real Name: Jeff Replogle
Re: Anyone good with MS Access?
Well, 1 database should be fine, I've already got multiple tables. So I guess what I was specifically asking was how I'd create that query. Funny how it seems like it'd be really simply in something like Excel lol.
Re: Anyone good with MS Access?
You could set this all up in one database, but NT50 is right that you're going to have a much easier time setting it up in 3 different databases, 2 at the very least. It's been a long time since I did any work with Access, but it seems like you want to store to much in one place. Not sure if this is going to be a production based thing or just something like a test, but either way, 2-3 databases would likely be easier to work with. If you were going with 3, I'd set them up as:
DB Name: Customer --> Fields: First Name, Last Name, Address, City, State, & Zip
DB Name: Items --> Fields: Item Description, SKU and/or UPC, Price, Quantity Available
DB Name: Orders --> Fields: Customer, Item(s), Quantity(ies), Total Cost
With only 2 databases, I'd set it up with the orders being stored in the customer database, just add the other 3 fields in with it. If you try to merge the Items and Customer data though, things would get really messy. With 2 seperate systems, it should stay fairly neat and in order and should hopefully maintain some performance and be easy to manage.
DB Name: Customer --> Fields: First Name, Last Name, Address, City, State, & Zip
DB Name: Items --> Fields: Item Description, SKU and/or UPC, Price, Quantity Available
DB Name: Orders --> Fields: Customer, Item(s), Quantity(ies), Total Cost
With only 2 databases, I'd set it up with the orders being stored in the customer database, just add the other 3 fields in with it. If you try to merge the Items and Customer data though, things would get really messy. With 2 seperate systems, it should stay fairly neat and in order and should hopefully maintain some performance and be easy to manage.
- imnuts
- Posts: 7457
- Joined: Wed Mar 24, 2004 5:19 am
- Location: Boothwyn, Pennsylvania
- Real Name: Mark
4 posts
• Page 1 of 1
Return to General Windows Support
Who is online
Users browsing this forum: No registered users and 9 guests