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.
ID (primary Key)
The other holds
Key (Primary Key)
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.
Last edited by topan
on Fri Jul 23, 2010 5:02 am, edited 1 time in total.
OpenOffice 3.2.1 on MacOS 10.6