A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Two primary key fields/Unique Index problems



 
 
Thread Tools Display Modes
  #1  
Old March 31st, 2005, 12:31 AM
Rebecca
external usenet poster
 
Posts: n/a
Default Two primary key fields/Unique Index problems

We are working in Access 2000. Our database has three tables: People, Emails,
and Volunteer Data. The People and Emails tables (both have data in them)
have been imported from another database and are related by two primary key
fields: a family number and an individual number. We added the Volunteer Data
table in access and have included fields for the family number and individual
number as well as fields for all the volunteer information we need to track.
We’ve created a query and built a form off that query that allows us to pull
up a name (using the filter by features), and then we can enter the volunteer
information for that person. Our problem is that all of the volunteer info is
being saved, but we have been unable to populate the Family # and Individual
# primary key fields for the Volunteer Data table, meaning our data is there
but it is not associated with any record. So when we pull up a record for
someone we’ve already entered, the volunteer data is blank. How do we
populate those fields in the Volunteer Data table? We’ve tried working with
the relationships but we are getting a unique index error that we don’t know
how to get past due to the two primary key fields. The family # is unique to
each family, so there will be duplicates. Each family member has a unique
individual #. We’ve thought and thought and can’t get anywhere. We hope this
is enough information to give someone an idea of what we are trying to
accomplish.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
indexing both sides of a table relationship join Paul James Database Design 6 November 12th, 2004 01:55 AM
Here's a shocker Mike Labosh General Discussion 2 October 26th, 2004 05:04 PM
Index or primary key cannot contain null values Dan Using Forms 1 July 15th, 2004 04:39 PM
Indexing - Global refresh/deletion of index marks Ray Cleere Formatting Long Documents 2 April 30th, 2004 04:31 PM
Indexing - Global refresh/deletion of index marks Ray Cleere Formatting Long Documents 0 April 30th, 2004 10:46 AM


All times are GMT +1. The time now is 09:36 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.