AnsweredAssumed Answered

ink a very simple database. ...but please help...loosing will...to ..live...

Question asked by splodgehodge on Mar 22, 2010
Latest reply on Mar 25, 2010 by philmodjunk

Title

ink a very simple database. ...but please help...loosing will...to ..live...

Post

I'm using FM10.

I have created a database for school.

One table called - USERS

This has the fields:

STUDENT_ID

FIRST NAME

LAST NAME (ect)

 

I then created a table called ICT

With the fields:

STUDENT_ID

SKILL1

SKILL2

SKILL3 (etc)

 

I linked STUDENT_ID to STUDENT_ID and it all worked well. So well that the other teachers wanted their subjects on the database. Easy...I thought.

I made some new tables.

ENGLISH, MATHS and SCIENCE

All with the key STUDENT_ID to link to the table  USERS

 

Unfortunatley. With all of these now connected I can't input any data

 

It states - Create a new record to input Data but still doesn't allow input.

 

Any help would be really appreciated.

Thanks,

splodge

 

Outcomes