Hi Everyone:<br><br>I hope someone can help. I have built a form based on a view which combines a few tables and a query. Maybe I'm thinking too much like Access. I have a query which determines the "Last" year (i.e. 99-00) in a table. In a View I have used this query and joined it to a table in which I have filtered on active records. I have created another view using the results of this. This final view is the last view joined with a table which I do not wish the user to alter. <br><br>My form works fine and does what I wish it to. My problem is this. I created an add button on the form which opens a popup form to select an ID number from the table I do not wish to alter. Then with the click of a button a record is added to several tables for the selected id. No problem with adding the record(using SQL and INSERT), but when I return to the original form how do I refresh the data. Maybe I'm going about this in a long drawn out way. I tried just creating one view using all of the tables mentioned above, but the think was as slow as molasses. <br><br>Any way, in access it's simply a matter of me.requery to refresh data, but things in this program seem convoluted to me. I guess I don't understand how things are handled in Foxpro. HELP!!!<br><br>Karen