Lookups demystified

[FM Chick]

Hey guys I was just wondering, in the database that I have attached, how would I make the RATE(P/H): field change depending on what is selected in the MACHINE: field at the top.

So for example:

Excavator - $300 in rate field

Tractor - $200 in rate field

Hummer - $150 in rate field

PCI-200 - $100 in rate field

Honda - $180 in rate field

Telsa - $200 in rate field

Can someone give me step by step instructions on how to do this as I'm kind of a newbie in Filemaker.

Thanks

Runsheet.zip

[Inky Phil]

Hi there

You were really close but I have made a few changes so that you have what you wanted.

1/ I changed the entries in the rates table to match the names of the machines in the original table.

2/ I related the two tables by machine = machine.

3/ I changed the rates field on the layout to be the rates field from the rates table

4/ I changed the total calc so that it was the no of hours * the rate from the rate table

Hope that that helps. If you need it any more step by step get back to me.

Phil

amendedrunsheet.zip