Hello,

I have one data table with fields SerialNo, manufacturer, and model. Called AllParts.

I have 3 other data tables (software, components, equipment) that have those same fields plus some extra fields.

I want to fill this allParts with the serialNo, manufacturer, and model from the other tables.

So allParts will contain rows from software, components, equipment

a bit like copying all the contents from the 3 tables and merging them into a single data table called allParts.

Can anyone help me with this.

Many thanks,

Steve