access 2000

[Einar]

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]

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!