I have a access database that i recently upsized to a SQL Server 7 database. I am kind of new to SQL server, and it is confusing me. What i need to do is figure out how to tell the database to refresh the info that it is showing in a subform, as soon as the data in another table is changed.<br><br>I could do it in Access without to much problem, but i can't seem to get it to work in SQL. Also, In access you could set a criteria in a query to make a field equal to another field in a loaded form. I have found that you can't do that in SQL Server either. <br><br>Anyhelp you can provide is greatly appreciated. I am kind of lost here. <br><br>Thanks<br><br>Dynapen