Roxanne,

My solution is to have the location information in the input view, but in the parent.presavehook(), i would run a method to update the parent foreign key. In this method, I would check if the foreign key is empty. If so, check if the entered location is in the location table, if so update the foreign key, if not add a record and replace all fields, then update the foreign key. I still have the parent child relationship between the views and have both save normally.

Just wondering if there was a more elegant way to solve the problem?

Thanks

Rex

>Rex,
>good question. I had a similar scenario that I got around with what was probably a kludge...
>
>I ditched the usual parent child settings and handled the tableupdate() on the child myself in the parent's presavehook()