>Hi John
>
>When I initialise my form it basically does the SQL into the cursor. How would I incorporate this on the form / local view. Havent used this method before??
>
>Thanks
Create a local view in your database. The design steps are similar to a query, but you must check the "Send updates" option, and specify the key fields, and which fields you want to be updatable.
Then, you can USE the view just like any other table.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)