>I have a thing table and a location table related many to many (some of you talked me into it) using a common child table, giving thinglocations. The location table didn't exist before. I had a form with controls for thing.fields and a grid for thinglocations, which was just a child. All that is in the location table is a key and a location number, which was in thinglocations. The grid still needs to show location numbers, but now they are not in the grid.recordsource. This old app was designed for standalone use and uses tables, not views. I just realized that I'm not even sure about the correct way to use views with a basic parent-child form that uses a grid. Thank you.
Bret, be sure your views are updateable (there are several items to check on the view designer, and you must include the primary key fields for any underlying tables you wish to update). Then just issue a tableupdate() as you probably did with the tables. Changes go through the view into the tables.
Are you using a parameterized view for your grid? That's the easiest way, where the parameter is the parent key.
HTH
Barbara