Relationship in a Relationship

[nightdesigns]

I'm trying to figure out how to do this one, but i'm stumped ...

This is for a list of graphics for a news show.

The main file, holds the "story title" which then has a related list of the associated graphics. The "graphic name" field is where the persons name goes in. I have another DB of "graphic names" and "graphic titles".

How can i get the title to automatically pop into the title field, but also still have the ability to edit it. Currently i have a calc field that let's me show the title, but no way to edit it from that screen.

Thanks.

[jeffer]

In fact it's quite simple...so here is the catch!

In your graphics database you must have a record for each graphic. Make two fields in that database. One for the title and one for the graphic (container type field). In your main file you build a relationship from the story title to the title field in the graphics database. Now make an extra container field in your main database and set it to lookup the graphic in your graphic database trough the new relationship. If you want to edit the relatied graphic...copy the graphic field from the graphic database and paste it in your main file. Double click on it and select the new relationship. Choose the graphic field from that relationship and you can edit it. Note that a calculationfield cannot be edited!

I hope that this anwer your question!

jeff

[nightdesigns]

Hey Jeff, Unfortunatly, i'm still confused.

In your graphics database you must have a record for each graphic. Make two fields in that database. One for the title and one for the graphic (container type field).

Done, i actually have a name and a title both as text, not sure the purpose of the contanier field (or should this be a 3rd field in my case)

In your main file you build a relationship from the story title to the title field in the graphics database.

Already there.

Now make an extra container field in your main database and set it to lookup the graphic in your graphic database trough the new relationship.

I did somethign similiar like this, looked up a calced value.

If you want to edit the relatied graphic...copy the graphic field from the graphic database and paste it in your main file. Double click on it and select the new relationship. Choose the graphic field from that relationship and you can edit it. Note that a calculationfield cannot be edited!

This takes extra work, i just want to be able click on it in the portal. Other ideas?

Thanks

-j

[slstrother]

OK, I'll give it a shot.

Here is how I understand the problem. You have a main db with a portal, in the portal you have text fields "graphic names" and "graphic titles" from the related db. The "graphic titles" field is a calc field and you want the ability to edit this field in the portal.

In the related db create a text field called "edit_title". Add a condition to your calc along the lines of

If(isEmpty(edit_title), OriginalResult,edit_title)

This may not be the calc you need, you did not post the calc you are using. But, hopefully you get the idea.

In the main db, add the "edit_title" field to the portal, make it the same size as the "graphic titles" field and place it behind the "graphic titles" field. Change the background of the "graphic titles" field to opaque and set to not allow entry.

So, when you click on the "graphic titles" field in the portal, your cursor will be in the "edit_title" field. Where you can enter another value which will show in the "graphic titles" field upon exit.

Hope this helps

[nightdesigns]

You were close. The calc field just copies the field from one to another, no adjustments. I tried your "If(isEmpty(edit_title), OriginalResult,edit_title)" but it's a loop and it won't let me.

I'm too tired to explain more right now, but here's the files if you wish to take a look at http://www.jmen.com/Stories.zip

Thanks

-j

[slstrother]

I have made the changes to your files I suggested above and attached it to this post.

Stories.zip

[nightdesigns]

Thanks for the changes. Unfortunatly i also want it to change the info in the related file as well. E-mail me directly at [email protected] to discuss in furthur detail.

-j