>>>The relationships between tables shown in the database designer are not shown as defaults in the data environment
>>>designer. I cannot set these relations in the DE.
>>>Any hints will be appreciated. Two of the tables are linked
>>>one-to-many using an index tag consisting of two concatenated fields, which are in both tables.
>>>
>>>John
>>
>>
>>Some things in the Data Environment are there in case you want to over ride the 'default' settings you have already established. Mainly you can change properties at run time.
>>
>>HTH,
>>Tom
>
>Thanks Tom for your reply,
>
>Here are a few more details: there are 3 tables: A, B, and C. Both A and C have one-to-many relationships to B. The link between A & B is shown if these are the first two tables added to the DE. When C is added, no link to B is shown (even though the link shows in the Database Designer). If a new form is created and C is added to the Data Environment first, then the relationship between it and B is shown when B is added next, but the link that was previosly shown between A and B is not shown when A is added.
>
>It seems that I can have only one link showing in the DE at a time.

John

We looking at VFP 5 in October! (s)

Tom