>>Hi all,
>>
>>I have three tables:
>> D_ALC ( fields: CodeALC n 8, NameAL c 80, ...),
>>
>> R_AlcMsw(fields: CodeALC n 8, CodeMSW n 8),
>>
>> C_MSW(fields: CodeMSW n 8, ObjectName c 25, ...).
>>
>>
>>I would like to create one-to-many form with the following features:
>>When an element from the table D_ALC is fixed all the related records from the
>>table C_MSW to be displayed in a grid.
>>
>>Thanks
>>
>>Stoyka
>
>Set relationship between D_ALC and R_AlcMsw on CodeALC and between R_AlcMsw and C_MSW on CodeMSW. On your form you would have for example textboxes for D_ALC.CodeALC and D_ALC.NameAL and a grid of C_MSW.

Thanks for the answer of my question.

Next question connectes with the same problem:

The tables are remote views with the data existing on MS SQL Server 6.5.
How can I set relationship between these tables?

Thanks

Stoyka