tomislaw

I have a huge problem that I try to solve last 2 days. I just can't se any the solution. Maybe is there a trivial solution but I can't se it. I have 4 tables: Overlands Calculations Income Outcome Overlands is the main Table, and it can have multiple calculations, and each calculation can have multiple incomes and outcomes. The Calculation table has, for now, just 3 relevant fields. Cars, People, Earning. The Income and outcome tables have bit more relevant fields. 1) "Price with Tax" (is calculation of fields Price & Tax) 2) Grand Total price is a calculation from fields "Price with Tax" (that can be "by car", "by people", or "fixed" amount) x number of Cars or People or 1 (when fixed), depending on the price attribute from the income or outcome table. Each table has o Summary field of " Grand total price" The tables "Calculations" "Income" and "Outcome" are on the ovelrands Layout as portals. What is the problem? If I set the number of cars or people in the Calculation table, the numbers in the Income and (or) outcome tables are sometimes updated, and sometime not. And that is the strange thing. It sometime works, sometimes not. Any help is appreciated. P.S. Before entering Cars or People in the calculation, the "Select" button must be pressed to make the record active. I cleaned up the file from not necessary tables, scripts and fields. Overland cleaned up.fmp12

Hi, I did make join tables (repeating customers). I used the join tables just to make a relation so i can make reports based on various criteria, but all fields are populated by Lookup values or scripts to avoid data changes in the "Overland table" if, let say, a customer change the address, phone etc. Again, thnx very much, you helped me a lot.

Thnx, I never did think in this way. I will give it a try. I am on the beginning, so I have nothing to mess up 😁

Just one person from a car is the client, I do not employ drivers, but i ned (at least I think so) the person count and person separation because i charge by car for guiding, and per person because there are cost by person, let say, meals, and every person can take a meal of different price. Clients come with they own cars I didn’t think about it at all. But of course, it is possible. For example, that one company sends its employees to team building. And in that case, the company will pay the full amount, for all vehicles and all participants. But either way, names of all participants, not just their number, are mandatory because of the law.

Hi, thnx for spending your time on my problems. I just started my small (one man band) business for Off road travels (guiding). I run my it on the spreadsheet, but this will not meet my needs in long term run because lack of structure. In the former company where i worked, as a long time filemaker solution user, I got a copy of filemaker (18) when i was leaving the company. So I am now in the learning phase and I try to make a solution for my needs. Also, the main idea is to build an app for my Off Road travel company. Because I charge per car and people in the car, I need to be able to put so many people in to the car as needed. Because I work with people, and not with cars, I decided that my "main table" should be the "people" table, and not the "cars" table. And in the car is always at least one person, the driver. When I make trips (overlands), I add drivers from the Address Book (people table) and when necessary codrivers. My workflow idea is: 1 enter people in the address book 2 make an overland 3 put people from the address book (grouped by cars) in to the overland 4 in the "overland" layout, select an driver (customer) and make the invoice for him of course, I am just on the beginning with the developing (and a newbie), there will be a lot to do in the future. At first, make an income/outcome table so I can make invoices, reports per clients (drivers), per overlands etc. But at first, my wish is to make the structure right, and after this, I can play wit the details and features. Also, thanks again, even for reading about my problems and for helping... if you ever come to Croatia, i owe you at least a (lot of) beer.

The fields are left from the "experimenting" with the solution. Actual it would be ideal if the Portal, with just one portal on the Layout, can display the driver and co drivers (if are any). Maybe is the right way to go with repetition fields in the "Drivers table", where the first repetition represent the driver, and other repetitions the co drivers. Because I have intention to get further with this and implement income/outcome invoices that are related to participants (drivers and co drivers) and overlands. However, at this moment I have thousand questions and just few answers in my head. Thnx a lot for your explanation.

Hi, first at all, I am a beginner. I am sure the problem is trivial, but after yesterday night, my brain is dead. I have just 2 "core" Tables, "People" and "Overlands". 1. occurrences of the People Table is "Drivers" 2. occurrences of the People Table is "Codrivers" I connect these 2 Tables called "Drivers" and "Codrivers" via join tables to a third "aggregate" Table called "Cars". The Cars table is connected to the "Overlands" Table. When I make a Portal in the "Overlands" Table that display the values from the "Cars" table, and put Fields from Drivers, Codrivers and Cars table, everything is OK, except that I can't show more than 1 Codriver in the Portal. When i put Portals that display values from the Drivers Table, and put fields from Drivers table and Cars table, all records show the same Car. The same thing is when I make a Portal that show the "Codriver" values, and put fields from Codriver and Cars tables, all Codrivers are related to the same car. What I am missing? My brain is melted down. The File for download the username is the default Filemaker username (Admin) without password. Thnx for any advice.

Thanks for the suggestion. I didn't know where to post because this is both, and a relationship and an value list depending.

Also, it is a app for a print house. In the table A i must make calculations for the print cost. In the table B i have papers. 15-20 paper manufacturer. Every manufacturer has a couple kind of papers, and the papers have various weights. Its should bee possible, in table A field 1, to choose all of the manufacturer. Then in field 2 (table A) should be possible only to choose papers that are provided by chosen manufacturer in field 1 that display values from records in table B. In field 3 (table A) should be listed only the paper weights for chosen paper manufacturers and chosen papers from records in table B. When all fields are matched, then are tables A and B related, so that i can pick other needed data from table B . It will bee nice when its possible to permit changing records in table B using the value-lists in the table A. And all this twice. One time for the paper that is used for the booklet, and second time for the paper that is used for the cover. All off this is not a problem to make via multiple relationships (self-joins) between table occurrences if it was just in one table. But with 2 tables, i have no idea. P.S. Sorry form my bad english.

Thanks for quick replay. But this, what veteran posts, is not what i need. Also, it is a app for a print house. In the table A i must to make calculations for the print cost. In the table B i have papers. 15-20 paper manufacturer. Every manufacturer has a couple kind of papers, and the papers have various weights. Its should bee possible, in table A field 1, to choose all of the manufacturer. Then in field 2 (table A) should be possible only to choose papers that are provided by chosen manufacturer. In field 3 (table A) should be listed only the paper weights for chosen paper manufacturers and chosen papers. And all this twice. One time for the paper that is used for the booklet, and second time for the paper that is used for the cover. All off this is not a problem to make via multiple relationships between table occurrences if it was just in one table. But with 2 tables, i have no idea.

I have 2 tables. Table A with a relationship to table B. In the table A should be possible to chose values from field 1 in table B. So long so good. Now, i should bee able to chose, in table A, values from field 2 in table B. But only values that are related to values in field 1. In the same way i should bee able to choose values in table A from table B, from field 3, but only values that are related to field 1 and 2. Table B. Also, in field 1 a have manufacturers, in field 2 i have products lines, and in field 3 i have products. When I choose some manufacturer, in the second field should be visible (possible to choose) only product lines from this manufacturer, and in field 3 should be visible (possible to choose) only products from this product line. This should be not a problem to handle in the table B , but I need this in table As an relationship that is only related to this specific product so that i can pick some other data (fields) from this record in table B to table A. And its should be 2 times. The record in table A has always 2 records from table B. Any idea? P.S. Sorry for my bad english language. I hope someone had understand what is on my mind. -)