[mso] Help fixing referential integrity problems
- From: "Katherine Driskell Felts" <subscriptions@xxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 2 Aug 2004 12:16:10 -0500
My relationships in my database aren't working right. So, I want to
check the Enforce Referential Integrity to enforce the relationship
between my donor table and my donations table. It won't let me because
there are some records that don't have a donor ID on them. Is there a
way to have it automatically tell me which records are the problem?
Also, I messed up and my donor ID, which is the primary key on the donor
table, is no longer an autonumber. It won't let me turn it into an
autonumber because there are already things entered in the data sheet.
I NEED these numbers to stay the same, because these numbers are the
only identifying features on the Donations list. Can I fix this, or do
I have to guess at a new number everytime I enter a new donor?
Also, I have added new donors and then they aren't there when I use the
form to look for them (there's a little look-up drop down box) on the
form, but they are in the table. Is there another relationship I need
to create?
Kathie
Not as smart as she thought.
Katherine Driskell Felts,
Executive Director
Blooming Prairie Center
Deep Roots, Bright Futures, Unlimited Horizons
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
- » [mso] Help fixing referential integrity problems
