Please suggest relationships model

Do you approach your customers in the same one-track view you have looked at
my response in this thread? You saw I made a response and immediately
convinced yourself to take the Arno R, John Marshall, Keith Wilby narrow
minded view. You denied yourself critical, need to know, information!

Take a look at the OP's original post. Quote: "Can someone suggest an
efficient relationships model to make this work?" Now look at my response.
Here it is in its entirety:

I have assumed that your inventory items are consumable and periodically you
purchase items to replenish your inventory.

TblJob
JobID
JobNumber
JobDescription
Job Address fields

TblItem
ItemID
ItemDesc
QuantityOnHand

TblItemToJob
ItemToJobID
JobID
ItemToJobDate

TblJobItem
JobItemID
ItemToJobID
ItemID
Quantity
JobItemAssignedCost

TblItemVendor
ItemVendorID
VendorName
Vendor contact fields

TblVendorItem
VendorItemID
ItemVendorID
ItemID
ItemCost

TblItemPurchase
ItemPurchaseID
ItemVendorID
PurchaseDate
PurchaseOrderNumber

TblItemPurchaseDetail
ItemPurchaseDetailID
ItemPurchaseID
ItemID
Quantity
UnitCost

If you need help, I can help you for a very reasonable fee. Contact me at my
email address below.

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


Now look at what I provided the OP. He asked for a "suggest an efficient
relationships model" and I gave him my suggestion. It was only after this
that I offered fee-paid help for a very reasonable fee if he needed further
help. The OP had a set of tables to work with just as he asked and if he
felt he could take it from that point he was free to start working on his
database. However, if he wanted his database quick and painless, I provided
him a resource to go to get that. That was additional help provided to the
OP whereby he could avail himself of that help if he so decided. That's
called value added in business jargon. That's the same as telling an OP to
go out and buy Ken Getz's Developer's Handbook if he wants to do something
covered in that book. You frequently see that recommendation in the
newsgroups.

The path to success lies in looking at the forest and not a single tree.

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






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

If the business owner came here seeking advice then that's what he should
get FREE advice. If the business owner wants to hire a professional the
that's what he should he should get. What the business owner should not
get is services he didn't ASK for. You offer your services BEFORE anyone
even ASKS for it, do you ot understand the difference? That is the ONLY
point I am trying to make.

Here you are in the newsgroup offering services that were NOT ASKED for.
I am glad you are so successful but honestly I have to wonder why you then
risk it all to 'troll' in newsgroups? Your reputation is all you have and
what would your customers think if they knew you were in newsgroups
'fishing' for customers, knowing this is NOT the place for such actions?

I got to be a consultant in the same way you did. And here is where I am
now -- I work from home and have not had a 9-5 job in almost fifteen
years. I have three full time developers working for me. I have done
thousands of small jobs for customers just like the people who post in
the newsgroups and a few larger jobs.

Okay, then how would you feel if someone suggested you couldn't do it and
did it for you? Where would you be today, at your 9 to 5 job. I have not
done thousands of jobs, nor is that my goal because I don't do small jobs
anymore, I pass them on to others. (As a matter of fact, I'm TRYING to
take August off.) And when work runs out I will look for more but NOT in
the FREE newsgroups.

My mission has always been to provide customers a resource for help with
Access, Excel and Word applications. My fees have always been very
reasonable.

I find it interesting that you feel the need to keep repeating how
reasonable your fees are, which is to me would indicate they are not. It
sounds like a car salesman telling me how reasonalble he's being in on my
trade in with his fingers crossed behind his back!

I strive to work together with customers and I strive to make the
customer feel well-satisfied working with me. It has been very successful
for me. After all these years, I still am learning and I recognize that
the learning will never stop. After all these years, I am the first to
admit I make mistakes. However, I always make my best effort to correct
my mistakes.

