Hi Graham

thanks for this. I will give them a go but just to try to explain to you the scenario.

basically a person has an event which can be different type. some of the events can have records associated to it...

so i was thinking of this

client table (person info) , eventtable (Holds Date and eventid), eventtypes (event type info), associated events records

would i need to create a key to link the eventable to the eventtypes and also the eventtype to the event records.

how do you think i am going? am i all over the place ? 🙂