Go to Portal Row - Initial Row 2 or whatever....

[cathyka]

I have a layout where I have created tabs for navigation. The tabs are labeled using a related record.

So basically I have a series of portals with Related Records from Table A.

The first tab is "Initial Row 1" "Number of Rows 1"

Second tab is "Initial Row 2" Number of Rows "1"

and so on. (There are eight total)

The tabs are buttons with a script GTRR for Table A using Layout "Current" to view the various records.

Works like a charm.

I would like to make the tab text bold when the record is being viewed. I thought I could use a Loop and go to Portal Row to complete a script fo this but that won't work... can anyone give me another direction?

Thanks!

[Dan-A]

how about using TextStyleAdd function??

[cathyka]

I am familiar with that function. I just don't know how to direct the script to the correct field in the portal. Since "go to portal row " will not take me there, or will it?

[-Queue-]

Go to Field [relationship::desiredField] puts you in a portal's first row with desiredField selected (assuming that you do not have another instance of the related field on your layout, with a lower tab order than that of the portal's fields). Go to Portal Row [Next] then puts you in the next related record's same field (if any such record exists).

[cathyka]

My challenge is that I have the same text field repeated 8 times.

and the same portal repeated 8 times. Each tab is an Intial Row with only 1 row visible.

So Tab 1 is Initial Row 1 with Number of Rows 1

So Tab 2 is Initial Row 1 with Number of Rows 1

So Tab 3 is Initial Row 1 with Number of Rows 1

So Tab 4 is Initial Row 1 with Number of Rows 1

and so on....

[comment]

Can you attach your file or a reduced version of it? I am unable to follow your description.

[-Queue-]

I am with Comment on this one. Why would you want to have the same field 8 times anyway?

[Dan-A]

If each tab has a button...

How about, at the start of each script you add

a Set field step...

Something like SetField myField to TextStyleAdd( myField; Bold )

I am not sure if that would change the style for all occurances!!??

Maybe worth a test.

Dan

[cathyka]

To address the comment on why.

For efficiency I want to be able to navigate between multiple records in one table related to ONE record in another table. And visually this just works well for me.

I have attached a file. Thanks.

tabs.zip

[-Queue-]

I get it now. Your last post was confusing with the "Initial Row 1 with Number of Rows 1" part repeated.

One way you could do this is to create a global text field and set this global at the begining of your Tab script with tabs 2::IDTab. Then create a calculated text field of

Case( global_id = IDTab; TextStyleAdd( TabName; Bold ); TabName )

and change the field in your portals to be the related tabs 2 calculation field.

You don't need the script parameter, btw.

[comment]

Well, I am sorry I asked, because I am more confused now than before. You know, when you're trying to figure out the best way to achieve something, it helps knowing what the purpose is. The only thing I learned from your file is that you wanna see some stuff.

FWIW, I am attaching a demo that may bear some resemblance to what you're after.

hiliteTab.fp7.zip

[cathyka]

Thank you! That is exactly what I was looking to do.

And to address comment, that really is all I want to do, is see some stuff and record some stuff. But isn't that what a database is supposed to do? Show you information in relationship to other information. What I was trying to achieve was a visual enhancement to my layout design. What may be very obvious to the experienced and talented developer is not even a blip on my radar screen. I apologize if my choice of words or details seemed vague. But I very new to this FM. I am still learning correct terminology and process.

I truly appreciate your help.

c

[comment]

I am happy you got what you wanted.

As an aside, if you ask me how to "show you information in relationship to other information" I can only reply "relate the information and show it".

If OTOH you tell me "we are a bank, we have customers and accounts, withdrawals, deposits, interest charges etc." then it's much easier to grasp the situation and perhaps come up with a suitable solution. Very little to do with Filemaker expertise really.

But obviously this is only my own peculiar shortcoming, as proven by the fact that Queue did "get it".

[-Queue-]

Comment has shortcomings? Pssh! Whatever! And even if you do have shortcomings, you still offered the same solution; so they must be beneficial ones.

I just naturally have my wires crossed or something. It did take a while to understand how the file was set up, due to the portals being located way in the back. But once I got past that, it made a funky sort of sense. Then again, my job usually consists of interpreting the funky 'sense' of others. So...

[cathyka]

What do you mean by portal being located way in the back? Would there be a more effecient way to do it? (Silly question I am sure.)

[-Queue-]

I meant that it took me a while to locate the portals. I saw the related fields easily, but did not know if they were independent or held in a portal and could not easily click on the portals.

There may be a more efficient way to do it, but I have never before done it. So I am unsure. It seems like the easiest way to do it though.

[cathyka]

Thanks Queue...

And on that note I have another question. Lets say my tabs are phone numbers.

Phone numbers are related to Personal or Business related.

I would like the phone numbers that are related to a Business (like Main Office, Customer Service etc...)

to be visible in all the related People Records. But the phone numbers that are Personal ( Like direct LIne, Cell etc.) to only be visible in the Individual Persons Records.

Any suggestions?

Thanks!

[Ugo DI LUCA]

And on that note I have another question.

I cannot see how this may relate to the former question, but why not have a "Private" and "Professional" key so that you can filter out one or the other according to your needs.

[cathyka]

I guess I don't understand how to create a private key. Could you lead me in the right direction?

[-Queue-]

I think we will need to see a sample of what you are describing. I am not seeing how it relates to the previous idea.