By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 892 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

Design question regarding a table join

P: n/a
So far I need to store 2 components: Departments and Supplies.
My problem:
Multiple departments may own the same inventory. How do I join my
supply table with the department table. Do I need an itermediate table
? If so what would the field keys be ?

Thanks

Apr 23 '06 #1
Share this Question
Share on Google+
8 Replies


P: n/a
TblDepartment
DepartmentID
DepartmentName

TblSupply
SupplyID
SupplyName

TblDepartmentSupply
DepartmentSupplyID
DepartmentID
SupplyID
DepartmentSupplyInventory

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
re******@pcdatasheet.com
<po*******@gmail.com> wrote in message
news:11**********************@i39g2000cwa.googlegr oups.com...
So far I need to store 2 components: Departments and Supplies.
My problem:
Multiple departments may own the same inventory. How do I join my
supply table with the department table. Do I need an itermediate table
? If so what would the field keys be ?

Thanks

Apr 23 '06 #2

P: n/a
* PC Datasheet:
TblDepartment
DepartmentID
DepartmentName

TblSupply
SupplyID
SupplyName

TblDepartmentSupply
DepartmentSupplyID
DepartmentID
SupplyID
DepartmentSupplyInventory

--
To anyone reading this thread:

It is commonly accepted that these newsgroups are for free
exchange of information. Please be aware that PC Datasheet
is a notorious job hunter. If you are considering doing
business with him then I suggest that you take a look at
the link below first.

http://home.tiscali.nl/arracom/whoissteve.html

Randy Harris
Apr 23 '06 #3

P: n/a
Randy Harris is nothing but an A$$ like his co-conspirator Arno R. They make
no contributions to the newsgroup but feel free to publish their gabrbage on
the newsgroup. Get rid of him by sending a compaint to ab***@prodigy.net.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
re******@pcdatasheet.com

"Please Stop Advertising" <pl****@no.spam> wrote in message
news:7b******************@newssvr11.news.prodigy.c om...
* PC Datasheet:
TblDepartment
DepartmentID
DepartmentName

TblSupply
SupplyID
SupplyName

TblDepartmentSupply
DepartmentSupplyID
DepartmentID
SupplyID
DepartmentSupplyInventory

--
To anyone reading this thread:

It is commonly accepted that these newsgroups are for free
exchange of information. Please be aware that PC Datasheet
is a notorious job hunter. If you are considering doing
business with him then I suggest that you take a look at
the link below first.

http://home.tiscali.nl/arracom/whoissteve.html

Randy Harris

Apr 24 '06 #4

P: n/a
"PC Datasheet" <fa***@email.com> wrote
Randy Harris is nothing but an A$$
like his co-conspirator Arno R.
Very professional of you, Steve.
They make no contributions to the newsgroup
but feel free to publish their gabrbage on
the newsgroup. Get rid of him by sending a
compaint to ab***@prodigy.net.
Or, if you agree with them that PC Datasheet is in violation of earthlink's
Terms of Service or Acceptable Use Policy regarding advertising in
newsgroups and/or disruptive posting, the headers of his message indicate
you can complain to:

X-Complaints-To: ab***@earthlink.net

Should you decide to do so, be sure to include a full copy of the headers of
PC Datasheet's message.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
re******@pcdatasheet.com

"Please Stop Advertising" <pl****@no.spam> wrote in message
news:7b******************@newssvr11.news.prodigy.c om...
* PC Datasheet:
TblDepartment
DepartmentID
DepartmentName

TblSupply
SupplyID
SupplyName

TblDepartmentSupply
DepartmentSupplyID
DepartmentID
SupplyID
DepartmentSupplyInventory

--
To anyone reading this thread:

It is commonly accepted that these newsgroups are for free
exchange of information. Please be aware that PC Datasheet
is a notorious job hunter. If you are considering doing
business with him then I suggest that you take a look at
the link below first.

http://home.tiscali.nl/arracom/whoissteve.html

Randy Harris


Apr 24 '06 #5

P: n/a
Very professional of you, Larry. And you complain about Don Mellon!! You are
beneath him.

If you are tired of seeing Larry constantly on his soapbox being nothing but
boisterous and seldom saying nothing worthwhile but trying to sound like
someone with three lifetimes of experience and just butting into everything
that is none of his business, complain to:

ab***@verizon.net

Should you decide to do so, be sure to include some examples of his
worthless posts in the newsgroup. They won't be hard to find!! Star with
hius boisterous claim that he is one of the original signers of the
Constitution and as such every newsgroup reader ought to bow to him in
homage.


