Hi,

Subforms are set at the form level! In your subform control click properties and set the master and child link properties. This will cause your subform to appear filtered as if an inner join had been performed. You do not need to do this explicitly in SQL, if you are using the sub-form control. For more complex actions views can be created and the result used for the most part as if it were a table to display data, but this does not provide an updatable recordset to you unless you set the unique table property.

ADP files do not work with a local copy of the data! If you point your ADP file at your database your users will have access to live data that will never be out of date. If this is not what you wish then you will need to look at setting up another database on your sql server to mirror your live one, and point the application at that. In that case you will need to keep the copy updated. You could do that with triggers on all your tables in your live database as Steve suggested. This is the best way to get an upto date copy of the data.

Depending on how uptodate you need the data in your copy to be and the number of transactions that are occuring you may want to have some sort of batch update that occurs at off-peak hours. Like a scheduled DTS job.