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.

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

Hi, pa8!

Here is idea how you can get your goal.

Look attachment.

Choosing_Date.zip

Sorry, Laretta! When i started to post my suggeston your post wasn`t here. I looked it after my posting.

We all can post suggestions on Forums ... it is all of our ideas together that makes this such a great place... :smirk:

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