Unanswered: Crosstab - data from one table to another
I'm not quite sure if this is possible but anyway:
I currently have a master table of records, which the information is in, this never changes. This table has three columns, one of these is my primary key which is a unique number.
What im trying to do, is that if I create a new table and I only want selected records to appear, by typing in the primary key, then the rest of the information on that row will also come into the new table aswell. Each of the column names in the two tables, would also be identical.