As I said before, your reputation is all you have and right now if I were
a customer and looked you up in the newsgroup, I'm looking for someone
else. If it is true that you try to correct your mistakes then STOP
'trolling', you can see it's wrong, at the very least WAIT till they ask
for help. It's kind of like the phone solictors always calling asking
don't you want to refiance? Well, IF I ever thought about it, I would
NEVER call any of the ones that harassed me by calling me.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II
"Steve" wrote in message
link.net...
And where do you think a business owner would be if he spent five years
trying to create databases for his company rather than hiring some one to
create databases for him and he managing his business? For that matter,
where do you think a company would be if key employees spent five years
trying to create databases for their company rather than asking their
manager to hire someone to create databases for him?

I got to be a consultant in the same way you did. And here is where I am
now -- I work from home and have not had a 9-5 job in almost fifteen
years. I have three full time developers working for me. I have done
thousands of small jobs for customers just like the people who post in
the newsgroups and a few larger jobs. My mission has always been to
provide customers a resource for help with Access, Excel and Word
applications. My fees have always been very reasonable. I strive to work
together with customers and I strive to make the customer feel
well-satisfied working with me. It has been very successful for me. After
all these years, I still am learning and I recognize that the learning
will never stop. After all these years, I am the first to admit I make
mistakes. However, I always make my best effort to correct my mistakes.

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






"Gina Whipp" wrote in message
...
To answer your question...

If he wants to do it himself which I am gathering because here he is in
a FREE newsgroup then I, along with folks much more qualified, assist
him. I will NOT 'push' my services on him.

However, if is asking for paid help, I will direct him to the MANY sites
where he could look for a professional in his area, as well as, check
their references, perhaps even have them come in and show samples of
their work. I WILL NOT EVER suggest myself. If he happens to find my
name on one of those MANY sites where you post your services, then I
would mention I saw him in a newsgroup. But I am NOT here to 'fish' for
business and I am certainly NOT gong to suggest hiring a professional
prior to him/her even asking for one.

I was a beginner once and this is where I came to learn and I still come
for tips. I would have been insulted if someone suggested I was
incapable of doing this myself. Look at me now, I contract for several
companies. Where would I be if I had not dared to try? If these groups
weren't here? If I hired a prefessional? Now I work from home, I have
not had a 9-5 job in 5 years and NEVER ONCE did I go trolling!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II
"Steve" wrote in message
link.net...
O.K., let's put it in other words ---

If you saw a post by a business owner where it is obvious he has only
dabbled in Access and he says he desparately needs 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
...
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

I have three full time developers working for me. I have done thousands
of small jobs for customers just like the people who post in the

Gina, this is where the warning bells go off. If he has "helped" thousands,
he would not have time to "help" in the newsgroups let alone solicite
because he would be swamped with follow ups? Is he exagerating about the
numbers or was he able to satisfy them 100% the first time. Some thing seems
fishy even with a client base of 100, he should be busy for life.

John... Visio MVP

My fees have always been very reasonable. I strive to work together with
customers and I

Still can not resist the opportunity to solicit?


resource for help with Access, Excel and Word applications.

Your webpages speak volumes about your expertise in these areas.


It has been very successful for me.

So why do you need to annoy posters in these newsgroups with your gorvelling
for work?


After all these years, I am the first to admit I make mistakes.

Pull the other one. You are the last and you usually are in full denial when
your mistakes are pointed out.


However, I always make my best effort to correct my mistakes.

Unfortunately, that is not good enough. Yu are still abusing these
newsgroups.


John... Visio MVP

Steve,

It is obvious you are the one that is on the same track as you STILL don't
see my point. No point in contiuing this as you are going to continue to
abuse these newsgroups. There's an old saying "Trying to change someone is
as useless as trying to teach a pig to dance. It is a waste of time, and it
really ****es the pig off."

I'm done trying...
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II
"Steve" wrote in message
hlink.net...
Do you approach your customers in the same one-track view you have looked
at my response in this thread? You saw I made a response and immediately
convinced yourself to take the Arno R, John Marshall, Keith Wilby narrow
minded view. You denied yourself critical, need to know, information!

Take a look at the OP's original post. Quote: "Can someone suggest an
efficient relationships model to make this work?" Now look at my response.
Here it is in its entirety:

I have assumed that your inventory items are consumable and periodically
you
purchase items to replenish your inventory.

