[Solved] Relationship between tables error

[topan]

I've been trying to establish a relationship between two tables based on alphanumeric ID numbers [e.g i203 or jf(307)] that are set as text[VARCHAR] in their tables. The first table has unique ID alphanumeric ID numbers, and the other table has these IDs and associated sample dates/values.

Table1 holds:
ID (primary Key)
IDNumber
Group
Age
BirthDate

The other holds
Key (Primary Key)
IDNumber
Sample Date
SampleValue

I dragged/dropped data from Calc spreadsheets into Base to import them, and I've alternately tried letting Base create a primary key or creating one myself. Everything seems to be okay in the tables, but I'm trying to create a 1:many relationship between the two and I keep getting the error:

"Primary or Unique Constraint required on main table"

I've looked through some past posts and I can't figure out what's going wrong (but I'm new with Base). Any advice would be appreciated.

Thanks--
Teague

[keme]

A relationship in Base can be one-to-one or one-to-many. This means that at least one of the tables needs the joined fields to have a constraint to ensure it's unique within the table. Furthermore, I believe the only constraint that satisfies Base is to make the field a primary key. (Haven't tested that lately, though.)

If your "other" table will only have one record with each particular IDNumber, drop the "Key" field from that table and make field "IDNumber" the primary key. That should allow relationships.

[topan]

Thanks Keme. Completely sorted it out -- it seems that I did everything but delete the old primary key field when changing over to the unique IDNumber.