Linked Table and Queries design help

[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.

 

[Jeff Boyce]

Adam

You have to add a new field where the table is -- it sounds like you are
trying to use the front-end to add a new field to the back-end.

Open the back-end and add the field there. You many need to refresh your
link in the front-end.