@ Jim: i think he does need PollFK in the times table - what if several events are scheduled for same date?
@Ben: you data structure look fine. i guess your query that retrieves event's data needs to be tweaked... you definitely DO NOT need SEEVRAL queries - you need just ONE query. can you post what queries you have now? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 05/06/2009 16:49, Jim Cumming wrote: > Not sure if this will help or not, but do you needs the PollFK field in the > times table. Surely your relationshp is Event --> Date --> Time. If you do a > query with some outer joins you should then be able to return > > Event 1 Date 1 Time 1 > Event 1 Date 1 Time 2 > Event 1 Date 2 Time 3 > Event 2 Date 3 Time 4 > Event 2 Date 3 Time 5 and so on. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323196 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4