I am using MS Access 2002, and I have created a database to track permits issued by the City and inspections that result from certain types of permits. For example, new homes, and structures in general have a series of inspections that are required as the building progresses.
What I would like to do is select 8 fields from certain Permit records and copy them into an inspection table that has, in addition, all of the fields necessary to track the various required inspections. In other words, why type in the data that has already been typed into the 8 fields in the Permits table, if I can just copy it into a new record in the Inspections table.
It is convenient to have those fields in the Inspections table, even though they exist in the Permits table already.
Ideas and suggestions are appreciated.
Thanks
Sonny
What I would like to do is select 8 fields from certain Permit records and copy them into an inspection table that has, in addition, all of the fields necessary to track the various required inspections. In other words, why type in the data that has already been typed into the 8 fields in the Permits table, if I can just copy it into a new record in the Inspections table.
It is convenient to have those fields in the Inspections table, even though they exist in the Permits table already.
Ideas and suggestions are appreciated.
Thanks
Sonny