Mike,

I don't understand your question.

create table foo ( kfookey i primary key )
create table bar ( kbarkey i primary key, kbarfookey i references foo )

foo is the parent
bar is the child
kbarfookey is the foreign key

given these tables, which of these Setups and Replaces do you mean:

* Setup 1
use foo in 0 order kfookey
use bar in 0
select bar
set relation to kbarfookey into foo

* Setup 2
use foo in 0
use bar in 0 order kbarfookey
select foo
set relation to kfookey into bar

* Replace A
select foo
replace kfookey with X

* Replace B
select foo
replace bar.kbarfookey with X

* Replace C
select bar
replace kbarfookey with X

* Replace D
select bar
replace foo.kfookey with X

* Replace E
replace kfookey with X in foo

* Replace F
replace kbarfookey with X in bar

^Carl


>Can you reposition the child table of a relationship after doing a replace on a foriegn key in the parent table without SKIPping, SEEKing, or GOing?
>
>This is part of a resuable class, so all I know is that the parent table is the currently selected.