stan111

Bravo! It works like a charm!

Thanks! But I wasn't able to find a solution! The question is still open. Thanks everybody!

Gentlemen, I have two value lists: Category and Subcategory. Category contains the following: Food, Drinks. Subcategory contains: Chips, Soda, Juice. How can I do the following thing: when choosing Food, I want Chips field only be available for selection (no drinks displayed). And vise versa. Thanks!

Thanks a bunch!

that's fine. Let's go that way: 1. I have a Price and Item. I need to find Total. Formula will be: Price * Item 2. I have Price, Item and different Sellers. Formula will be: Price(of the specific seller)* Item How can I realize this case in FM?

I've got a trouble, trying to incorporate additional field into calculations at Transactions tab. I used CASE function in the formula. The trick with lookup prices doesn't work now. Would you please help me out with that?

how can I accomplish that trick, mr.Comment?

how can I set duplicate's initial row to 6? don't really understand I'm not able to edit portal parameters as I am not using a referenced table. If I duplicate "Products table", than those parameters become active and I can set initial row to 6. But, the portal displays only one record and I don't know why.

Thank you, mr. comment! I created a portal and assigned a button to a portal record with the script attached "Go to related record". Works fine! Is it possible to have portal records rearranged and shown not as a row, but as a cage?

Hi, I created a dashboard with a bunch of buttons, attached script to every button, which allows me navigating to specific record of the Products table. Basically, every script is the same, with minor changes (only record ID field changes). The process of creating a script to every button is a very time consuming as I need to write a script that a) goes to layout b)finds the certain record 1 "Step: Go to Layout Layout: Products  2 Step: Perform Find" Is there a way to simplify the task? Thanks!

Hi Comment, I created a dashboard with a bunch of buttons, attached script to every button, which allows me navigating to specific record of the Products table. The process of creating a script to every button is a very time consuming as I need to write a script that a) goes to layout b)finds the certain record 1 "Step: Go to Layout Layout: Products 2 Step: Perform Find" Is there a way to simplify the task? Thanks!

you are the man! Thank you!😀

Thanks, unfortunately it doesn't work for me

Comment, I wasn't successful in performing your recommendations. Is it possible to check my file? Thanks. Untitled Copy.fmp12

Hi, thanks for the fast reply. Hmm...I am new user to FM, the solution sounds really confusing at the moment, but I'll try.