Hi!

SET RELATION is not established automatically with frelation inside of the Data Environment. You require to make it manually and set up the index order manually for that. So, you require to put in Load method of the form something like following:

Select MyChildTable
SET ORDER TO TAG u_key
SELECT MyParentTable
SET RELATION TO ... INTO MyChildTable

HTH.

>Hi
>
>Thanks for replying. Yes I use set relation in the IDE. I have the child key set and it works fine.
>
>The problem arises when I open the table in my form. For some reason it changes the key and the relationships even though I have deleted these. the table has a foreign key specified linking to the customer table.
>
>I'm not sure why this is happening. Any ideas???
>
>regards
>Geoff Scott
>
>
>
>>Hi!
>>
>>>Hi
>>>
>>>On my customer table I have a integer key (u_key) which I use to link from my invoice header.
>>>
>>
>>How you made that link? SET RELATION or something else?
>>
>>>When I set up the relation and browse the tables using the IDE this works fine but when I try to use the link in a form it interprets this as the recno() and returns the wrong record.
>>>
>>
>>If this is SET RELATION, is index properly set in the shild table to the key field index?
>>
>>>Do I always have to convert the integer to a string to use it in a key???
>>>
>>
>>RDBMS theory recommends to use only keys that uniquely number records. It does not matters what is a field type of the key, but Integer is the simplest, quickest and easiest way to oranize primary keys. Thus, why you expect VFP does not support this? :-)