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.