Hi people!

I'm new to FMaker scripting & I have found a few troubles in my works = I try to create a manual clients DBase.

1.

I have created a data field in a table representing the date of birth of my clients (full view dd/mm/yyyy). I tried to create a script that it will do an automatic

search inside this field & show me the records of the clients that have their birthday today. I tried "perform find" step, but I cannot find a way to make the

"day birth" field equal to the current date. If I enter "//", it will search for the year also, thing that I want to avoid (I just need the current date for day &

month, NOT year).

2.

I have gathered all the post codes in an Excel file.

In my clients DBase, I have entered 2 fields: City & Post code.

How can I make FileMaker to automatically fill the post code (checking the value from the Excel file) each time that I enter the city name (select from list)?

1.

Go to Layout [ Clients ]

Enter Find Mode [ ]

Set Field [ Clients::BirthDate ; Day ( Get ( CurrentDate ) ) & "/" & Month ( Get ( CurrentDate ) ) & "/*" ]

Perform Find [ ]