relationship with multiple tables

Guest · Dec 4, 2003

Hello and thanks for the help. I am using OFfice Xp. Ihave a db with 3 tables. All are correctlly related. When I put all three tables in the query I am not able to change any data. Can NOT add, delete or modify any records. The add new records button is grayed out. What's going on? How do I get to use the data in these tables.

Here are the specifics.

Student Table -- Primary Key SSN related to the Contacts table with a one-to-one relationship with SSN

Contacts Table -- Primary Key SSN -- it is the secondary table to the Student table with the SSN primary key. It is also related to the Infractions table with the SSN as a One-to-many relationship.

Infractions Table -- Another field (autonumber) is the primary key -- this is the secondary table related to the Contacts table with the SSN field.

I don't understand why I lose the ability to data entry in the queries...HELP...THANKS !

Andy B · Dec 4, 2003

Sheri

I guess you are talking about Access. You may want to try an Access NG,
rather than this, which is Excel.

Looking at your post, it looks like either one of the Allow Add (Edit,
Deletion) fields is set wrong in one of the tables. Do you get 'this
recordset is not updateable' error?

Andy.

Sheri said:
Hello and thanks for the help. I am using OFfice Xp. Ihave a db with 3

tables. All are correctlly related. When I put all three tables in the query
I am not able to change any data. Can NOT add, delete or modify any records.
The add new records button is grayed out. What's going on? How do I get to
use the data in these tables.

Here are the specifics.

Student Table -- Primary Key SSN related to the Contacts table with a

one-to-one relationship with SSN

Contacts Table -- Primary Key SSN -- it is the secondary table to the

Student table with the SSN primary key. It is also related to the
Infractions table with the SSN as a One-to-many relationship.

Infractions Table -- Another field (autonumber) is the primary key -- this

is the secondary table related to the Contacts table with the SSN field.

I don't understand why I lose the ability to data entry in the

queries...HELP...THANKS !

Earl Kiosterud · Dec 5, 2003

Shen,

YOu might want to ask this in one of the Access groups.

I presume there's an SSN field in the infractions table. Try making that
field indexed. Dups OK, I guess, so a student can have more than one
infraction going on at a time!

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------