### Title

I am struggling with some basic issues

### Post

I have just started using File Maker and am having a hard time, so please bear with me on some very fundamental issues. I have gone thru most of the tutorial and have printed out a lot of the documentation, but it is still not clicking. My database keeps trakck of short-term rental tenants in a vacation apartment

I have a field called "cleaning fee" . I set it up to always be $125. Except, if I stay in the unit, it should be left at 0. I jsut can't get the syntax of the conditional statement in the field definition correct.

am I even close?

Here is what I have tried. The # symbol is being used here as the "not equal to" sign

If (guest name # Janet)=125

thank you in advance.

If there any examples of simple calculated fields posted, I can look at them and figure this out as well.

Hi Janet,

In truth, you should be using Primary keys for all your tables (auto-enter serial numbers) and then you can easily reference that number. Let's say you are number 5, it would be:

If ( GuestID = 5 ; 0 ; 125 )

... or then using your example:

If ( GuestName <> "Janet" ; 125 )

If no default result is specified, it is assumed blank. So in the second example, I left off the 0 result and the calc will produce blank on "Janet". A number field does NOT need a zero. If you want the zero, it can be reversed as well as the above as:

If ( GuestName = "Janet" ; 0 ; 125 )

... but what happens if you rent to someone else named Janet? This is the reason that your Guests table should have one record per unique guest so you can have two Janets, each with different apartment numbers and you can tell them apart in things such as relationships and calculations (as I explained in the first calculation).

I hope this gets you moving forward. :^)

Kind regards,

LaRetta

CORRECTION: Added part in blue to correct a typo