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 Forms
I am a novice and I am trying to create a contact databse to track clients
and RFPs. I have several tables linked with a primary key in what I call General Account Information table and a foreign key that runs throughout the other tables. The primary key is AccountID (autonumber in General Account Information and number in other tables). The hierarchy is the general acccount information, followed by subdivisions (departments) with another table that lists contacts of this department, followed by agencies within these departments and the contacts of the agencies. If you can invision the relationship table I have General Account information on the righthand side with the lower levels running to the right and one-to-many relationships from left to right. I have created a main form that allows me to enter the general account information and have included a command button that leads me to the "department information" form that has a subform for the department contacts. I have used the DoCmd.OpenForm "DepartmentInformation",,,"[SomeID]=Forms![GeneralAccountInformation]![SomeID]" to try and link these forms. However I have been unable to enter new data in my "DepartmentInformation" Form because I get the error message "not a related record in GeneralAccountInformation table" What am I doing wrong? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Why is a French Spellchecker a "required" update for English speak | French Spellcheck Required? | General Discussion | 23 | April 26th, 2005 01:17 AM |
What is the difference between 2002 and 2003? | Red Sonya | General Discussion | 2 | March 1st, 2005 05:10 AM |
is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 09:44 PM |
is Access 2003 any better than XP? | Gorb | Using Forms | 2 | November 11th, 2004 09:20 AM |