October 6, 201015 yr 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.
October 6, 201015 yr 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?
October 6, 201015 yr 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
Create an account or sign in to comment