[Solved] Base Table Relationship

Creating tables and queries
Post Reply
User avatar
ceollar
Posts: 25
Joined: Thu Apr 12, 2012 6:27 pm

[Solved] Base Table Relationship

Post by ceollar »

Got this error message " Primary or unique constraint required on main table"
Any clue what it means?
Last edited by ceollar on Mon May 07, 2012 8:45 pm, edited 1 time in total.
Apache Open Office 3.4.0, Libre Office 3.4.4, Ubuntu 12.04 WinXP Pro SP3
User avatar
RoryOF
Moderator
Posts: 34570
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Base Table Relationship

Post by RoryOF »

It needs a Primary Key, but as I don't do databases (no need) I can't tell you how to set that up.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
ceollar
Posts: 25
Joined: Thu Apr 12, 2012 6:27 pm

Re: Base Table Relationship

Post by ceollar »

I have a primary key in both tables

sent a copy of the file
Attachments
mission.odb
simple relationship between tables
(4.37 KiB) Downloaded 162 times
Apache Open Office 3.4.0, Libre Office 3.4.4, Ubuntu 12.04 WinXP Pro SP3
FJCC
Moderator
Posts: 9231
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: [Solved] Base Table Relationship

Post by FJCC »

What were you doing that raised the error?
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Post Reply