Help with Vehicle Service database I am using the Desktop Vehicle Maintenance template in access, but i am trying to cater it towards our farms needs.

We will be keeping track of the service's done on Trucks, Tractors, Equipment, etc.
Each Vehicle will have different fields and different data tracked. But i can't figure out how to create a table for each entity and pull it into one centralized table to display service's done on all vechiles/equipment.
But i can't figure out how to create a table for each entity and pull it into one centralized table


It sounds like you want to read up on Joins: http://en.wikipedia.org/wiki/Join_%28SQL%29

A "join" basically lets you have a query that returns data from multiple tables, based on some criteria, such as records in two tables having a certain matching value. If you want to give the appearance of having this combined data all in one table, you could create a View ( http://en.wikipedia.org/wiki/View_%28database%29 ) of the query with all the joins. MS Access lets you use views to drive reports as easily as it lets you use tables for that purpose.