I'm not sure if this is possible but if anyone has any ideas that could even slightly apply, I would highly appreciate them.... My database allows a user to create an order by selecting various products from a form. These selections go through a series of queries to 'fool proof' the order and then are fed into a report. After the report is finished, I need to make sure it is not altered when creating a new order, and to do this I am thinking I should export it to another file so it is not inadvertenly changed. HOWEVER---this is my problem-----orders rarely stay the same from order date to ship date, so this report will likely be changed a number of times. THUS, it needs to be in a file that will retain the relationships with the 'master' database. How can I do this? I know I can link databases, but I do not want the report to be changed when creating another order. (I.E. can I turn relationships on and off when necessary?? ...ON when I want to update orders, and OFF when I want to create entirely new ones) I know this can be accomplished by copying the entire database into a new file, however this will take up too much space, considering the amount of orders that will be dealt with. Any ideas?? Thanks!