MSDE create a relationship error on pc.

I am just getting started with an address table which contains an identity field called ADDRESS_SID. This table will contains all the addresses for persons, businesses, and other objects. I created another table called ADDRESS_LINKS which has four fields:

ADDRESS_LINK_SID 'The identity field for the table
ADDRESS_LINK_TYPE_SID 'A foreign key field to ADDRESS_LINK_TYPES table
ADDRESS_OBJ_SID 'The foreign key to the PERSONS table
ADDRESS_SID 'The foreign key to the ADDESSES table

The ADDRESS_LINKS_TYPES table has two fields:

ADDRESS_LINK_TYPE_SID 'The identity field
ADDRESSLINK_TYPE_NAME 'The text name such as PERSON or BUSINESS

I, therefore, am trying to create a relationship in the ADDRESS_LINKS table to
the ADDRESS_LINKS_TYPES table with the ADDRESS_LINK_TYPE_SID field
in each table but the error message says there is no unique field in the ADDRESS_LINKS_TYPES table.

I get the same error when I try to create a relationship to the ADDRESS table.
Could it be that the desktop version does not allow relationships? Thanks for your help and hope you are having a good holiday season.

I am using the server view in Visual Studio .Net 2003. I am writing a C# program and simultaneously using VS to create the tables and relationships.

Yes. The table designs look good. I can add data via the Visual Studio table data views and I can see the primary key symbol next to the identity columns in design view. When I right mouse click over the table in design view, I get the form with the relationships, constraints, etc. When I select the Relationships tab and I select the the tables and columns to join, I get the error message as soon as I try to change the name of the relationship or try to save.

I found my own mistake. I had the tables reversed in the relationships dialog form. Thanks for the help anyway.