This is my first post, and I've only been using Access for a short while (self-taught and badly at that). I use it for personal interest and I am quite sure I break many Access cardinal sins in my existing DB and table designs. That said, I would like to ask how I should best setup a table to enter the sort of information contained in the attached image. This is an RAF aircraft movement card.
There are hundreds of these cards (often 2-sided) and each card may have up to 20 rows of information. I would normally place this information in a single table, but in this case I have up to five columns (Unit, Station, Date, Authority, etc) that need data entry.
What is the best practice for setting up a table to enter this information? In my simple view I would have the following fields:
AircraftType
Mark
Serial
Contractor
ContractNo
Engine
AirframeNo
CatCause_1
Unit_1
InDate_1
OutDate_1
Authority_1
GpAllot_1
CatCause_2
Unit_2
InDate_2
OutDate_2
Authority_2
GpAllot_2
...
CatCause_20
Unit_20
InDate_20
OutDate_20
Authority_20
GpAllot_20
This doesn't seem the most efficient way of setting up the table as I'd have >100 fields.
I apologise if I should have found this information somewhere in the forums, but being self-taught it is hard to know where to start looking or what to look for.
Thanks for any thoughts - a simple nudge in toward a thread or post would help immensely.
JB