Adding information to a read-only table?

[RSW]

Hello,

I wasn't sure which area to post this question in...since it involves queries, tables, and forms

There is a read-only table in my company's data warehouse that stores a lot of records. I wish to set up a form that will allow users to add or relate data (fields) to each of those records.

Updating the data warehouse table structure is not an option.

How can I best do this...

1. set up my own table somewhere, that will automatically append any new data warehouse records every night, so basically I'll always have a copy of the DW table, but with additional fields that can be updated?

2. set up another table/query that are linked to the DW table via unique identifier...but if I do this, how do I display the DW records alongside the new fields in a way that makes sense? another query? will I be able to write in data in this fashion?

3. ...some other way?

Any assistance will be very much appreciated!

 

[KeithG]

I would go with option 2. You could create a query to link the two tables together to display the data.

 

[RSW]

Thanks Keith,

How would I set up a new table, to capture the additional information I need, and be able to link it to the existing table? The existing data warehouse table is AutoNumbered and the sequence can be kind of strange.

The output I need on my eventual form is five Data Warehouse fields, followed on each row by two new fields that I guess will be stored in a new table somewhere.

I hope this makes sense..?