Neooffice 2.0 Database Relationships

[FredBlogs]

When I try making a relationship between two databases i get the following error:
Error while connecting to the data source

Primary or unique constraint required on main table: "Bacchus wine club customers" in statement [ALTER TABLE "Collections" ADD FORIEGN KEY ("Type") REFERENCES "Bacchus Wine Club Customers" ("Item")]

I checked the neoOffice help files the closest thing i can find help on adding a foreign key is the primary key topic

Any help would be appreciated

[valterb]

Well, it seems that you haven't create a primary key in your tables. Try to create it (I think you need a primary keys in both tables), and have a look at what happen.

To do that go in table design mode (select your table, ctrl-click and choose edit). On the left of the table choose one of the row that contains unique data (for this reason is possible that you have created an ID field) and ctrl-click on it. Choose primary key. Save your table and go to create the relationship.

Valter

[amayze]

For a quick (and rough) guide to setting up tables with relationships take a look at this post.

Andy.

[FredBlogs]

both tables have primary keys and it still keeps giving me the error

[valterb]

So if the problem is not primary key is "unique constraint".
Try to do this. Go to Tool -> SQL.
Than type a command to add a constraint. The command should be something like