If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
access 2000
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. |
#3
|
|||
|
|||
access 2000
"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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Suggestion on updating Access 2000 to Access 2003 | Irshad Alam | General Discussion | 5 | August 10th, 2005 01:51 PM |
Running Access 2000 RunTime on Windows XP Pro SP 2 | Hemil | General Discussion | 0 | December 16th, 2004 01:37 AM |
Strange behavior moving from Access 97 to Access 2000 | Dirk Goldgar | Using Forms | 2 | October 25th, 2004 06:29 AM |
Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |
Problem running Access 2003 and Access 2000 apps on same machine. | Rathtap | General Discussion | 3 | June 13th, 2004 01:30 AM |