FMP 8.5 Windows XP

I am trying to show the records for each inspector to show only todays jobs
I have worked out how to show only the reocrds related to one inspector but
not sure how to only show up the days records...

thanks for any help :0)
t

You may make the matching link in the relationship between the 'Inspectors'
table and the 'Jobs' table a little more complex. I suppose it is presently
the 'InspectorID' in both tables. Make a new field called 'ToDay' in the
'Inspectors' table, and add the new matching line from 'ToDayJob' to
'JobDate' (which exists in the 'Jobs' table). Now your new link will have
two lines which will look like :
on the 'Inspectors' table side :
InspectorID
ToDay
and on 'Jobs' table side :
InspectorID
JobDate
The portal in the 'Inspectors' record layout will the be based on this new
link and will show only the 'today'' jobs for that Inspector. Don't forget
to make the fields appearing in that portal based also on that new link.
To make it easier to the user, you may make the 'ToDay' field as 'Global',
and make it filled automatically by the opening script - which is to be run
when opening the base every morning - which has one line :
Set Field (Inspectors::ToDay; Get(CurrentDate))
and show the 'ToDay' field in the Inspector record layout, so it can be
modified by hand if ever one wants to see the jobs performed on another date
that today. The portal will show the jobs of that new 'ToDay' date. Make
also near by a button acting the opening script to refresh the 'ToDay' date
to today.
Remi-Noel


"TM" <toni (AT) dataspecifics (DOT) com.au> a écrit dans le message de news:
4560f626$0$11974$afc38c87 (AT) news (DOT) optusnet.com.au...