Calendar add on question

Hi,
please see my answers below:

1. to create list of records for each user create custom view on the Datasource tables tab and set up User can see and edit their own records only security method for this view on the Advanced security settings dialog on the Security tab.
   
2. you can set up fields as required on the "Edit as" settings dialog on the Visual Editortab. Also you can set up default values for the field on this dialog.

Jane...Thank you. You have been a great help. I am developing this large project for my employer and this program as made it so much easier.
My boss has decided that a "calendar view" would not be best. He would prefer I set up a page that when the user logs in has multiple dates to pick from (each month). Basically, it is a "signup sheet" for daily assignments.
My question... do you know if there is a way to structure the database/pages so that after they log in and go to the ADD PAGE they see multiple date fields to pick? Each date is then entered into one table as an individual line?
Example:
Employee picks June1, June 6, June 15
Database shows the following:
Field 1 Field 2

John Doe June 1

John Doe June 6

John Doe June 15
Right now it works if they add a new item for each day, but I want to set up one master page that streams the data into one table line-by-line all at once.

This way FIELD 1 will contain multiple entries for NAMES and FIELD 2 will contain multiple entries for DATES. I know I can create the page to have multiple date selections, but this streams them across the database table (not individual entries).
THANKS FOR ALL YOUR HELP!

Hi,
you can create aliases for these fields on theEdit SQL query tab, then update table manually in theBefore record added event on the Events tab.

Here is a sample SQL query:

select field1,