New Record

shadowraven

Registered User.
Local time
Today, 15:45
Joined
May 14, 2002
Messages
75
I am doing this database for some practice ready for an exam, but there is a problem me and my teacher cant sort out.
everytime I try to add a new record in a form it comes up with some error,please help asap
 

Attachments

Query Problem??

Not sure if it the cause of your dilemma because you havn't told us where the error is occuring but...

Your form1 is base on a query but the query does not link the fields so you get the wrong grades for the students ...
Each student has 10 different grades.

Also if you input through form1 then you do not assign a value to the primary key.

As i say not sure if it will help.

If this is not the case can you give us a bit more information

Steve
 
grades database

In the form 2 I want to be able to add a new record and have it update the table its coming form but i always get some form of error saying you can't add or change records at this time because a related record is required in table "GRADES"

I was told to unlink the query as this might have been a problem any ideas greatfuly excepted.
 
It is to do with the primary key field of the grades table ...
When you type data in through form 1 you do not assign a value to the field in grades ... think it is the referential integrity problem.

Had a quick look and have just swapped around the autonumber field to make that your primary key ...
Think that is what you are after ...
If not then there are other ways have a look and let me know...

Steve
 

Attachments

Users who are viewing this thread

Back
Top Bottom