I have a SQL server connected to an Everest software program. I run queries from Access and it pulls data from a current Table created in Access.
We are adding new products into the SQL database, but the query for current price lists that I run do not reflect the new 'data' or 'products'. My question is how do I update the data within a Table to reflect the newly added items in the database?
If I manually go into the Table and add a new line with the product information, save it, then re-run the query, the new data shows up, but I want a dynamic way of updating the Table to reflect the new DB data.
How do I do that? Or do Tables have to be manually 'edited' and have items individually added one at a time?