July 29, 2008 at 10:04 am
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.
July 29, 2008 at 11:22 am
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).
July 29, 2008 at 11:39 am
ok thanks for the help... 🙂
July 29, 2008 at 12:50 pm
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.
July 30, 2008 at 3:12 pm
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