Hi,
Have you tried display method? You can add display method in your
master table (InventTable ?), such as:
// Assume method find() to select Item_Remarks record by itemId exists
display SomeType getFieldFromOtherDS()
{
return Item_remarks::find(this.itemId).aFieldFromOtherDS;
}
Drag and drop the method to your grid, and set the datasource property
to your master table.
Regards,
Aji Sarosa
On 11/12/07, chuiringo <[EMAIL PROTECTED]> wrote:
> Hi Aji Sarosa
> Thank you very much for your reply!
> Sorry i have studied in form "PurchTable", there are in child grid
> that will be fine.
> But in my case. I want to add a field in master grid. once click a
> form will display data from two table.
>
> One is a InventTable another is new create say item_remarks.
> which is inventTable.item_id == item_remarks.itemid
> I want to add a field from item_remarks.remark in a existing Grid.
> How to do this?
>
> --- In Axapta-Knowledge-Village@yahoogroups.com, Aji Sarosa
> <[EMAIL PROTECTED]> wrote:
> >
> > Hi Ringo,
> >
> > It is possible to add more than one datasource in a grid,
> using 'group'
> > control inside the grid. One data source is set in grid property,
> the
> > other datasources are set in group property.
> >
> > For example, see form PurchTable, in the child grid, where the data
> is
> > retrieved from table PurchLine and also from table InventDim with
> the
> > following structure:
> >
> >
> Grid:LineSpec
>
> > // datasource property is set to PurchLine
> >
> StringEdit:PurchLine_ItemId //
> > PurchLine.itemId
> > Group:InventoryDimensionsGrid //
> > datasource property is set to InventDim
> > StringEdit:InventoryDimensionsGrid_configId //
> > InventDim.configId
> > ...
> > RealEdit:PurchLine_PurchQtyCatchWgt //
> > PurchLine.PdsPurchQtyCatchWgt
> > ...
> > ...
> >
> > Regards,
> > Aji Sarosa
> >
> > chuiringo wrote:
> > >
> > > Hi All
> > >
> > > I am new in Axapta. i am facing a problem regarding adding data
> > > in a grid from two data sources fields. Is it Possible?
> > >
> > > if possible, how to do that? add method or add join source in data
> > > sources.
> > >
> > > please help, thanks
> > >
> > > Ringo
> > >
> > >
> > >
> >
>
>
>
