Can anyone help ?
Or maybe you need more info?
--- In development-axapta@yahoogroups.com, "benoit.billington"
<benoit.billing...@...> wrote:
>
> Hi,
>
> I have a form with 2 DS : PurchReqLine & InventDim
>
> http://img23.imageshack.us/i/greenshot20091019161154.png/
>
> And I want to filter that form with another DataSource: ALApprovalStatus
> Which contains 3 fields: RefTableId, RefRecId and Status
>
> The content of this table can be like this :
> PurchReqTable.TableId, PurcReqTable.RecId, Status
> => 117, 66666666, "Approved"
> => 117, 55555555, "Rejected"
>
> => 007, 55555555, "Submit" ==> 007 isn't from the PurchReqTable !
>
>
> So if I want to see my Requisition lines (PurchReqLine) which are approved
>
> I have to link PurchReqLine to PurchReqTable via the PurchReqId
> and then I have to link PurchReqTable to ALApproveStatus via the RecId & the
> TableId
> and then add a range on the status.
>
>
> But I'm having trouble doing just that !
>
> I think there are at least 2 different ways of doing it
>
> Either I add datasources to the Form via the "drag & drop features"
> Or I do it in X++ in an init or executeQuery Method
>
>
> But I can't manage to do it correctly
>
> I can give you some xpo's to try but you will need to import lots of stuff ;)
>
> So maybe it's better to help me understand the steps by pointing me to some
> solutions :p
>
> thx
>