Vishal
12/20/2005 6:26:00 AM
Dear Roman,
You can try following things:
1. U can create relation on the Table between the two:
Table: 'MyTransportDefects' >> Relations>> 'Normal Relation' >>
MyTransportDefects.eisTransportId == MyTransportTable.eisTransportId
2. Give the link type on the 'MyTransportDefects' Datasource level as
'Active' where u gave the join source as 'MyTransportTable'. This will solve
your problem.
3. Probably dont need to craete Index specifically for this problem, u can
create this but doesn't have any relation to this problem.
--
Vishal
Technical consultant Microsoft Axapta
"Roman Kucko" wrote:
> I have one table MyTransportTable, which has the field TransportId. For
> each transportid there can be many records in another table,
> MyTransportDefects (which also has field TransportId).
> I want to create a form, on which on first tabpage I want to put grid from
> MyTransportTable, and on the second TabPage I want to put grid from
> MyTransportDefects in such way that if certain record is selected on first
> tabpage - then only connected records (MyTransportTable.TransportId ==
> MyTransportDefects.TransportId) on the other tabpage(grid) are displayed.
>
> I have two datasources, the second has set JoinSource to TransportTable.
> Probably there is one more thing I have to do or to set. I have a problem to
> find this thing.
>
> Please help me. Is it some settings/functions/fields/indexes in
> MyTransportTable or MyTransportDefects? or some settings in the
> form/tabpage/datasource?
>
> I would be very grateful for any help.
> Thank You