Linked table design and queries

[Adam]

Hi All,

I have a linked table which reports on orders. It contains a field called
'Auth_No' as well as many other fields.

I want to add in whether the order was 'Valid' however as its a linked table
I can't add the field.

I've thought of using a make table query then adding the field to the table
created in Access. However the linked table updates daily with new orders so
when I go to run the make table query again it duplicates records. The same
can be said with the Append query etc.

Can anyone help me please? How can I add the 'Valid' field ? The Valid field
will need to be a "Yes/No" format field.

 

[Adam]

Thanks for the reply joseph. Though forgive me I'm new to Access.

How do I go about doing this? When I link a table it makes it read-only.

 

[Albert D. Kallal]

Are you just trying add a new field to a existing table?

Just open up the back end table, and bring up the table in design mode, and
add the new field.

All structure changes to your database must be done in the back end part.

 

[Adam]

I do not have access to the back end tables.