Auto Populate Date Fields from Another Table

The general answer to this question:

is yes.

However, it may not do so in the way you are wanting. This would need to be done through linked records – your “Free Job Slot” records from the calendar view would need to be linked to the table you want their start and end dates to transfer to.

You’re language is a bit vague regarding what you’re trying to do though, so I’m unsure as to whether you are creating new records when you “click on a record from a calendar”, or if you are just expanding that record to view its details…

Here’s what I’m imagining:

• You have your 2 tables “Free Job Slots” and “Jobs”
• These two tables are linked in a one-to-one relationship (ie, you have a field that is a “Link to Another record” with “Allow multiple records” unchecked
• In order to “convert” a free job slot into a job, you click the + sign in the Linked Record field from the “Free Job Slots” table, and click “Add New Record” at the bottom, to create a new “Job” record
• In the “Jobs” table, you have 2 “Lookup” fields that lookup the Start Date and End Date from the “Free Job Slots” record that each “Job” is linked to

What you imagined is correct - despite my vagueness. Many thanks.