If he came to me (your words) then he got my name from someone and contacted
me directly, NOT via a newsgroup, therefore I can do business with him.
However, these people aren't 'coming to you'... you are going to them.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

"Steve" wrote in message
ink.net...
You miised the whole point!

If a business owner who has only dabbled in Access came to you wanting a
way to track his inventory, would you advise him to spend time trying to
create an inventory database and go to the newsgroups, books and other
resources when he needs help or would you advise him to hire someone to
create an inventory database for him and spend his time managing his
business?

Steve



"Gina Whipp" wrote in message
...
Steve,

If this is a reply to my eMail then please don't try to explain your
soliciting to me. It is wrong in a FREE peer-to-peer newsgroup. I
'write' databases and have been doing so for 10 years. Right now, I am
doing 6 contracts and am looking for help but it would never even occur
to me to advertise for help here! And NEVER, let me me repeat that,
NEVER have I ever tried to solicit work from this FREE newsgroup or any
other FREE newsgroup unless they supply a section to do just that. I
don't show my eMail address, no links to my site, NADA, NOTHING, ZILCH...
well, you get the idea, because that is not why these groups are here!

I will also note, that I get my work by word-of-mouth and have to provide
my web page... AND even if I ran out of work tomorrow, I would NEVER
solicit here! I come to here to get help and give help when I can. I
come here to learn, share and sometimes get a good chuckle! I don't come
here to post my resume or sell my services.

So please, don't offer your lame reasoning for trying to drum up
business. If contracting is not working for you get another job until
something comes along.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

"Steve" wrote in message
ink.net...
Do-it-yourself is not always the best decision. In fact, it can be a
very poor decision. Yes, from only the database point of view, if you
create a database and it works for you, do it yourself is cheapest. From
a business perspective, it can be much more expensive than hiring
someone to build the database for you. The do-it-yourself route requires
dedicated time and effort which means taking the time and effort away
from something else. If you could have spent that time in a more
profitable way such as increasing sales, the database cost you the value
of the lost sales and that could easily be many times the fees you would
have paid someone to create the database for you.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications






"Gina Whipp" wrote in message
...
Moe,

Below is a few links to help you get started... Please note, this
FREE newsgroup provided by Microsoft would NEVER dream of charging you.
Everyone (well almost everyone) VOLUNTEERS their time to provide FREE
support and assistance.

Ms Access Fundamentals: http://www.functionx.com/access/

Samples downloads:
http://www.rogersaccesslibrary.com/TableOfContents3.asp

Code, sample downloads, sample coding (I love this site):
http://www.mvps.org/access/

Data model samples: http://www.databasedev.co.uk/data_models.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

"Moe" wrote in message
...
What I need to do:

I have some rather expensive inventory items that I need to keep track
of.
These are to be used in several projects (jobs).

I'm trying to design a simple database to help me keep track of where
everything goes, so I can bill the right job for the right products.

More Details:
Inventory items have an ID, and description. I need to know how many
of each
item I still have remaining.

Jobs have unique ID numbers (I dont want to use autonumber for this).

I was thinking maybe I could design something that would sort of do
transactions.

Assign a transaction ID (Autonumber is ok), A date, a project # (job#)
and how many of each of the inventory items were transfered on that
date, or
transaction.

I did a little designing, and came up with three tables.

Inventory
|_ ID
|_ Description
|_ Quatntity on hand (??)

Jobs
|_ ID
|_ Address

Transactions
|_ ID (autonumber ok)
|_ Date
|_ Quantity
|_ Description

Can someone suggest an efficient relationships model to make this
work?

Thanks in advance

--
Moe