New To Access

[mikebellows]

Hi,
I am completely new to access - Literally started today!
Anyway I have a problem - I am creating a CAD Drawing database / Distribution list. I can only seem to distribute one drawing i.e single field to one person.
Is there a way to have multiple distribtion on one field without creating multiple distribution fields?

What I have is a database which contains Drawing Numbers - I need to create a report that shows where the
drawing has been distributed to, with it's current revision status and the date is was sent.



I am having trouble trying to use multiple revisions and mutiple people in the distribution list with one drawing.

Maybe not the best description!!!


Thanks

Mike ;-)

[orange]

Start by writing down what it is you are trying to accomplish in "business terms".
Don't get hung up in the innards of Access before you build a model of what you are working with.
Understand Normalization and Entity Relationship Drawing before you are overwhelmed with trying to do something quickly.

Step back - understand some concepts

Get your tables set up. Create some test data. Identify some transactions and the expected outcomes. Test your model. Reconcile every issue (unexpected issue) and alter the model or the data until it does what you expect.

There are videos(free) here that may help
http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

http://www.youtube.com/watch?v=lXAGQ8vmhCY ERD Part 2

[mikebellows]

Hi,
Thanks for the reply. Looks like a lot of info to take in.
Unfortunately the company that I work for will not allow access to Youtube.

I take on board your concept - Which I have in part done, but that doesn't help me - I sem to have hit a brick wall.

To me it's simple - I need to show on a report that a single drawing (Including it's current revision status) needs to be recorded as being sent to multiple end users.

Cheers,

Mike.

[orange]

Here's another link (non youtube)

The first few topics are well worth the read.

http://www.rogersaccesslibrary.com/forum/topic238.html

There may be a model or 2 here that can give you some ideas.
http://www.databaseanswers.org/data_models/index.htm

[mikebellows]

Thanks - Much appreciated.

I'm getting Headache now - Trying to work out how to fix my problem ;-(