How do I accomplish the following...(screencap incl.)

[ViciousTruth]

Here is a screen cap related to my question:

The Alphabet buttons are scripted to set a field to their respective character (ie. the A button sets "A"). When a button is clicked, it sets a field called CustomerJoin to its respective letter.

In my Customers table, I have a field calculation that determines the first letter of Customer Last Name.

I have a relationship set up between my customers table and this user interface table: Customer Last Name = CustomerJoin

The end result is: when I click on a letter, my portal shows me a list of all the customers in my table whose last name start with that letter.

Here's the problem: I want to start the portal out showing a full list of all the customer records in the Customer table. I am also thinking I will add another button (after the "Z" button) called "ALL".

How can I accomplish this? If there is a way to do it with my relationship, than I want to implement it that way.

Thank you in advance!

[kiwiora]

have another value for your global field (customerjoin?) that when clicked inserts "all" (i.e instead of "a" or "b" etc it's "all")

In your field which determines the first letter of the customer's last name, enter left(name;1) &"¶all"

If you want it to default everytime you go to the list layout, just change the "go to layout" or how ever you're navigating to this screen to a script which is "go to layout" + setfield customerjoin =all and then commit records.

[ViciousTruth]

kiwiora:

this works! Thank you!

so can you explain to me the concept behind it? by adding that & (PAll) what did we do?

[kiwiora]

In laymens terms, by putting the ¶ you've inserted a line break. The relationship is then able to evaluate based on either line. Kind of an "or" relationship.

[ViciousTruth]

I am designing my first solution to use the separation model and I've hit a wall.

I have two files: Data.fp7 and GUI.fp7

In the Data file, I have a table called Customer.

In my GUI file, I have designed a layout I want to be the interface for the system. See attached pic.

In the Customer menu, you can see I have a rolodex-style function that shows a list of all the customer records.

I want to be able to click on a customer portal row and have it show me that customer's information in the main portion of the layout. In the past, I would do this using GoToRelatedRecord.

However, when I attempted this, I get an error saying "Operation could not be completed because this layout cannot display the result."

Do I need to change the Show Data From: option in Layout Setup...? or...?

Any help is greatly appreciated!

[Sergeant Ron]

That error tells me that the field that you clicking on fpr the GTRR button are not assigned to the same location. Double check your relationship and the field that you are clicking on to to ensure that they are consistant to the GTRR command.

hope that helps....

Ron

[Lee Smith]

Please do not double post your questions.

[bcooney]

How about setting a global to the customer's ID when you click the portal row? Then, the fields on the right would use a relationship gCustID to Customer::ID.