Simple Overdue Field??

[Sambuca]

I'm still a Newbie to Filemaker but I did use it a couple of Years ago in my Year 12 IT class. I've made a Database for a Physio Practice. They hire out Items to customers. I remember doing a Video Store Database in Year 12 but I can't seem to remember how to get the Overdue thing working. What I was thinking of doing is to make an Overdue field and for a 'Yes' to come up

"IF Date Due is > Current Date and

Date Returned Field is Empty."

Then I could do a find button to press for a list of all Overdue items (ie. when Overdue Field = Yes)?

Thing is I can't remember how to do the Overdue Field to Popup with a 'Yes' if it is Overdue. Should it be a calculation of some sort?

If anyone has any more Advice on ways to improve this Hiring System please share them.

Thanks

[danjacoby]

Duplicate!

Please post your question only once -- never post the same question in two different areas.