>>>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
Since you are dealing with views you won't set the relationship on the actual tables. Include the views in the Data Environment of your form and then use SET RELATION to set up the relationships between the views. Also, will need to create indices for your views beforehand to facilitate the relationships.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.