angbrav

I tried your solution and it works! thank very much!

Sorry, I don't know how to create that relationship.. I already have a relationship between them using the ClientID but I don't know how to add the year os the bill in that relationship. Would you mind being more specific?

After 56 views and no reply, I guess what I'm trying to do is not possible... Could does anyone tell me if I should discard this idea?

Hi everyone! Firstly, I'd like to clarify that I'm not sure if this post fits in this section. If not, feel free to reallocated! Secondly, I'm going to present my problem: - My DB. I have a table of Clients. This table is linked to a Bills table in a 1...n relationship using the clientID. I am storing when the bill was generated. - I'm trying to generate a report which shows a top 10 of clients for a given year. The clients should be sorted for the amount of money they spent. That amount would be generated as the sum of client's bills for the year chosen. My main problem is how to sum the bills of a client for a given year. Thank you in advance, Manuel

I have done what you told me. One problem has shown up! I am placing the fields from bill in the leading sub-summary part. When I go to "preview mode" the entire part disappears.. so the fields, which I want to print, don't appear any more. Is there option to set the sub-summary part printable? Thank you

As usual you solved my problem! Thank you very very much!

Hi everyone! I've been reading lots of post about printing a portal.. but I didn't find a solution which could solve my problem. The problem is the following: I have a table in my DB which is storing bills. Each bill is composed by products. Products are represented in a different table. Both tables are linked by billID. In the layout which is going to be printable, It has a header and a footer where I am placing all the stuff I want to be replicated in every page. Plus, I have a body part which is just composed by the products which are composing the bill. Right now, I am using a portal to place those products. My problem, which I guess is a common problem: I don't know if one page of products is going to be enough so I would like to dynamically generate more pages in case they are needed. Thank in advance. I hope I clearly expressed myself. Manuel

ohh yeah!! It works!!! Thank youuuu

Hi everyone! I am trying to do something which I think it should be quite easy to implement. I have a layout (called Projects) from which I create new Budgets, which it is a different layout and table. Both tables are linked by a field in the DB. Therefore, what I am trying to do is a script which goes from Projects to the other layout and create a new record. My problem is the following; I need to link both tables inserting the value of the field id of Projects table to the field projectID of Budgets table. I am getting an error because the field projectID is not in the Budgets layout. What I am trying... set Variable [$code;Projects::Code] goTo Layout [budgets] new Record/Request Insert Calculated Result [budgets::projectID;$code] --> At this point, I am getting error number 102 (Field is missing) I know I could solve it including the field in the layout, but I am sure there is an elegant way to do it! I hope I have clearly express myself. Thank you in advance!

Thank you so much!! Both replies have been really useful!!!

Hi! This is my first post, I'll try not to bother u with stupid questions! (I hope this is the place for this question) I m developing my very first FM application! It s going quite slow but I m making some progress. My question is the following: I m hiding status bar so I have no way to navigate between layers. Therefore, I m decided to create my own navigator menu (kind of custom menu). 1) I would like to make it dynamic (just in case I need to add a new layer). For this purpose, I m quite sure I have to create my menu using the DB, so that, I'd be able to modify the menu by adding a new record in my table. (Please, correct me If I am wrong). 2) I'm trying to make a two levels menu. I have no idea how to solve this problem. For instance: Initial state... Menu 1 Menu 2 Menu 3 After clicking Menu 2... Menu 1 Menu 2 Submenu 1 Submenu 2 Menu 3 I know it's possible because I saw it in one FM app. 3) Do I need to copy the menu to all the layers or I could create the menu in a specific part of the layer (such as head) and it will automatically copied to all the layers. I know this is not the default behavior, but I expect that perhaps there is a way to do it! Of course I'm not expecting to get how to implement all this stuff. I just need to know if I'm right in what I'm thinking. (Hints are more than welcome) Thats all! I know it is a huge question. Thank u in advance.