TblJob
JobID
JobNumber
JobDescription
Job Address fields

TblItem
ItemID
ItemDesc
QuantityOnHand

TblItemToJob
ItemToJobID
JobID
ItemToJobDate

TblJobItem
JobItemID
ItemToJobID
ItemID
Quantity
JobItemAssignedCost

TblItemVendor
ItemVendorID
VendorName
Vendor contact fields

TblVendorItem
VendorItemID
ItemVendorID
ItemID
ItemCost

TblItemPurchase
ItemPurchaseID
ItemVendorID
PurchaseDate
PurchaseOrderNumber

TblItemPurchaseDetail
ItemPurchaseDetailID
ItemPurchaseID
ItemID
Quantity
UnitCost

If you need help, I can help you for a very reasonable fee. Contact me at
my
email address below.

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


Now look at what I provided the OP. He asked for a "suggest an efficient
relationships model" and I gave him my suggestion. It was only after this
that I offered fee-paid help for a very reasonable fee if he needed
further help. The OP had a set of tables to work with just as he asked and
if he felt he could take it from that point he was free to start working
on his database. However, if he wanted his database quick and painless, I
provided him a resource to go to get that. That was additional help
provided to the OP whereby he could avail himself of that help if he so
decided. That's called value added in business jargon. That's the same as
telling an OP to go out and buy Ken Getz's Developer's Handbook if he
wants to do something covered in that book. You frequently see that
recommendation in the newsgroups.

The path to success lies in looking at the forest and not a single tree.

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






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

If the business owner came here seeking advice then that's what he should
get FREE advice. If the business owner wants to hire a professional the
that's what he should he should get. What the business owner should not
get is services he didn't ASK for. You offer your services BEFORE anyone
even ASKS for it, do you ot understand the difference? That is the ONLY
point I am trying to make.

Here you are in the newsgroup offering services that were NOT ASKED for.
I am glad you are so successful but honestly I have to wonder why you
then risk it all to 'troll' in newsgroups? Your reputation is all you
have and what would your customers think if they knew you were in
newsgroups 'fishing' for customers, knowing this is NOT the place for
such actions?

I got to be a consultant in the same way you did. And here is where I am
now -- I work from home and have not had a 9-5 job in almost fifteen
years. I have three full time developers working for me. I have done
thousands of small jobs for customers just like the people who post in
the newsgroups and a few larger jobs.

Okay, then how would you feel if someone suggested you couldn't do it and
did it for you? Where would you be today, at your 9 to 5 job. I have
not done thousands of jobs, nor is that my goal because I don't do small
jobs anymore, I pass them on to others. (As a matter of fact, I'm TRYING
to take August off.) And when work runs out I will look for more but NOT
in the FREE newsgroups.

My mission has always been to provide customers a resource for help with
Access, Excel and Word applications. My fees have always been very
reasonable.

I find it interesting that you feel the need to keep repeating how
reasonable your fees are, which is to me would indicate they are not. It
sounds like a car salesman telling me how reasonalble he's being in on my
trade in with his fingers crossed behind his back!

I strive to work together with customers and I strive to make the
customer feel well-satisfied working with me. It has been very
successful for me. After all these years, I still am learning and I
recognize that the learning will never stop. After all these years, I am
the first to admit I make mistakes. However, I always make my best
effort to correct my mistakes.

As I said before, your reputation is all you have and right now if I were
a customer and looked you up in the newsgroup, I'm looking for someone
else. If it is true that you try to correct your mistakes then STOP
'trolling', you can see it's wrong, at the very least WAIT till they ask
for help. It's kind of like the phone solictors always calling asking
don't you want to refiance? Well, IF I ever thought about it, I would
NEVER call any of the ones that harassed me by calling me.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II
"Steve" wrote in message
link.net...
And where do you think a business owner would be if he spent five years
trying to create databases for his company rather than hiring some one
to create databases for him and he managing his business? For that
matter, where do you think a company would be if key employees spent
five years trying to create databases for their company rather than
asking their manager to hire someone to create databases for him?

