> You'll want to take a look at using views. They let you do everything you're asking for. You select the tables you would like the view, set-up how these tables are "joined" together (there common field). You can also set how you'd like the resulting cursor sorted and filtered (look at view parameters to adjust the filtering rules). Then you select the fields you'd like to be updatable (so that the data gets sent back to the original table). Make sure to tag at least one "unique" key field, and check the "Send SQL Updates" box in the "Update Criteria" tab.

Views, eh? I've heard of them, but never knew what they were. Let's see what my "Using VFP 5" book has on them. Anyone know of a better book? This one's really general on a lot of things.

Ok, I looked. All I could find on view seemes to be talking about SQL-Select. what's the difference?

Thanks,