Either I'm not getting it, or dynamic pages don't work correctly with DB Bindings. I have multiple visitors every day and I want to cycle through each of them at x-second intervals. I have a single list and a record is returned for each site the visitor will visit. I want to use DB Binding for this, so that I don't need to create 4 separate projects.
I have 4 visitor boards and want to create a single project. (The idea is to filter the data each displays using DB Bindings). Seems fairly straightforward. My test data returns the following:
Code: Select all
ID VisitDate Company Site StartTime EndTime
1 7/22/2014 WH GI BV 1 Wheeling 7/22/14 0:01 7/22/14 23:59
1 7/22/2014 WH GI BV 1 Gilman 7/22/14 0:01 7/22/14 23:59
1 7/22/2014 WH GI BV 1 Broadview 7/22/14 0:01 7/22/14 23:59
2 7/22/2014 WH GI BV 2 Wheeling 7/22/14 0:01 7/22/14 23:59
2 7/22/2014 WH GI BV 2 Gilman 7/22/14 0:01 7/22/14 23:59
2 7/22/2014 WH GI BV 2 Broadview 7/22/14 0:01 7/22/14 23:59
3 7/22/2014 BV Broadview 7/22/14 0:01 7/22/14 23:59
4 7/22/2014 WH GI Wheeling 7/22/14 0:01 7/22/14 23:59
4 7/22/2014 WH GI Gilman 7/22/14 0:01 7/22/14 23:59
5 7/22/2014 GI Gilman 7/22/14 0:01 7/22/14 23:59
6 7/22/2014 GI BV Gilman 7/22/14 0:01 7/22/14 23:59
6 7/22/2014 GI BV Broadview 7/22/14 0:01 7/22/14 23:59
There's nothing in the documentation that explains how dynamic pages are handled and how overlapping or concurrent events are handled.
One other question: do I have to use start time and end time?