Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 30th, 2003, 11:08 AM
Registered User
 
Join Date: Sep 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Subform/Links ~ Too Many Primary Keys

I am trying to use a subform for data entry but I have four Primary Keys and there are only three spaces in the Linkchild/LinkMaster. This creates an error since the relationships are defined between these two tables based on four Primary keys. What can I do? Any help appreciated.
 
Old September 30th, 2003, 12:48 PM
Registered User
 
Join Date: Sep 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I should have tried harder before I asked. I found the answer. In case anyone else has this problem.

Even though there are only three categories if you click on the build button next to the field, once you fill in those three and go back to the properties menu. What you actually see in the field is this:

LinkChildFields FirstCriteria;SecondCriteria;ThirdCriteria
LinkMasterFields FirstCriteria;SecondCriteria;ThirdCriteria

All you have to do is click at the end and add another criteria

ie

LinkChildFields FirstCriteria;SecondCriteria;ThirdCriteria;FourthC riteria

LinkMasterFields FirstCriteria;SecondCriteria;ThirdCriteria;FourthC riteria


Thanks





Similar Threads
Thread Thread Starter Forum Replies Last Post
inserting records with foreign and primary keys tdaustin Classic ASP Basics 0 October 4th, 2005 12:49 AM
When to define primary keys and foregin keys? method SQL Server 2000 1 August 26th, 2005 09:14 AM
Find() With multiple primary keys busher ASP.NET 1.0 and 1.1 Professional 0 June 2nd, 2005 03:00 PM
ASP and auto-generated primary keys Steve777 Classic ASP Professional 2 May 26th, 2005 10:47 AM
Thoughts on Primary keys rohan_man Access 3 February 9th, 2005 06:18 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.