>>>I add 2 one-to-one related tables into the dataenvironment of a new form by the form designer. The relation between tables doesn't come with them in spite of existing one-to-one relation in the database.
>>>What's wrong?
>>Moreover the tables in DE lost their primary keys, left only as the candidate. The displayed linking line (seen in the visual DE) is on but not connecting between the index tags.
>

---

>
>You would first setup the right relationship in database file!!
>
>At Database Tab, Select the Database root name (e.g. database1),
>Click the Edit Button to add a Permanent relationship between 2 tables.
>
>Then, wherever you create a VIEW,form,report,label...
>Once you add both tables in DE, the relationship will automatically added!!
>
>At least of the table has a primary Key to make Permanent relation!
>To ensure make relation, there are some dummy record to make it sure is One-by-One or One-by-many!
>
>If no data in either table, you can't add relationship to them... ~_~

As I said in the first message, there is already the permanent relationship between the tables of the database. It is the one-to-one relationship, between the primary key of both tables. The tables also contains some data. The correct relationship just doesn't come when I add the tables into the DE of form! Between the tables in visual DE , the relationship line is seen there but not linking between the primary keys! It becomes a line starting from the primary key from one table to the first line, named "Fields", in another table. Additionally, the primary keys of both tables are visually not marked as primary key.
Such a weird thing..