ms access relationship problem

  • Thread starter Thread starter g.sanchari
  • Start date Start date
G

g.sanchari

I created a database in access with the following table. but when ever
i try to enter data it gives an error message.
"You cannot add or change a record because a related record is
required in table 'Insti_details'


Name and address of the
institution : .............................................................................
_____________________________________________________
| MALE |
FEMALE |
|------------------------------------------------|------------------------------------------|
| | SC | ST | OBC | GEN | SC | ST | OBC | GEN |
|--------|-------|----------|----------|----------|---------|----------|----------|-----------|
| LP | | | | | |
| | |
|--------|-------|----------|----------|----------|---------|----------|----------|-----------|
| UP | | | | | |
| | |
|--------|-------|----------|----------|----------|---------|---------|----------|------------|
| HS | | | | | |
| | |
|_____|____|______|_____|______|_____|_____|______|_______|

there are more than one institution and each have the complete data.
the tables are

1. Institution - Name, Address1, Address2
2. Division - LP, UP, HS
3. Caste - SC, ST, OBC, Gen.
4. Sex - Male, Female
5. This table contains the above tables ID's and number of students.

The following is the relationship (One to many connection with ID's)

1. ------------------------------------------+
2. -------------------------------------+ |
3. --------------------------------+ | |
4.------------------------+ | | |
|____|___|___|__ 6.

Is the relationship made any problems
 
I'm having trouble visualizing your data structure.

Please consider providing a different "view", perhaps something like:

Table1
Table1ID
Gender
...

Table2
Table2ID
Field1
...

And it sounds like you are saying you have a one-to-many relationship.

Now, WHERE are you seeing the error message? Are you working via a form?
?Directly in the tables?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top