>Hi,
> Thank you for reply.
> Actually, I am researching about relation and also n-tir c/s dydtem. Could you give me some ideas, how could I take advantage of edit foreign key if i am developing n-tier??
>
>Thank you

What do you mean "take advantage"? Some of the options are on my previous reply. First, you have to know what is available on your target backend. If you don't want to mess with that then you could do it on a middle tier component that knows about the relations on the tables. For n-tier you don't want to do this on the client side, it will make it harder to create a different front-end (because you have to duplicate functionality) and cripple your chances of changing backends in the future (say you want to upsize a DBC or MDB).

Look at the fox.wikis for Craig Berntson's series on n-tier and MTS for more info on n-tier systems. The link is at the UT's main page.