1 Reply Latest reply on Mar 25, 2010 12:19 PM by philmodjunk

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

    splodgehodge

      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