Help with MULTIPLE FOREIGN KEYS..! :crying:

  • HI guys, I just seem to think its really hard to add this table, is there like any threshold on how many foreign keys u have to use in one new table? My system is a hotel management system, and i have to put all the details in the billing section like the room number of the guest, guest number, service number on what he wants to be charged on his room number, i added 3 foreign keys but i am just wondering why i cant add the guest number... everything seems ok when i dont add guest number to the database, but there is an error that says "RELATIONSHIPS MUST BE ON THE SAME NUMBER OF FIELDS WITH THE SAME DATA TYPES". what does this mean exactly??? please help me on this one.

  • Hello,

    Check if the columns involved in the foreignkey are of the same type/size.

    Check if 1side is really unique.

    It think there is a quite high limit on the number of foreign keys depending on the Access version (see the help).

  • ok thanks for the help... 🙂

  • ei.. id like to also ask.... is this a correct syntax??? i forgot to declare it at first...

    ALTER TABLE Guest

    ALTER COLUMN gnum UNIQUE;

    i dunno if thaz correct i hope someone can help me with this one... it wont actually work i tried it... wats the best way to alter the definition of the primary key.... GNUM is actually primary key of my Guest Table, sorry if im asking to many hope someone can help me.

  • A primary key is unique.

    Can you give a short table description?

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply