Hello,
I have added a field in my calendar form which is referring to another table : contact (Structure : ID, NAME).
This allows me to make a link between my calendar and a contact.
I would like to be able to see the name of my contact when I am on the main page of the calendar like : “09:00 My event, My contact Name”. If you take a look at this attachments, the event is like : “09:00 My event”.
Thank you
Re: Customize the event description
Can you create a view combining the two tables and base your ScriptCase application SQL on the view?
Re: Customize the event description
I can create a view but where should I tell to script case to use the view that I’ve just created to display all the events in the calendar ?
Re: Customize the event description
You’ll have to experiment, but if your view’s primary key is that of your main table (e.g. calendar) it should be able to perform CRUD operations on that table. You can use events (afterupdate, afterinsert, afterdelete) to perform the appropriate CRUD events on the contact table.
i.e. the view serves to extract and present the data and update one of the two tables, the other table is updated via events.
Give it a try