Ask Your Question

Some Base relationships not saved [closed]

asked 2017-09-05 00:05:34 +0200

Spun69 gravatar image

updated 2017-09-05 13:57:09 +0200

I am new to LO environment, and notice that after some relationships between tables are created, additional links are not saved thereafter. There is no error message when this happens, it is just that the link is not displayed the next time the relationship window is opened. I have three 1:n links installed successfully now, but no more can be installed after that. Is this a Base constraint, or more likely a bug?

I installed the latest version of LO [v5.3.5.2 (x64)] and using Base with integrated Access2Base (v1.6) for an application.

Below are two screenshots: one post install of three 1:1 links, and then after save & reopen relationships window.

C:\fakepath\PostInstall.png C:\fakepath\PostReOpen.png

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Spun69
close date 2018-01-23 14:37:14.874655

2 Answers

Sort by » oldest newest most voted

answered 2017-09-05 00:43:53 +0200

Ratslinger gravatar image

There is no limit on links. You can see some examples in the docs - Chapter 3 Tables (especially page #7) found here.

Have not experienced that since starting LO with v4.2.x.

Are the links visible when you save the Relationships?

edit flag offensive delete link more


Yes, links seem to be installed correctly, and save operation appears to complete successfully. But reopen window and they are absent. Can reinstall, but they are lost when relationships window closed.

Spun69 gravatar imageSpun69 ( 2017-09-05 02:21:09 +0200 )edit

Can you post a sample? Please no personal/confidential information. Have raised your Karma to permit edit of question & append file.

Ratslinger gravatar imageRatslinger ( 2017-09-05 02:30:28 +0200 )edit

I added a couple screenshots to the original post.

Spun69 gravatar imageSpun69 ( 2017-09-05 13:57:49 +0200 )edit

The problem is that your relation is actually never established. Your first screenshot shows this. At either end of the link there is no 1 or n. This is because neither field is unique. Initials in the Employee table can be duplicated as well as in Camping table. It would be better to change the Employee table so the Primary key is only the ID & use that to link to the other tables.

Ratslinger gravatar imageRatslinger ( 2017-09-05 15:58:10 +0200 )edit

I would imagine SMSGateway or Network is also not set as unique so again no relation established. If looking for many-to-many relations you need to set up intermediary table (found in Chapter 3 of the referred to documentation).

As far as generating some type of error, you can file a Bug report here.

Ratslinger gravatar imageRatslinger ( 2017-09-05 15:59:45 +0200 )edit

Thank you for the comments! I was able to fix the SMSGateway link by deleting the ID column, and making the Network column the primary key. Now the 1:n relation shows up and is saved as expected. I need to work on the other link, but it is a similar issue I believe. I consider this question closed.

Spun69 gravatar imageSpun69 ( 2017-09-05 18:42:18 +0200 )edit

You don't always need to change a key. You can always make a field 'unique' and use that.

See this post to set unique.

Ratslinger gravatar imageRatslinger ( 2017-09-05 18:47:09 +0200 )edit

answered 2017-09-05 13:43:34 +0200

peterwt gravatar image

Why not try deleting the three links that work then create the links that did not work when those three links were there. Do these links hold? If they don't it suggests there is something wrong in these links. If they hold add the original links.

edit flag offensive delete link more


Good suggestion. I deleted all links, and then tried to install one of the problematic 1:1 links. The save operation seemed fine but on reopen, link was gone. So same bad behavior, and no error message. Even if there is something wrong with the link (which is not apparent to me), there should be an indication of this to the user.

Spun69 gravatar imageSpun69 ( 2017-09-05 14:05:04 +0200 )edit

Question Tools

1 follower


Asked: 2017-09-05 00:05:34 +0200

Seen: 128 times

Last updated: Sep 05 '17