||[Jun. 2nd, 2008|03:41 pm]
The Veritable TechNinja
|||||Bailey - Pushin' Beatz (on Pandora)||]|
Anyone have significant experience with MS Access? I'm trying to develop an airline passenger manifest database. Records should show all passengers of each flight, as well as a ton of stats both on the person and the flight. The issue is avoiding massive duplicate data entry.
What I'd like to do is make an entry to the database per passenger per flight, but have the stats of the flight populated automagically. Basically the form has two parts:
The flight info, which will be the same for all records entered per session (for each passenger).
And the passenger info, passport numbers, TSA clearances, &c.
Then the record contains all the data per passenger, so that reports can be generated saying what flights on what days what guy took without having to make the passenger names fields instead of whole records. Or should I just dump this idea and make a bunch of "passenger 1", "passenger 2" fields in the records? I would, but I imagine it'll make querying a bitch.
Anyone know how to do this? Once I have the input form that auto-populates the records with the data that's the same for all passengers of that flight, making a report will be as easy as picking a flight number, date range, passenger name, &c.