In my things related many-to-many with locations database, the subject of my other threads, I now need to find the right way to assign locations to things, which means adding records to the thinglocations table, which is a child of the other two tables. I have a parent-child form with the thing table and a locate view in its data environment. The locate view joins the location table and the thinglocation table on the key loc_id, with thing_id as parameter (thanks, Barbara). It's the .RecordSource for a grid. I made a combo for the column that has the location number, which I want to display. I'm trying to figure out what needs to be in the locate view, and what are the properties of the combo. Location number is the only displayed field in the location table, in the view it's called locate.locnum. Should Loc_id, which is the join field, also be one of the output fields of the view? Does the combo have two columns, one for loc_id (which doesn't display) and one for locnum? I made my key fields numeric (double) but I'm using VFP3, although I hope to upgrade to VFP5 soon. Is that going to screw up my combo? If so, I have to do something with controlsource in code, I believe, but I'm not sure how that would work here.

I have two other many-to-many relationships, so this thing-location stuff will be real useful.