I got to be a consultant in the same way you did. And here is where I am
now -- I work from home and have not had a 9-5 job in almost fifteen
years. I have three full time developers working for me. I have done
thousands of small jobs for customers just like the people who post in
the newsgroups and a few larger jobs. My mission has always been to
provide customers a resource for help with Access, Excel and Word
applications. My fees have always been very reasonable. I strive to work
together with customers and I strive to make the customer feel
well-satisfied working with me. It has been very successful for me.
After all these years, I still am learning and I recognize that the
learning will never stop. After all these years, I am the first to admit
I make mistakes. However, I always make my best effort to correct my
mistakes.

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






"Gina Whipp" wrote in message
...
To answer your question...

If he wants to do it himself which I am gathering because here he is in
a FREE newsgroup then I, along with folks much more qualified, assist
him. I will NOT 'push' my services on him.

However, if is asking for paid help, I will direct him to the MANY
sites where he could look for a professional in his area, as well as,
check their references, perhaps even have them come in and show samples
of their work. I WILL NOT EVER suggest myself. If he happens to find
my name on one of those MANY sites where you post your services, then I
would mention I saw him in a newsgroup. But I am NOT here to 'fish'
for business and I am certainly NOT gong to suggest hiring a
professional prior to him/her even asking for one.

I was a beginner once and this is where I came to learn and I still
come for tips. I would have been insulted if someone suggested I was
incapable of doing this myself. Look at me now, I contract for several
companies. Where would I be if I had not dared to try? If these groups
weren't here? If I hired a prefessional? Now I work from home, I have
not had a 9-5 job in 5 years and NEVER ONCE did I go trolling!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II
"Steve" wrote in message
link.net...
O.K., let's put it in other words ---

If you saw a post by a business owner where it is obvious he has only
dabbled in Access and he says he desparately needs 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
...
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

John,

I must concur... I myself am having a hard time with the 'few' (compared to
thousands) clients I have. I am looking for help because of the support,
upgrades and can you please add issues that come up now! Oh well, I guess I
figured a rational conversation would do the trick but I was wrong.

Off to code I go, as with my skimpy client base I have to work and yet
another weekend!

--
Gina Whipp

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

"John Marshall, MVP" wrote in message
...
I have three full time developers working for me. I have done thousands
of small jobs for customers just like the people who post in the

Gina, this is where the warning bells go off. If he has "helped"
thousands, he would not have time to "help" in the newsgroups let alone
solicite because he would be swamped with follow ups? Is he exagerating
about the numbers or was he able to satisfy them 100% the first time. Some
thing seems fishy even with a client base of 100, he should be busy for
life.

John... Visio MVP

Look again at my post. Quote: "I have done thousands of small jobs for
customers just like the people who post in the newsgroups and a few larger
jobs." There is no mention there of thousands of clients. You saw John
Marshall say that I said I have thousands of clients and you locked yourself
into the Arno R, John Marshall, Keith Wilby mentality.

You have ten years to think about your approach and then let's see where you
are at at that time.



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






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

I must concur... I myself am having a hard time with the 'few' (compared
to thousands) clients I have. I am looking for help because of the
support, upgrades and can you please add issues that come up now! Oh
well, I guess I figured a rational conversation would do the trick but I
was wrong.

Off to code I go, as with my skimpy client base I have to work and yet
another weekend!

--
Gina Whipp

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

"John Marshall, MVP" wrote in message
...
I have three full time developers working for me. I have done thousands
of small jobs for customers just like the people who post in the

Gina, this is where the warning bells go off. If he has "helped"
thousands, he would not have time to "help" in the newsgroups let alone
solicite because he would be swamped with follow ups? Is he exagerating
about the numbers or was he able to satisfy them 100% the first time.
Some thing seems fishy even with a client base of 100, he should be busy
for life.

John... Visio MVP

W0W! ... I was not expecting to start a flame war here. Just wanted a little
help with my small little project here. The assumptions tat steve made about
it (the need to replenish the inventory) would be nice, but I dont consider
it necessary at the moment.

