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
