Newbies pa8 Posted March 28, 2006 Newbies Share Posted March 28, 2006 Hello fellow FM'ers, I'm in the process of designing a database for a services firm and want to ask the following: I can see a drop down calendar option as a field. You can only select one date at a time. This is wonderful for other operations but what happens if you want to select a group of days together? Say for example, a customer wants 23 lessons in the month of March, altogether that is 23 days. I wouldn't want to put 23 drop down calendars on my layout (1. It wouldn't be efficient 2. It would be a very pig ugly layout). I can manually type in the date but it is not very efficient and there would be more of a chance of human error. Does anyone know if there is another solution? thx in advance. Link to comment Share on other sites More sharing options...
LaRetta Posted March 28, 2006 Share Posted March 28, 2006 Welcome to FM Forums, pa8!! You could specify a date range. FromDate and ThruDate (ToDate inclusive). Attach your drop-downs to these fields then script a writing the date-series or script creating Lesson records. I wonder if you might not want each lesson as a record particularly if they want to choose odd dates (and not distinct) ranges. Do you track the lessons? You could also use combination popups (month/year) and buttons with script parameters for each day. Script would combine them and write the date ... but where? You can capture the dates in a multiline but why put something together if you will eventually just want to take it apart again. Again records seems logical. If you could provide more details, we could help you further. LaRetta Link to comment Share on other sites More sharing options...
aaa Posted March 28, 2006 Share Posted March 28, 2006 Hi, pa8! Here is idea how you can get your goal. Look attachment. Choosing_Date.zip Link to comment Share on other sites More sharing options...
aaa Posted March 28, 2006 Share Posted March 28, 2006 Sorry, Laretta! When i started to post my suggeston your post wasn`t here. I looked it after my posting. Link to comment Share on other sites More sharing options...
LaRetta Posted March 28, 2006 Share Posted March 28, 2006 We all can post suggestions on Forums ... it is all of our ideas together that makes this such a great place... :smirk: Link to comment Share on other sites More sharing options...
Newbies pa8 Posted March 28, 2006 Author Newbies Share Posted March 28, 2006 Hi LaRetta and aaa, Thx for the quick reply, (6 mins from LaRetta !). Anyway I found aaa solution very useful, if fact I didn't even think about it that way. I guess I still have a lot to learn. Thx both Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6601 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now