It feels like my Events & PeopleEvents tables are in conflict. Currently:
Using a Excel and trying to stump the model I have noticed that Events in tbl_PersonEvents are one of's (ie Brith, Death) and tbl_Events seems to group events (School, Grad) and that many have From-To dates.
tbl_PersonEvents tbl_Events PersonEventID EventID PersonFK EventDate EventFK EDateAcc EventDate EventLabel EDateAcc EventDescription
I would like to have Single list of dates and events, but if I split these tables , will that make a messy query?
E.G.
This doesn’t feel right, maybe the labels are off, or the structure is wrong, I just don't know.
tbl_PersonEvents tbl_Events tbl_PersonGEvents tbl_GEvents PersonEventID EventID PersonGEventID GEventID PersonFK EventLabel PersonFK FrGEventDate EventFK EventDescription GEventFK FrGEDateAcc EventDate ToGEventDate EDateAcc ToGEDateAcc GEventLabel GEventDescription
Any suggestions are welcomed.
Thanks for Looking.
PS It seems that the ToDate could be replaced with Length of the event in days but....