Slow creating records via relationship...

[AliB]

Hopefully someone can help here....

As part of a larger solution, I have included an event scheduling module, with a visual 14-day per view calendar. The structure is as follows:

1) There is a Global table which has memberName and viewStart fields. viewStart can be moved back or forward one week at a time, and there are 14 calculated date fields based on its value – i.e. gView1=viewStart, gView14=(viewStart+13). The viewStart field is a global field to allow multiple users to have different values.

2) There is an Events table with owner, startDate and endDate fields. A container field is used to colourise the event based on criteria (i.e. office, sick, meeting etc..)

I have set up a great many relationships between the Global and Events tables, all very similar....

Day1Start

Global::memberName = Events::owner AND

Global::gView1 = Events::startDate

Day1Mid

Global::memberName = Events::owner AND

Global::gView1 > Events::startDate AND

Global::gView1 < Events::startDate

Day1End

Global::memberName = Events::owner AND

Global::gView1 = Events::endDate

(you can see how this is replicated for all 14 days)

The box to allow creation of records in the Events table is checked in the Day(x)Start relationship – the Mid and End relationships are there to show the colour indicator for the event spanning over multiple days in the layout.

This allows me to set up a list view layout of the records in the Global table (i.e. all the members), with the related fields horizontally across the screen... Day1S::container, Day2S::container etc..etc..... Additional related fields from the Events table are also in the layout (i.e. Events::eventName), so that if you enter a value, a new Event record will be created (due to the 'allow creation of records' checkbox being ticked).

Still with me??

OK, so the performance is really slow – it's not unusable, but it is very sluggish. I'm not happy with it, but I don't know if there is any way to improve things.....

Am I doing something wrong here, or am I just expecting too much....? I guess there are a lot of calculations going on to display all the related data for each member record, but why so slow to create the event records? I've tried creating events outwith the Global layout (i.e. not via the relationship), and it's still slow......

Any ideas......please help!!