Table1(TripEventTypes)
Expand|Select|Wrap|Line Numbers
- TripEventyTypeID
- EventTypeID
Expand|Select|Wrap|Line Numbers
- TripEventTypeID
- EventTypeDetailID
- EventTypeDetailValue
Where EventTypeDetailID = DepartureCity EventTypeDetailValue = City Name
Where EventTypeDetailID = DepartureDate EventTypeDetailValue = Date
and so on.. for Arrival City, ArrivalDate, Flight Number, SeatNumber
All this would be store in the TripEventTypeDetails for each type of event.
Right now I have a Main Form(Table1) linked to a Continous SubForm(Table2) where I can input the many details as necessary.