relating dates and times (what's your sign)

[one09jason]

Here's a problem I'd like to solve with FM.

Imagine you have two databases. One contains a list of, say, zodiac signs. Each record would contain a sign like capricorn and the dates that define that sign.

Another database contains a list of people and their birthdays.

I'd like to write a script that goes through the database of people, and adds to each record what sign each person belongs to.

Can anyone think of a way to do this?

[Vaughan]

Cross posted in Scriptmaker forum.