Copying selected fields from one table to another

Sonnyboy

New member
Local time
Today, 14:40
Joined
Sep 13, 2007
Messages
9
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
 
In a relational database, all you need do is join the two tables with a PK and FK and all of the fields of both tables are available in a query. It is unnecessary and actually a normalization violation to have the data in more than one table. If you want some assistance in getting it to happen in the manner I described then post back here.
 

Users who are viewing this thread

Back
Top Bottom