Select in one portal, show in another...

[ulna]

Hi all

I have a order table & a order_row table.

In the order layout I have a tabbed interface with 4 tabs. Articles are added to the order_row table via a portal in the second tab. The information in the order_row tab are huge on each article added, so I can only show one article at a time, to see next article I have to scroll down in the portal. This makes it difficuld to get "the big picture" since I can't see all the articles. So, I made a second portal to order_row beside the tabs and only show the articlenumber for each article on the order. That way I get a good overview of all the articles.

Problem: Is there a way for me to click the articlenumber in the second portal to show that articles full info in the first portal?

The customer is using FM8.

Any suggestions?

Regards

/U

[John Mark Osborne]

I'm not sure you should be using two portals. Sounds like you should have one portal displaying the article number or name. Then, you can place a script inside the portal using the Go to Related Record script step to locate the correct article and show it on a layout showing records from the order table.

[ulna]

Hi all, just want to share my solution to this problem.

First a recap if my first explanation of my problem was unclear...

I have two portals in the same layout into the same related table. In one portal there are so much info that only one record could be displayed at a time (the big portal). So I came up with the idea to have a second portal (the small portal) that only show the article number of the articles in the big portal. In the small portal I can see 30+ rows so I get a better overview of whats in the big portal.

I sorted both portals in the same way, so the first record and so on will be the same in both portals.

Then I added a button over the field in the small portal, made a script with the following instructions (rough translation from Swedish, but I hope you get the picture...):

Set field (TABLE::field; Get(portalRowNumber))

Go to object (Object:BigPortal)

Go to portalrow(no dialog;Table::field)

Table::field is a global field in the layout where I view the portals.

I don't know if this is making any sense since I'm using the Swedish version of FM so the translation of scriptsteps probably sucks, but I hope it can help if someone have the same problems...

This only work in 8.5 of course...

Edited October 11, 2006 by Guest

[Andreas T.]

Hi.

I could not get this to work, my "Big portal" will not accept portal rows number larger than 1 since it is ony set up to display only one row.

So my "Big portal" only displays the first row.

How did you get it to work?

Cheers,

Andreas

[ulna]

Hi

Hi

I guess you're trying to set the portal as a button to start the script. For some reason I've never been able to do that, I don't think it's possible.

Just draw a square over the fields in in the first row in the portal and make it a button that you connect the script to.

Regards

/U

[Andreas T.]

Hello again and thank you for your swift reponse.

I have a small icon that serves as the button and the script picks up the portal number correctly. I am using a variable to store it in.

The problem is that I can not set the portal row number to anything larger than 1 on the Big portal, as it is only 1 row high.

BTW, I am using this as a details view for a Contact from the contact portal in a Customer layout.

First Tab holds a portal with up to 8 contacts, the next tab holds details on the clicked contact.

At least thats what I'm trying to do.

Cheers,

Andreas

[ulna]

Hi again

Now that your'e mention it, I tried that to and could not get it to work.

Since my "big portal" are a list of articles in a orderlayout, it made more sense to have them in a list with a scrollbar to the right. So for me it works anyway.

Sorry I can't help...

/U

[Andreas T.]

Hello.

You helped me plenty :

Actually your last message about using a scroll bar made it click.

Enabling the scrollbar also makes the goto portalrow function.

Now, with an invisible scrollbar it works as I wanted.

Thanks a lot.

Cheers,

Andreas

[Jim Turner]

Hi Ulna

I was having a similar problem getting two Portals showing the same data to synchronise and I followed your scripting and it solved my problem. Thanks!. However, this works fine when I am in filemaker, but when I open my database via IWP the portals do not operate as in filemaker...very annoying!! I've checked the script steps and they are all web compatible.

Do you have any solutions to this problem?

many thanks

Jim

[ulna]

No sorry, I haven't worked much with IWP so I can't help you.

Anyone else?

Regards

/U