Related records

[alessio c]

Hi,

I don't know if you guys have read my previous email.

I am having problem in using the related records object. I have enabled the editing and the automatic creation of records, but if I create a record in the portal it doesn't automatically create the related foreign key.

Are there any advices on how to use the portal in Glom? Because in Filemaker I was using it without problems, I guess it's only a different approach that I still don't know well.

Please, some help, it's a stupid question, but there is no documentation on it!

Alessio.
_______________________________________________
glom-devel-list mailing list
glom-devel-list@...
http://mail.gnome.org/mailman/listinfo/glom-devel-list

[alessio c]

I keep receiving this error:

ERROR:  duplicate key value violates unique constraint "ComanyID_key"

But my relationship are the same of the project example.

Alessio

2009/9/29 alessio c <viandante68@...>

Hi,

I don't know if you guys have read my previous email.

I am having problem in using the related records object. I have enabled the editing and the automatic creation of records, but if I create a record in the portal it doesn't automatically create the related foreign key.

Are there any advices on how to use the portal in Glom? Because in Filemaker I was using it without problems, I guess it's only a different approach that I still don't know well.

Please, some help, it's a stupid question, but there is no documentation on it!

Alessio.

_______________________________________________
glom-devel-list mailing list
glom-devel-list@...
http://mail.gnome.org/mailman/listinfo/glom-devel-list

[Murray Cumming]

On Tue, 2009-09-29 at 09:51 +0200, alessio c wrote:
> I keep receiving this error:
>
> ERROR:  duplicate key value violates unique constraint "ComanyID_key"
>
> But my relationship are the same of the project example.

I suspect that your relationship doesn't make sense somehow. For
instance, maybe you are trying to use the related table's primary key as
a to key from the first table. Glom would then be trying to set the
related table's primary key to match the from field in the parent table.

We should probably try to prevent you from doing this.

I could check if you can send me the .glom file.

>
> Alessio
>
> 2009/9/29 alessio c <viandante68@...>
>         Hi,
>        
>         I don't know if you guys have read my previous email.
>        
>         I am having problem in using the related records object. I
>         have enabled the editing and the automatic creation of
>         records, but if I create a record in the portal it doesn't
>         automatically create the related foreign key.
>        
>         Are there any advices on how to use the portal in Glom?
>         Because in Filemaker I was using it without problems, I guess
>         it's only a different approach that I still don't know well.
>        
>         Please, some help, it's a stupid question, but there is no
>         documentation on it!
>        
>         Alessio.
>
> _______________________________________________
> glom-devel-list mailing list
> glom-devel-list@...
> http://mail.gnome.org/mailman/listinfo/glom-devel-list

--
murrayc@...
www.murrayc.com
www.openismus.com

_______________________________________________
glom-devel-list mailing list
glom-devel-list@...
http://mail.gnome.org/mailman/listinfo/glom-devel-list

[Murray Cumming]

On Tue, 2009-09-29 at 10:58 +0200, Murray Cumming wrote:

> On Tue, 2009-09-29 at 09:51 +0200, alessio c wrote:
> > I keep receiving this error:
> >
> > ERROR:  duplicate key value violates unique constraint "ComanyID_key"
> >
> > But my relationship are the same of the project example.
>
> I suspect that your relationship doesn't make sense somehow. For
> instance, maybe you are trying to use the related table's primary key as
> a to key from the first table. Glom would then be trying to set the
> related table's primary key to match the from field in the parent table.
>
> We should probably try to prevent you from doing this.

I have made a change in the code
http://git.gnome.org/cgit/glom/commit/?id=c291bc2bb0b2bc72ac57e8162f11749f68d45d72
which should make this clearer in future versions of Glom by preventing
you from using a primary key (or unique key) for this.

--
murrayc@...
www.murrayc.com
www.openismus.com

_______________________________________________
glom-devel-list mailing list
glom-devel-list@...
http://mail.gnome.org/mailman/listinfo/glom-devel-list

[Murray Cumming]

On Tue, 2009-09-29 at 13:16 +0200, alessio c wrote:
>
> If you have time, I also would ask if there is the possibility to open
> the related record in a new window. When I click on the folder of the
> portal it takes me to the record of the child table and it is perfect,
> but if I want to go back I should write a script for this.

If you just go back to the table via the Tables menu, then you should be
taken to the record that you were previously looking at.

Also, your related record's details layout probably has an [Open] button
next to the ID that was used in the relationship. This will take you
back to the parent record too. That might not be obvious to every user,
of course.

There is no full navigation history in Glom, though I guess this could
be done if someone wanted to code it. Likewise, at the moment there is
no way to specify that Glom should open tables in new windows.

--
murrayc@...
www.murrayc.com
www.openismus.com

_______________________________________________
glom-devel-list mailing list
glom-devel-list@...
http://mail.gnome.org/mailman/listinfo/glom-devel-list