Database from start

E

Excel

Need help with business order
It should be like this example:

BUSINESS ORDER

Id Order: (ex. MK 01/01, MK 02/01, MK 03/01...)
Date:
Customer - Name Customer
Order - many activity (ex. 1. cutting material, drilling material, up to 10
or more activities)
Work hours - (ex. cutting - 2h, sawing 5h, drilling 3h ....up to 10 or more)
Material - (ex material used in work process, steel plates - 150 kg, tubes
15 kg, and more...)

Please help with this database
How many tables! and relationship beetween them.

Thanks, Michael
 
W

Wayne-I-M

Hi

I don't think anyone will be able to answer your question as you don't give
enough detail.

If you don't have a database then you need to make one.
If you can not make one or have never made one before try this site for the
basics
http://www.microsoft.com/learning/default.mspx

You "may" be able to get a ready made database from here
http://office.microsoft.com/en-us/templates/CT101172481033.aspx

and then change it so it will do what you want - but if you don't know how
to do this then you will need do the training first to enable you to create
anything that works as you want it

It will take some time to learn to use access but after a short while you
should be able to create a database that will eprform as required

Good luck with your application
 
J

John W. Vinson

Need help with business order
It should be like this example:

BUSINESS ORDER

Id Order: (ex. MK 01/01, MK 02/01, MK 03/01...)
Date:
Customer - Name Customer
Order - many activity (ex. 1. cutting material, drilling material, up to 10
or more activities)
Work hours - (ex. cutting - 2h, sawing 5h, drilling 3h ....up to 10 or more)
Material - (ex material used in work process, steel plates - 150 kg, tubes
15 kg, and more...)

Please help with this database
How many tables! and relationship beetween them.

Thanks, Michael

So... you want an unpaid volunteer to design and implement it for you?
Probably several hours of unpaid work...

Sorry, but you're being unreasonable here. This is not a forum for free labor;
it's a peer-support forum where people like you, or like me (self employed
computer consultant) to help one another on a volunteer basis.

Here are some resources to help you get started:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
E

Excel

Hello

thanks, but I think that is not clear what I want
I dont need help create database from begining
I have problem with multiple line for one order

Example:
1. Table - Customer 2. Table Orders
id id
name Customer (link to table Customer -
name)
order name (this is problem becose
it has many value)
- cutting steel plates
- drilling
- etc....
Material (link to table material
name, also has multiple values)
- steel plates
- tubes etc...
3. Table Material
id
material name

How do I create form to add multiple values for order name, and material
example of form:
Id: 1
Date: Today
Name: John Doe
Order: drilling plates (add column) cutting (add column) plasma cuting (add
column) etc..
Material: Steel plates (add column) Tubes (add column) etc..

Thanks in advance, Michael
 
J

John Spencer

It looks like you need tables to hold the OrderMaterials and OrderActivities
with a foreign key in both to point back to Orders.ID field.

You can use subforms on a main form to control the data entry.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top