Database Design Problem

[Ammo]

Hi All,

I have a linked table (tbl_ProjectDetailsLinked) and have
created a query based on this table
(qry_ProjectDetailsLinked). In this query I have changed
the field names different to what is in the linked table.

However I wish to add additional fields to this query as
Microsoft Access does not allow me to add any additional
fields to the linked table. Does anyone know how I can add
additional fields to the query and input new data in the
additional fields that corresponds to the records held in
the linked table?

Hope this clarifies the problem

Best Wishes

AMMO

 

[Jeff Boyce]

If you are trying to create new fields so you can add data to current
records in those new fields, you need to do that in the table. A query
generally doesn't create fields.

Is there a reason you can't change the linked table design in the data
back-end?

If you MUST change the data structure and can't modify the back-end, you
might consider creating a local table with a "make table" query. Of course,
once you've done so, your linked, back-end data table and your local table
would need to be kept synchronized, a not-insignificant effort.