February 21, 200619 yr I have a table full of event data that I can easily show on a layout using a found set by the date of the events. I would like to create a layout that has the found set of a requested date listed and then right next to it show the following dates events listed. Using portals and a self-related table, I can't get this to work. And I haven't had any luck finding a previous post related to this topic. Maybe someone has tried this before or can point out a previous post that addresses this topic. Thanks, Jon
February 21, 200619 yr Jon: One way to do this would be to set up two date fields to hold your two dates: the date you searched for and the next day. Both of those would be set via Set Field [] in your report script. Then you could have a portal based on the first date on the left, another based on the second date on the right, and you'd have the data side-by-side. That's pretty basic, which to me means that I've probably misunderstood the question. Hopefully not. -Stanley
February 22, 200619 yr Author When I first attempted this, I had a "report" table with two fields in it, one was the date that was being searched and the other was that day + 1. Then I got stuck with the layout. I wasn't sure how to get two portals from the same table of data to appear in the layout, and still show up with the data from each day separated out. All I got was the date searched in one portal and the other portal was blank. If I'm understanding you correctly... Do I make the table of event data related by event date to search date and the date+1 fields in the report table? And in doing so, that should create a second instance of the event table in the relationship graph, right? Hope this makes sense. -Jon
Create an account or sign in to comment