Posted by Frankly on 06/20/06 01:10

i Have a table with 2 primary keys any time i try to make a relation it does
work.
i do not know how to view the sql from the administrator so cant tell if its
2 primary keys or id+id primary key.
I have created lots of relationships in Acces. video tutorials is one place
that MS has the upper hand.
do i need to insert records first.
--

Frank
PHPmySQL1@yahoo.com
"Frankly" <PHPmySQL1@yahoo.com> wrote in message
news:giFlg.2571$DI2.1722@trnddc05...
>
>
>> table managementbuildingrelation
>> managementid buildingid [managementid+buildingid=primary key]
>>
>> M001 B002
>> M002 B001
>> M001 B003
>
> CREATE TABLE 'RelationManagementsBuildings (
> ManID int not null,
> BuildingID int not null,
> primary key (ManID,BuildingID))
>
> that was actually the first time i typed something like that.
>
> from what I understand this would create the table I need but for the life
> of me i can not figure out
> how to do it in the MySQL Administrator.
> i am begining to wonder if i am better off droping this admin tool lol.
> i can easily creat 2 primary keys once the table is made
> this is hard
>

[Back to original message]