Iain Peace

Hello, I have a very simple filemaker file in which I have a relationship between a fiscal amount in table 1 and a percentage field in table 2, which produces a result back in table 1. To make this clearer, my fiscal amount is say 500 my percentage is 1% therefore I expect to see a result of 5. This I have three times with the fiscali and percentage amounts being different for all three. To allow for this I have three tables for the percentage calculation. In my results field the calculation reads as amount paid * percentage table::percentage. For the first two fields this works fine, but for the third the result generated is always zero. This is doing my head in as I cannot see for the life of me why this is not working. Please please somebody help me. Many thanks, Iain.

Ahh, yes. Sorry. I think the combination of my thinking about what I actually want to do whilst learning filemaker functionality and trying to develop - and simultaneously work with - a functional solution has proved to be too much for me to do at once. I take it then that my wanting to split the staying period into separate price ranges is a bit of a headache, and I know it is certainly out of my skill range! If we've come to the end of the road, I want to thank you for your help, comment, you've taught me a lot of things which I hadn't really thought about. Kind regards, Iain.

That works perfectly...well nearly. I do have a slight issue which just takes the edge off of it that I hope you can help me with. If a customer makes a reservation that falls over two season time periods, I currently only display a price based upon the arrival date. For example, their arrival date is 25/06/05 and their departure date is 10/07/05. This is one week at the mid season rate and one week at the high season rate. Currently the solution is specifying a price based upon the arrival date from the mid season. Is there a way to resolve this? Thanks again for all your help, Iain.

In actual fact there are three possible items per invoice. The main item being the gite rental and the other two being the payment for renting a television and the payment for using a washing machine. I haven't been too concerned about the later two at this point, more that I want to get the main rental cost side working first. In summarizing the pricing structure, it is fairly simple. We rent dependent on how many people and at what time of the year. This breaks down the pricing into a 12 box table, as demonstrated in the attached file. I hope this helps clarify the pricing and that you can offer me some further guidance. Many thanks, Iain. Pricing.zip

Do you mean the zip file is enmpty or the database? I've tried downloading the zip and it seems ok to me. I don't know what to suggest. The database is intentionally empty. By all means, feel free to add a record.

Sorry I forgot the attachment. Here it is. DB.zip

Hello, Since the last note I have tried to follow your advice and have attempted to re-structure my solution into something which I believe resembles the kind of structure you had mentioned. As a result, things definitely do look and work better, and seem to be more logical, both graphically and practically. I have attached a copy for you to see exactly where I'm at. As you can see, I now have the fields in dedicated tables to reflect their function, and I am using portals to present the data as I wish to see it. You will also see that I have continued with trying to implement the auto-pricing solution which you provided, and it is here that I am experiencing a problem that I can't understand. The problem is that regardless of what date I specify as the arrival date, I always get the same price lookup figure. It's as if it is ignoring the season table. I have tried to follow your solution to see if I can understand what I have missed, but for the life of me I can't seem to find what I am missing. Can you please, please help me. Just for information, I have obviously wiped my db clean as, unfortunately, I am using my solution whilst simultaneously developing it, and therefore certain things might seem somewhat bizarre, i.e. tab order. Please excuse these. Also, some of the fields within the portal have been moved around for presentational reasons. This is only within the reservations table though. Many thanks, Iain.

A stumbling block. Thinking that I have roughly understood the formula and logic - remember, I am EXTREMELY new to Filemaker - I have tried to incorporate your solution into my database. By incorporate, I mean I have basically lifted it into my database. Anyway, for some reason which I am struggling to understand, it does not function the same way as in your solution. I have attached here my current db for you to be able to see for yourself. As I have said, I am new to this so my db is extremely crude in its functionality. Hence the reason why I am trying to improve things. Just for information, I rent gites (holiday homes) in the south of France. This db is intended to modernise the paper processes of the previous management. At the same time, and I don't want to appear cheeky, but if you have any other ideas for streamlining my db, that would also be worth my investigating and learning, I would be greatly appreciative to hear them. Many thanks for all your help. Iain. MyDatabase.zip

Perfection. Thanks a million. I now need to spend some time getting my head around the formula and logic! Thanks again, Iain.

Thanks a million, your file is nearly exactly what I'm after. However, I have something new to throw into the equation which I forgot to mention earlier. My price list also incorporates the number of people that are in the booking party. I have modified your attachment to reflect the actual seasonal dates and the price list dependent on the number of people within a specific season. This file is attached. I don't think that this is going to cause a problem as, as you can see, the season and price list just extend to cover additional people. However, when I have tried to do a test record, I'm not quite getting the correct answer. My first thought is perhaps this is to do with U.S vs. European date formats? I'm not sure. Can you please help? Many thanks, Iain. SeasonLookup.zip

Thanks for your response. The price changing during his/her stay will not come into things at all. I have got a price list table which incorporates a From and To date and a price field. Overall there are five date ranges and three price brackets. The price ranges reflect low season, mid season, high season, mid season again and finally low season again. Therefore the prices reflect low, mid and high season. What I do not understand is how I can tell filemaker that should the arrival date fall within one of these season date ranges, then it should select the relevant price. I'm not sure if I've understood that what you are saying resolves my problem? I truely hope you can help. Thanks, Iain.

Hello all, I am very new to filemaker and am enjoying struggling through my problems with the aid of forums and, I might add, a lot of luck, but I fear that I have come to a wall and am banging my head against it and am therefore looking for help. I have a number of related databases in my design with the main one including three field - Arrival date, departure date and total price. I have another db which includes the price relative to a specific date range. For example 1/5/05 to 01/06/05 = 230