Thanks James, You are not too simple; that's a very good idea. Haven't actually thought about it, but of course that will work. Next issue; would you happen to know, where you can set the "initial" tables to use in the filter ? I know that the user can save the query for later use, but is there a way to set up the "default" tables to search in ? /Jens
-----Oprindelig meddelelse----- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] Sendt: 23. april 2005 04:42 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: RE: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable Sorry maybe I am being too simple but can you not just use the cross refence and add the custvendexternalitem table in your filter on the inventtable form? -----Original Message----- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] Sent: 23 April 2005 05:57 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable Thanks Jesper, I will try to be a little more specific: Let's say that I would like to search for part numbers that have "XYZ" as ExternalItem field. I would do a select on CustVendExternalItem table, and I might find 4 records that match. Now, I would like to see the corresponding records in InventTable; displayed in the "normal" InventTable form. Pretty much the same result, as if I did a "Ctrl+F" in a given field and only retrieved and displayed the records that match. I have seen some installations, where you simply add a "Search" button to the InventTable form. When pressed, you can click on "External Item", and you are then presented with a search dialog. After searching, the corresponding InventTable records are displayed in the InventTable form. /Jens -----Oprindelig meddelelse----- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne af Jesper Kehlet Sendt: 22. april 2005 19:22 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: RE: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable It would be helpful with a little more detail on what you want to search on, but here is a generic approach to selecting InventTable records from criteria in related tables: First, add fields to the form corresponding to your search criteria, preferably in a group. To make things easier, create "edit" methods to tie to these fields. The edit method will then activate with the set flag when changing the contents. On the InventTable data source, in the executeQuery() method, you would test for these fields being set (non empty), and if they are, add a linked QueryBuildDataSource for CustVendExternalItem to the InventTable_ds.query(), and set that datasource to exist join. If the fields are not set (empty), traverse/get linked datasources, and clear the datasource you have set. Another approach is to add the CustVendExternalItem as a form datasource, and control the joining through code. This way it will show up in the filter view, and you do not have to add search fields on the form, but it would make it less "user friendly". That's a couple of generic approaches based on a set of assumptions about what you want to accomplish. Let me know more detail if you want more specific help. /Jesper _____ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jens Strandberg Sent: Thursday, April 21, 2005 11:23 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable Hello there, Ax 3.0 SP 3 I would like to add a feature to the InventTable form, so that I would be able to search for certain information in CustVendExternalItem, join this information with the corresponding InventTable records and present the InventTable records in the "normal" InventTable form. I am looking for a generic way to accomplish this in order to be able to expand the search facilities to other, related tables, e.g. InventTxt. What would be the best solution ? Thanks in advance ! Best Regards, Jens Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <http://groups.yahoo.com/group/Axapta-Knowledge-Village/> * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] ribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . ------------------------ Yahoo! Groups Sponsor --------------------~--> In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
<<attachment: winmail.dat>>
