access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to make a data base which (among other fields) has the field "Bank".
In this field I want to register up to 20 banks for each observation (which
is a company). Is that possible? The point is that I want to be able to make
a report that shows which banks are involved with certain companies or the
other way around. I need this multiple registration opportunity in other
fields as well.
 
It sounds like you need the following tables:

TblCompany
CompanyID
<other company detail fields>

TblBank
BankID
<other bank detail fields>

TblBankInvolvedWithCompany
BankInvolvedWithCompanyID
CompanyID
BankID
<other fields you may need for an observation>

You could then enter the data for TblBankInvolvedWithCompany with a
form/subform. The main form wuld be based on TblCompany and the subform
based on TblBankInvolvedWithCompany.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!
 
PC Datasheet said:
If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!
Click to expand...

To the OP:

Steve just does *not* care about the newsgroups. He has *no ethics at all*.
Steve *only* cares about making *money*, and he acts as if the groups are his private hunting ground.

-- He abuses this group and others for job-hunting and advertising over and over again
-- He is insulting lots of people here when they ask him to stop this
-- He posted as Steve, Ron, Tom, Rachel, Kathy, Kristine, Heather and ??? while asking questions
(the latest 'star's': 'Access Resource' and Tom (e-mail address removed) and Andy)
-- He tries to sell a CD ($125,--) with FREE code he gathered from these groups here
-- There even has been a 'Scam-alert' about him which has been explained recently in the thread 'To all':
http://groups.google.com/group/comp.databases.ms-access/msg/46038ba2954261f9?hl=en
-- Also recently it became clear that he has been spamming innocent people asking questions:
http://groups.google.com/group/comp.databases.ms-access/msg/4f76d0ed3e5f58ad?hl=en

So why would ANYBODY ever trust a person like him and hire him?
********************************************************

Explanation and more links on this answer:
http://home.tiscali.nl/arracom/stopsteve.html

Arno R
 
Back
Top