My Access database has 7000+ records. Each record has about 40 fields, many text, many date/time format
The records have events (distributed over a few months or several years). Some records have only 2-4 events, others have 10+ events.
I want to create a subform that shows the events in a boxed timeline, similar to a flowchart. The chart needs to be dynamic - it can follow two or three basic threads, but it should only show actual events. The event boxes, if possible, should be editable - directly writing to the source table
Any ideas

=?Utf-8?B?V2VybmVy?= <(E-Mail Removed)> wrote in
news:38D9AEE0-ABC4-4B1C-920D-(E-Mail Removed):

> Each record has about 40 fields, many text, many date/time format.

Hmmm: that's a very wide table -- I suspect a Design Problem...

> The records have events (distributed over a few months or several
> years). Some records have only 2-4 events, others have 10+ events.

I am not sure what you mean by this. Being generous, I'll assume you mean
that each thing is related to several records in the Events table...

> I
> want to create a subform that shows the events in a boxed timeline,
> similar to a flowchart.

As long as you have a decently normalised design as above, you just base
the subform on a query that sorts the Events records in DateItHappenned
order.

Hope that helps


Tim F