Hello
I have a database in which two of my columns are ID (Populated) and Invoice (Empty) I have a query to populate the Invoice table based on an export which fills the query with the ID and Invoice number. The query works but I get an "Circular reference caused by 'Query' error message my statement is
SELECT Query.Invoice INTO Table1 FROM Query WHERE Query.ID=Table1.ID
Basically I just want to populate the Invoice field in Table1 where the ID match from the query.
Thanks Bob
I have a database in which two of my columns are ID (Populated) and Invoice (Empty) I have a query to populate the Invoice table based on an export which fills the query with the ID and Invoice number. The query works but I get an "Circular reference caused by 'Query' error message my statement is
SELECT Query.Invoice INTO Table1 FROM Query WHERE Query.ID=Table1.ID
Basically I just want to populate the Invoice field in Table1 where the ID match from the query.
Thanks Bob