Of course, I could hire someone or buy an application to do the job, but I
always wanted to create a useful database, never did take an Access course,
but I can get the hang of most things on my own, with just a tiny little
push. And besides, this is just a one-time deal, so the life of this database
will end when the inventory runs out ( in about 3 - 4 months)

With that said, I might as well add that I pretty much figured out how the
data is stored, and what kind of fields I need to have in my tables.
Relationships is the one thing that I just dont get, which is why I
originally asked for a relationships model.

But thanks (especially Gina for your links), I'll check them out, maybe I
can get what I need to get me going.

--
Moe

It was not your fault. Master santos knows the rules and choses to ignore
them.

These newsgroups were set up by Microsoft for free peer to peer support, so
that users can ask questions without being hounded by snake oil salesmen.
Over the past few years, master santos has chosen to be the only one who has
chosen to disregard this fact, pretends to be an expert and hounds
unsuspecting users for work.

John... Visio MVP

"Moe" wrote in message
...
W0W! ... I was not expecting to start a flame war here. Just wanted a
little
help with my small little project here. The assumptions tat steve made
about
it (the need to replenish the inventory) would be nice, but I dont
consider
it necessary at the moment.

Of course, I could hire someone or buy an application to do the job, but I
always wanted to create a useful database, never did take an Access
course,
but I can get the hang of most things on my own, with just a tiny little
push. And besides, this is just a one-time deal, so the life of this
database
will end when the inventory runs out ( in about 3 - 4 months)

With that said, I might as well add that I pretty much figured out how the
data is stored, and what kind of fields I need to have in my tables.
Relationships is the one thing that I just dont get, which is why I
originally asked for a relationships model.

But thanks (especially Gina for your links), I'll check them out, maybe I
can get what I need to get me going.

--
Moe

No worries, every once in awhile we run off on tagents in here!

Your welcome... I thought one of those links showed data models (which
actually are relationships) they just choose a differet name. Ayway, best
of luck, and come back for more FREE advice any time you want!

--
Gina Whipp

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

"Moe" wrote in message
...
W0W! ... I was not expecting to start a flame war here. Just wanted a
little
help with my small little project here. The assumptions tat steve made
about
it (the need to replenish the inventory) would be nice, but I dont
consider
it necessary at the moment.

Of course, I could hire someone or buy an application to do the job, but I
always wanted to create a useful database, never did take an Access
course,
but I can get the hang of most things on my own, with just a tiny little
push. And besides, this is just a one-time deal, so the life of this
database
will end when the inventory runs out ( in about 3 - 4 months)

With that said, I might as well add that I pretty much figured out how the
data is stored, and what kind of fields I need to have in my tables.
Relationships is the one thing that I just dont get, which is why I
originally asked for a relationships model.

But thanks (especially Gina for your links), I'll check them out, maybe I
can get what I need to get me going.

--
Moe

If replenishing inventory is not necessary, eliminate TblVendor,
TblVendorItem, TblItemPurchase and TblItemPurchaseDetail from the list I
gave you originally.

Regarding reletionships:
1. In TblItemToJob, join JobID from TblJob to JobID
2. In TblJobItem, join ItemToJobID From TblItemToJob to ItemToJobID
3. In TblJobItem, join ItemID From TblItem to ItemID

When you create the relationships, be sure to check referential integrity.

If you need further help, let me know.

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








"Moe" wrote in message
...
W0W! ... I was not expecting to start a flame war here. Just wanted a
little
help with my small little project here. The assumptions tat steve made
about
it (the need to replenish the inventory) would be nice, but I dont
consider
it necessary at the moment.

Of course, I could hire someone or buy an application to do the job, but I
always wanted to create a useful database, never did take an Access
course,
but I can get the hang of most things on my own, with just a tiny little
push. And besides, this is just a one-time deal, so the life of this
database
will end when the inventory runs out ( in about 3 - 4 months)

With that said, I might as well add that I pretty much figured out how the
data is stored, and what kind of fields I need to have in my tables.
Relationships is the one thing that I just dont get, which is why I
originally asked for a relationships model.

But thanks (especially Gina for your links), I'll check them out, maybe I
can get what I need to get me going.

--
Moe