Linked Tables

[rawellz]

Alright here is the issue....

I am working with 2 linked tables where the data columns can't be adjusted. Working with Sharepoint 2003 & Powershell

Sharepoint List - Linked Table
- ID (PK)
- Field 1 - FileName
- Field 2 - File Type
- Field 3 - Sharepoint File Path

CSV List - Linked Table (Exported through Powershell)
- No PK
- Field 1 - FileName
- Field 2 - File Type
- Field 3 - Network File Path

What I NEED to do....(very little SQL knowledge)

1. Add a text column to the "Sharepoint List" called "Reviewed". This column ultimately will allow me to select whether each record is "Relevant" or "Irrelevant". I tried this through creating a copy of the Sharepoint List Linked Table. The problem is that when I refresh the data the copied table data does not update. How can I accomplish this?

What I HOPE to do...

I would like to combine the 2 linked tables, however I am afraid it is not possible since I don't have common Primary Key. Ultimately it would be great to have a query or table show

- File Name
- File Type
- Network File Path
- Sharepoint File Path

Hopefully this all makes sense...

Thank you for your help!!!