Showing all records with Todays date

[macmedic13]

I'm creating a data entry layout for a shot logger. I want to be able to have a some sort of display on the layout that will show all the scenes with a shoot day of the current day.

Not sure where to start.

[Vaughan]

First you'll need a field that holds the date of the shoot. Make sure it's a date field.

The "show all the scenes" requirement is a bit vague. How would you like them shown? Would a simple list view be adequate?

[macmedic13]

That would be perfect. I do have a date field already.

[David McQueen]

Lets say that you want this data on the same layout as the current shoot data where date of shoot is an indexed date field named "ShootDate".

Create a relationship "Same_Date", which is a self relationship of ShootDate::ShootDate.

Then show all other shoots for that date in a portal at the side of the layout.

You can then use a "Go To Related Record" script attached to those portal entries to take you from any shoot on that day to any other shoot on that day or to send you to a list view of all shoots on that day.

HTH

Dave