>I see this working. What worries me the the trips table. I'm hoping to >avoid entering a new record for each trip, for each boat. Could I >somehow use a range? some of the trips run each day from June to >October. I'd love to find a way around entering hundreds of records >for each trip. But, I can't think of a way.
Well, if the trips are regularly repeating (like weekly, monthly, or daily), you could always include a recurring flag in the trip table. How you'd do that query based on a date I'm not sure. Another option would be if you have a web form for entering the dates, you can set a recurring schedule that way, and then have the code insert each different occurrence of that trip in the database. (for example, on the form you select "weekly until 10/1/2003", then the action page would loop through each week from the start date until 10/1/2003 and insert a row for each one of those. Of course, with that option, I'd probably have a separate table for the trip_schedule. Scott -------------------------------- Scott Brady http://www.scottbrady.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
