Help With Clothing Order Management Database
Jun 12, 2007
Hi,
I am trying to design and build an orders management database for a clothing wholesaler.
Has anyone got any ideas on what entities i should have.
I thought:
Clients (Customer Details)
Orders (Inc. order date, ship via etc)
Order Details (sizes, quantity of orders per size)
Product Details (Product Code, colour, size, stock numbers per size)
Catergories (Shorts, Jackets, Jeans etc)
Suppliers (Supplier Information)
Delivery (Delivery Method etc)
However, loads of problems when i come to planning the sizes part. I have different product catergories with different sizes
And when i do the order details table, i need to enter order quantities for each different size for one clothing unit.
Any ideas?
I would also ideally want to link the order details and products tables by the product code number. I.e. When filling out an order In the order details table i want to type in the product code then have information from the product table automatcially fill in the gaps in the order details table, such as unit price, colour etc.
Hope you understand and can help me!!!
Thanks for your time
J
View Replies
ADVERTISEMENT
Jan 18, 2005
I am trying to setup a database to store the information for a database of clothing.
There will be mens and womens shirts, jackets and accessories.
Right now I have a Product Table.
Product
-------
ProductID
ProductName(Shirt/Jackets/Accessories)
A shirt table
Shirt
-----
Shirt_ID
ProductID
Title
Description
Photo
Price
Fabric
I'll do something similar for jackets.
My problem I run into is with the sizes and colors. Each shirt has 4 or 5 sizes and about the same for colors. There is about 20 or 30 different colors that the shirts will pull from. About 10 different sizes. How should I organize this? What I would like to do is when I design the ASP.NET site for this I want to have the sizes and colors in a dropdown list for the user to select. I know how to set that up, I just don't know how to make a relationship between the shirt and the size or the shirt and the color so the right sizes and right colors show up for the shirt the user selected.
View 8 Replies
View Related
Jul 29, 2006
I have little experience using Microsoft Access, but am attempting to create an order management system.
I have designed a system to store customer details and allow the entry of orders. I now want to develop this so that the system can handle delivery notes.
There are currently two tables for order information, since each order can consist of multiple items. So, general information, like the order date, order number and salesperson are stored in an orders table. A second table, Order Detail lists the items and item specific information along with the order number of which they are a part.
A whole order (i.e. all items assigned to one order number) may be delivered at once, or in smaller consignments. However, every consignment must have a delivery note with a unique number. So, there may be several delivery note numbers associated with each order, relating to different shipments.
I therefore need to create a system which allows the user to select which items from an order are being dispatched and then get Access to do the following:
Create a new record in the delivery notes table. The delivery note number will therefore be created (it's an autonumber). The user should be prompted to enter the delivery date and this should be stored in the date column of the delivery notes table, alongside the delivery note number.
Enter the delivery note number in the "Delivery Note Number" field of the Order Details table, for every item that the user selected as dispatching.
Once this is in place, I will then be able to pull all the required details together with a query and then print the delivery note.
Bearing in mind that I'm very new to Access and so don't have any knowledge of scripts/macros etc, can anyone tell me how I can achieve this?
Many thanks in advance,
Gary
View 11 Replies
View Related
Sep 3, 2007
Hi all. I am considering developing a purchase order and warehouse management database, to be manage a cold store in my workplace.
What i have in mind is a system where the details of each pallet coming in is recorded (weight, quantity, location of pallet in warehouse etc.) is recorded, marked off against the corresponding purchase order number and then a label is printed with a barcode to quickly identify that pallet.
Handheld barcode scanners would be used to record when a pallet leaves the warhouse, and where its going to(despatch, production etc.). Ideally the scanners could be used to give forklift drivers order picking info aswell.
I'm fairly confident i can design the database, however, i have never done anything with barcodes, scanners or handheld devices. Is this even feasible with access? How do i go about doing it, any advice, example databases etc. greatly appreciated.
View 1 Replies
View Related
Apr 10, 2006
Hi Forum,
I am trying to create a access database system which will show classes, students, attendance, progress report, teachers, departments etc...
i have repeatedly failed in accomplishing this database as i dont have the knowledge.
the place that i get messed up is for example the attendance, i want it so that i can select a date and then all the students associated with that class showup. so 1 date and a list of student only on that class.
another problem was adding a progress report for every class and individual students.
this is for a community based school which teachings on saturdays, there are over 15 volunters who do not get paid to teach but are still willing to give something back to the society.
i beg you guys out there, you all are geniuses!!! please help us design this simple system. please if somebody already knows where i can get a system like this free of charge then let me know ASAP!
I would like to thankyou in advance for reading thins messge.
View 2 Replies
View Related
May 8, 2007
I’m looking for a Microsoft Access Database that is for library Management.
Any help or directions where I can get help would be great.
BR,
Fahad
View 5 Replies
View Related
Dec 17, 2007
Hi all, does any one one have or knows of a daycare attendance tracking and management database. We are a non profit org. Action for children out of Columbus, Ohio.
Thank you in advance for your cooperation.
Ronny Medina
Ronnymedina@actionforchildren.org
614-224-0222 ext 163
View 4 Replies
View Related
Oct 30, 2006
Hi,
I'm new to this forum so if I ask something stupid please forgive :)
I want to do something like the contact management database which is offered by microsoft for download.
I played a little with it and my problem is I copy-pasted the "calls" tab and on the pasted tab when I browse throug the different calls the call notes field below wont change / update. I thought there is maybe a macro behind it but I looked at every macro and did not find anything appropriate in my opinion.
It is maybe only a minor but I can not figure it out,
Thanks for any help in advance,
Leslie
PS.: I uploaded the database to rapidshare : http://rapidshare.com/files/1305209/Contact_management_database.mdb
View 14 Replies
View Related
Dec 11, 2006
Hi all,
I need your help.
I am in process of designing a Contract Management database.
I have three tables
The first one is Contracts Details table, with these columns:
Contract ID, Contract Name, Vendor ID, Vendor Name, Start Date, End Date, Type, and Description.
The second table is Vendors table, with these columns:
Vendor ID, and Vendor Name.
The third table is VendorContact table, with these columns:
Vendor ID, Contact Person, Phone, Mobile, Fax, Email, and id.
I want you to help me to construct the relations?
Kindly, see the attached database.
View 4 Replies
View Related
Feb 18, 2008
Hello,
I am a newbie,
I am create Incident Management Database for our office.
I have sorted relationships & a form in the database but i need more help with a form.
The main table in the database is INCIDENT and there are lots of lookups and 3 tables with one to many relationships.
Now in my database, i must save the Incident entry first and only then i can add info in witness table. Is there any way that the data about the incident gets saved as soon as users try to enter witness info regarding that incident?
Please see attached two images to get better idea.
Any help is appreciated.
See the link below (copy n paste in web browser)
docs.google.com/Doc?id=df4ks7hh_21gxccsng4
View 1 Replies
View Related
Mar 14, 2006
I am looking for a database that can keep up with the full management issues relating to single family houses. Some are on a lease. Some are on owner-financed by use. Any help would be great!
I am willing to pay a designer to program this database for me. Email any samples or questions to babyfacedavid@yahoo.com
Regards,
David
View 1 Replies
View Related
Jan 16, 2008
Hi,
I am new to this post. I am a physician with interest in database designing. I have been trying to design a database for my clinic for few months but am unable to make one. I have been searching/ reading alot of info and came across this thread. Maybe someone can help me.
Actually, I want to make a database regarding ultrsound scan examinations of patients.
I have five tables.
1. Patients. (patinetid*, patientname, age, sex, address, contact no)
2. Physicians. (physicianid*, physicianname, speciality, address, contact no)
3. Scans. (Scanid*, scanname, charges)
4. Scan orders.(scanorderid*, patientid*, physicianid, scanordernumber, scandiscount, totalcharges)
5. Scanorder details.(scanorderdetailid*, scanorderid, scanid, charges, discount)
I want to have primary key for scanordernumber which wil be the patient number and should this be placed in patient table??
All the ids have been linked with one to many reltionships. Actually I am unable to set proper relationship.
So when the patient arrives he is registered with a unique number, a physian name with date added and scan ordered is entered. Sum calculated. I have done the later part with the form all designed but the relationships and primary key are all messed up.
I can post an image of relationships or blank database.
Kindly advise. Thanks in advance.
View 14 Replies
View Related
Nov 7, 2005
I am a modular housing sales consultant and I am trying to setup a work order database in access. This database would allow me to spec out a modular home for a prospective customer/client as they provide me with all of their home options (floors, exterior, doors & windows, interior, appliances, bathrooms, kitchen, etc.) and then print out an invoice with an estimated total.
I am currently using an excel spreadsheet and it is very cumbersome to use. I use it as an invoice and the invoice contains the following information on it.
Bill to:
Dealer Name
Dealer Rep
Phone, Fax, Cell
Ship to:
Customer Name
Customer Address
Phone, Fax, Cell
Home Options:
Floors:
Joist: (Structure Wood 2X8 Joist, Structure Wood 2X10 Joist, Plywood 2X10 Joist)
Carpet: (Cappuchinno, Biscuit, Pebble, Summer Straw, Praline, Herringbone, Cashew, Buckskin, Shale, Botanical, Cordovan, Stone, Cascade, Black Ice)
Vinyl Flooring: (Woodgrain #05296, Square Tile #57296, Mosaic #55296, Tan Stone #08296, Large Square Tile #07296)
Interior:
Interior Doors: (install, ship loose, 6 panel, flat)
Hardware: (Brass, Brushed Nickle, Round Knob, Level Handle)
Crown Molding: (4", 5")
Base Molding: (4", 5")
Appliances:
Color: (White, Black, Bisque, Stainless)
Dishwasher: (Standard, Power Scrub)
Microwave: (Over Range, Free Standing)
There are other options but this is just a brief listing of options as an example.
Each option would have a price attached, and selected price would be added to the invoice, and once work order is completed, the invoice would have options totalled. Ready for the customer and dealer to confirm and approve.
Can someone start me in the right direction on getting the tables setup for this - the one that I seem to be having the most difficulty with is how to setup the options for this invoice. I pretty well have a grasp on the others. I might also need help in relating the tables to one another.
I hope this all makes sense.
Any help would be greatly appreciated.
Donm
View 2 Replies
View Related
Mar 19, 2007
Hi, I wonder if anyone could help. I'm in the planning stages of creating a order manager in access for multiple ecommerce sites.
Database will store data on Customers, Inventory, Invoices, Returns, Shipments, Credits, Quotes etc for all sites, and also custom reports. And the idea is to have the database generate the ecommerce sites automatically as static html, which can be uploaded. As the orders come in they will be stored online, and then periodically downloaded into the database.
The reason is we currently have 3 sites running and managing inventory and stock control is the hardest, as currently there are 3 databases controling stock! Also when a customer telephones its difficult to know which site they have ordered from which is unprofessional, and we have to log into every site just to find their order.
Future ideas:- Meaning we are going to setup more sites which will obivously make the situation worse. We also want to branch out in into eBay using the eBay API to download transactions and sales, and will therefore need a place to store the data.
Can anyone foresee any problems with such a system? Any ideas or examples?
Thanks for your time.
View 2 Replies
View Related
Mar 22, 2007
I have an order database Access 2000 for an inspection company, tblInspectors, tblOrders, tblCustomers, I want to be able to calculate inspector pay within order database. Each inspector is an independent contractor, so it just needs to calculate percentage, for each inspection performed and total for pay period. Each inspector is paid a different percentage, which is stored in tblInspectors. Payroll is paid every two weeks . . . I've been trying to figure out the best way to do this ... :confused: Any advise be greatly appreciated.:confused:
View 4 Replies
View Related
Sep 6, 2005
I have taken the Order Entry database sample from Microsoft and have added a "Wizard" type interface.
Question) I'm having trouble understanding how to get more than one Feature applied to a single new service.
- For example, If I add a new SERVICE to an ORDER, and I need to add all available FEATURES to that SERVICE, how do I do that? *see my attached database & relationships. The form of FEATURES is also attached. I just want to be able to check off the ones that apply.
(is this many to many? I tried a junction table but can't make it work)
I would really appreciate some advice on my Forms, and definitely advice on my Table / Relationship structure.
ps: My tblServices use to be called tblProducts. I then added the tblCategories, tblPaid, tblTeleServ, tblLongDistRate, tbl800Serv & tblFeatures.
Thanks in advance for your help,
jlig
View 1 Replies
View Related
Nov 22, 2012
I am new to Access. I am creating a simple order/payment database.
I have tables for the orders and payments and have a relationship setup.
I created an order form with a subform for the payments.
[URL] .....
View 2 Replies
View Related
Feb 28, 2005
I have 2 databases Product, with 3 entries ProdID, ProdName and UnitCost.
2nd database Order has Order ID, ProdName, UnitCost, Quantity, SaleDate and Total.
I want to create a form to input data into the Order databse that allows me to enter several rows using the data from the product table by selecting ProdName(Product) from list and UnitCost(Product) being inserted into each row automatically as a new ProdName is selected.
Can anyone hsuggest how best to do this.
View 4 Replies
View Related
Aug 23, 2013
I have been asked to create a database that creates orders, debits stock etc for my company. Now I have been asked to put in some kind of discount table with percentages for each individual item for each individual customer. What would the best way of doing this?
I figured in the Customer Table I would have a code such as 'CustomerADiscount' and 'CustomerBDiscount' etc. and then in my table maybe
Product A - CustomerADiscount - 10%
Product A - CustomerBDiscount - 20%
Product B - CustomerADiscount - 5%
Product B - CustomerBDiscount - 7%
This link these values up within a query? Would this be the best way of doing it?
Is Access able to determine a percentage in "10%" or "5%" or do I need some type of formula for it instead?
View 3 Replies
View Related
May 28, 2012
My question is simple: I've got a database of my book collection. If i view it in a style sheet, it is something like
Author Title etc.
A 0
C 1
B 3
F 2
D 5
D 4
A 8
F 9
I would like to order the Author and Title columns (permanently). Particularly, I would like to order in alphabetical order all the authors and, if I've got the same author, order his/her book alphabetically, something like:
Author Title etc.
A 0
A 8
B 3
C 1
D 4
D 5
F 9
How can I achieve this?
View 5 Replies
View Related
Feb 5, 2013
Is it possible to direct the placement/order new of fields when modifying an Ms Access database in code?
I need to modify the schema of an MS Access database via code - but I want to be able to direct the order or placement of the fields within the tables.
For example - if TableOne has 3 fields - Field10, Field20 and Field30.
I would like to be able to add say Field15 between Field10 and Field20 - not just append it to the end of existing fields.
I believe it is possible as you can do it within Ms Access itself. I can use ADO, DAO, ADOX or SQL for that matter - but it seems all of these offer no placement of the field within the table.
View 13 Replies
View Related
Nov 4, 2006
Hello - I have a list of approx. 500,000 numbers and want to:
1) Highlight any duplicates
2) Test one list against another for common numbers
Can anyone suggest how this can be done in Access?
Thanks,
Cameron
View 1 Replies
View Related
Dec 1, 2006
I have over the last few months been building my own Project management system.This is based around A Phase task principle but the phases and tasks are used to create an estimate for a project depending on how much time is assigned to each Task.The system can use multiply Estimates with different billing codes plus their is a billing code system where billing can be done by a default list of codes (Rates 1-5) Or assigned rates for a client.I'm not after any money for it and will make it available to members hear.If anybody want to look at it and maybe make suggestions on improvements or let me know of any errors that would be greatIt would be an mde with an mdb back end.You should be able to update the back end that I don't think will be a problem LOL When it comes to new versions.As I said I don't want ANYTHING For you using it but would be nice to get it working better.mickp.s Ill Post some pictures if ya want. And It is a work in progress?Please use this topic from now on http://www.access-programmers.co.uk/forums/showthread.php?t=121117 this is where the beta 1 downloads available from.
View 14 Replies
View Related
Nov 10, 2005
I get this from a query
date___ name
1_______1
2_______1
3_______2
4_______3
5_______4
6_______4
field date is unique while field name has
what can i do to get the following such that there are no duplicates for
the name field
_________________________________________________
| name | date1 | date2 | date3 | date4 | date5 | date6 |
-------------------------------------------------------|
|1 ____|1 ____ |2 ____| ____ | ______| ______| _____|
|------------------------------------------------------|
|2 ____| _____ | _____|3 ___ | ______| ______| _____|
|------------------------------------------------------|
|3 ____| _____ | _____| ____ |4 ______| _____| _____|
|------------------------------------------------------|
|4 ____| _____ | _____| ____ | _______|5 ____|6 ____|
|------------------------------------------------------|
Best Regards
manolo
View 2 Replies
View Related
Feb 21, 2005
Hi
i have 2 fields
order date and delivery date using a calender operation
does anyone know how to make it so that the delivery date cannot be sellected on a date before the order date?
cheers
kev
View 3 Replies
View Related
Oct 12, 2005
I'm just wondering if anyone has made a very advanced budget management program using just access?? I tried to make one for myself but I just want it to advanced for my little knowledge of access. I would love to be able to keep track of all my expenses including everything bought from groceries to hair cuts. I would love to be able to take my receipt from walmart and enter everything bought and the price for each item. Then I would love to be able to at anytime search for soap and thing with soap in the Item name will be displayed with the location and the date and price. This way I can keep track not just what I spend on groceries but what I spend on mountain dew or what i spend on hamburger in a given time. This is just way to complicated for me! I hope someone can help me out here maybe give me a shell and let me try to fill in certain parts or if someone already has one that works kind of like this maybe i could just change a few things to the way i want it! I really appreciate this!!
Bass
View 4 Replies
View Related
