Timeline/Flowchart created from Access database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Each record has about 40 fields, many text, many date/time format.
Click to expand...

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.
Click to expand...

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.
Click to expand...

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
 
Back
Top