Hi,

I have a relationship calculations set up between two databases:

monday = :user_mon_calc

tuesday = ::user_mon_calc

The calculation for 'Monday' is - DateToText(start_week)&"_"&username

and 'Tuesday' is: DateToText(start_week + 1)&"_"&username

etc etc

and the calculation for user_mon_calc is - DateToText(activity_date)&"_"&username

In my master file i have a portal for each day of the week, which i want to list all records that have the corresponding daay and username. The above seems to work when just displaying the correct rows, however when it comes to entering data into any of the fields in the new row on a portal, it throws up an error message saying that the above relationship is not valid and must be changed before i can modify the field!

any ideas? Thanks!

P.S I'm a bit of a filemaker newbie so i'll need a idiot proof explanation.

You will not be able to create new records in a portal whose related index is a calculation field which references multiple fields. You might be able to use an auto-entered calculation instead, but I'm not certain.