[Solved] Base Table Relationship

Creating tables and queries

[Solved] Base Table Relationship

Postby ceollar » Mon May 07, 2012 7:15 pm

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
ceollar
 
Posts: 25
Joined: Thu Apr 12, 2012 6:27 pm

Re: Base Table Relationship

Postby RoryOF » Mon May 07, 2012 7:27 pm

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.0.1 on Xubuntu 14.04 and Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 14377
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Base Table Relationship

Postby ceollar » Mon May 07, 2012 7:42 pm

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 87 times
Apache Open Office 3.4.0, Libre Office 3.4.4, Ubuntu 12.04 WinXP Pro SP3
User avatar
ceollar
 
Posts: 25
Joined: Thu Apr 12, 2012 6:27 pm

Re: [Solved] Base Table Relationship

Postby FJCC » Tue May 08, 2012 3:41 am

What were you doing that raised the error?
AOO 3.4 or 4.0 on MS Windows XP ( before 2013-08-03) or Windows 7
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 3686
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA


Return to Tables & Queries

Who is online

Users browsing this forum: Google [Bot] and 5 guests