access 2000

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

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!


"Einar" wrote in message
...
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.

"PC Datasheet" schreef in bericht ink.net...

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!

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 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....954261f9?hl=en
-- Also recently it became clear that he has been spamming innocent people asking questions:
http://groups.google.com/group/comp....3e5f58ad?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