"Larry Linson" <bo*****@localhost.not> wrote in message
news:0cV2g.4755$bU6.1770@trnddc06...
"PC Datasheet" <fa***@email.com> wrote
Randy Harris is nothing but an A$$
like his co-conspirator Arno R.


Very professional of you, Steve.
They make no contributions to the newsgroup
but feel free to publish their gabrbage on
the newsgroup. Get rid of him by sending a
compaint to ab***@prodigy.net.


Or, if you agree with them that PC Datasheet is in violation of
earthlink's Terms of Service or Acceptable Use Policy regarding
advertising in newsgroups and/or disruptive posting, the headers of his
message indicate you can complain to:

X-Complaints-To: ab***@earthlink.net

Should you decide to do so, be sure to include a full copy of the headers
of PC Datasheet's message.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting
help
re******@pcdatasheet.com

"Please Stop Advertising" <pl****@no.spam> wrote in message
news:7b******************@newssvr11.news.prodigy.c om...
* PC Datasheet:
TblDepartment
DepartmentID
DepartmentName

TblSupply
SupplyID
SupplyName

TblDepartmentSupply
DepartmentSupplyID
DepartmentID
SupplyID
DepartmentSupplyInventory

--
To anyone reading this thread:

It is commonly accepted that these newsgroups are for free
exchange of information. Please be aware that PC Datasheet
is a notorious job hunter. If you are considering doing
business with him then I suggest that you take a look at
the link below first.

http://home.tiscali.nl/arracom/whoissteve.html

Randy Harris



Apr 24 '06 #6

P: n/a
Br
Or..

If you are tired of silliness ignore the lot of 'em :)
PC Datasheet wrote:
Very professional of you, Larry. And you complain about Don Mellon!!
You are beneath him.

If you are tired of seeing Larry constantly on his soapbox being
nothing but boisterous and seldom saying nothing worthwhile but
trying to sound like someone with three lifetimes of experience and
just butting into everything that is none of his business, complain
to:
ab***@verizon.net

Should you decide to do so, be sure to include some examples of his
worthless posts in the newsgroup. They won't be hard to find!! Star
with hius boisterous claim that he is one of the original signers of
the Constitution and as such every newsgroup reader ought to bow to
him in homage.


"Larry Linson" <bo*****@localhost.not> wrote in message
news:0cV2g.4755$bU6.1770@trnddc06...
"PC Datasheet" <fa***@email.com> wrote
Randy Harris is nothing but an A$$
like his co-conspirator Arno R.


Very professional of you, Steve.
They make no contributions to the newsgroup
but feel free to publish their gabrbage on
the newsgroup. Get rid of him by sending a
compaint to ab***@prodigy.net.


Or, if you agree with them that PC Datasheet is in violation of
earthlink's Terms of Service or Acceptable Use Policy regarding
advertising in newsgroups and/or disruptive posting, the headers of
his message indicate you can complain to:

X-Complaints-To: ab***@earthlink.net

Should you decide to do so, be sure to include a full copy of the
headers of PC Datasheet's message.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word
Applications Over 1175 users have come to me from the
newsgroups requesting help
re******@pcdatasheet.com

"Please Stop Advertising" <pl****@no.spam> wrote in message
news:7b******************@newssvr11.news.prodigy.c om...
* PC Datasheet:
> TblDepartment
> DepartmentID
> DepartmentName
>
> TblSupply
> SupplyID
> SupplyName
>
> TblDepartmentSupply
> DepartmentSupplyID
> DepartmentID
> SupplyID
> DepartmentSupplyInventory
>
--
To anyone reading this thread:

It is commonly accepted that these newsgroups are for free
exchange of information. Please be aware that PC Datasheet
is a notorious job hunter. If you are considering doing
business with him then I suggest that you take a look at
the link below first.

http://home.tiscali.nl/arracom/whoissteve.html

Randy Harris


--
regards,

Br@dley
Apr 24 '06 #7

P: n/a
Would be nice if I could read this NG and ignore some people without
downloading everything... the paranoid rants are really getting old.

May 3 '06 #8

P: n/a
Most of the newsreaders allow you to block specific posters.

John... Visio MVP

<pi********@hotmail.com> wrote in message
news:11*********************@i39g2000cwa.googlegro ups.com...
Would be nice if I could read this NG and ignore some people without
downloading everything... the paranoid rants are really getting old.

May 3 '06 #9

This discussion thread is closed

Replies have been disabled for this discussion.