Some points have to be checked.
First, the relation has to be in the correct direction. Sometimes, relations added automatically are created in the wrong direction.
Second, the relation is from a field to an index. The second table has to have an index.
Third, you should check that the correct fields are involved.
There are probably some other things that can go wrong, but you may want to start checking the above.
Hilmar.
>I am building a software for a repair shop
>
> I am using free tables
>
> I've created a table clients and a table devices
> In the table clients I have a field called "code"
> and in the table devices I have a field called "id"
>
> I created a relation between the fields code and id
> This relation was created in the dataenvironment
>
> I have a problem:
>
> When a client is deleted their devices stays still in
> the table devices
>
> I mean; if I delete client number #2 the devices with id # 2
> o the table devices will still be there.
>
> When a new client is added to the record # 2 of the table clients,
> he will get the devices of the table devices with id # 2
>
> How can I solve this problem ?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)