[color=darkblue]Is it possible to tie related items (both A & B) to a given event as opposed to a day, for both viewing and creating? If so, how?

Right now it's set to be tied based on a given day, but what if a user wants to tie specific items to a specific event on a calendar? If for example there are 5 or 6 events for a given day (3/2/2005 for example), it's possible to have 8-10 related items tied into those 5-6 events, but if the related items don't specifically mention the event, it's possible for the users to be confused on what related item ties in to what event.


Any help would be greatly appreciated!

Thanks

Well, I guess you'd begin by adding an appointment ID to your related items A and B records; something that would like them to a given appointment. With that in place you could add a new field to the calendar (to the "Calendar" table): something like "SelectedAppointmentGlob".

Then change the "daily" relationships for related items A and B to relationships between this "SelectedAppointmentGlob" and the appointment ID in your Related Items A and B tables.

You'd just want to add a button to the appointment's portal in the daily view that set this "SelectedAppointmentGlob" when you clicked on that appointment. You'll want a separate button, I think, so that there is an obvious difference between clicking on the appointment to edit it and clicking on it to see its related items.

Going further....

You may want to see all the related items for the day and then restrict the display to just the items for one appointment only when you click on an appointment. To to this you'd create a calculated key in Related Items A and B and use this key instead of simply the appointment ID in your relationships to calendar daily. This key would be a text field looking something like this...

KeyAppointmentIDX & ¶ & "-"

...allowing the relationship to match on either the ID of a selected appointment or on a dash. You'd then create a new calculated text key on the Calendar side of the relationship like this...

if ( isempty ( SelectedAppointmentGlob ) ; "-" ; SelectedAppointmentGlob )

To make this smooth you'll need a way to deselect an appointment and return the related items display to show all items for the day. You can either use a new button for this or teach the same appointment select button we discussed above that if the current appointment is already selected, simply clear SelectedAppointmentGlob. This lets you click on one button to select the item, clicking on the same button to de-select it.

You'll probably also want some visual indication of which item is selected.

HTH,

John