Manolocs

One of the problems is: I have 6 tables and 6 Layouts, each one has one Total field selected as Summary from many calculations. Each table has a ID serial number that I used to make the relationship between all tables (don't know if it is correct). In the Main Layout I need the total of the field Summary of all tables. I don't know how to list and how to SUM the fields Summary from 4 of this tables. :hmm:

Great, works like a charm... Thanks :)

Thanks Steven and Vaughan.

Sorry efen, The profile is updated now How can I send to you a FM 11 version of my file?

Hi Bcooney, Thanks for your help, already solved in Chat :)

Hi, I see there was some interest in my post, some downloads but no replies, anybody has some ideas to help me? Cheers.

Hi Lee, Here is my file please take a look to see what is wrong. Cheers Stock Journal.fmp12.zip

Hi, I have 7 layouts and 7 tables in every one I have a ID auto-enter serial number selected. In my understanding it should generates one sequential number every time the new record button is pressed, saving that number to the related record. The number is always incremented by one as it should be, but the problem is: In all layouts the numbers are the same and the last number is set for all of the ID's records in all of the layouts, If I check the table view all records have the same number too, incremented by one if new record is pressed. I have for test only 10 records, all set to ID's 10. Thanks in advance :)

Hello, Just started to use FM, built a simple database, with 6 layouts my question is: Is there a way to lock all fields but one in a layout to avoid changing data? I was thinking in a Radio button or a check box to lock/unlock the layout. I found a topic by Mr Steven H. Blackwell, that seems to be easy task but I could no perform at previlege level I would like step by step if I am not asking too much. Cheers,

Hi, I need a Black or White choice, only one can be selected. They are in the same Layout but not in the same field. Black is in the left side of the Layout and White is in the right side. I tried using Radio Button but could not figure out how to separate the two choices from the same field. In Check box I don't know how to make only one of the two fields be selected. Cheers.