|
|
||||||
|
#1
02-09-10, 01:11 PM
|
|
|
|
|
How can I filter data on a form where the filter list field is not a field on
the table of the form? See for example Picking list journals. On the ProdJournalTable form I want to add a filter per BatchId. Thus the data shown in the grid (from table ProdJournalTable), must filter per BatchId, where the ProdJournalBom lines contains that BatchId. ProdJournalTable is linked to ProdJournalBom table, I only want to see ProdJournalTable records, where the linked ProdJournalBom contains the selected BatchId filter. Thanks, |
|
|
|
#2
02-09-10, 01:44 PM
|
|
|
|
|
Join the table you want to use as filter to your displayed table. You can
access the query by code and set a range there. Make sure the relation is defined correctly, if not with EDs at least with realtion on table. |
|
#3
02-09-10, 02:41 PM
|
|
|
|
|
Hi Markus
I have tried that, the problem is that BatchId is not infact contained in the ProdJournalBom table, but InventDim (which then links to ProdJournalbom). There are also classes that covern the way in which the ProdJournalTable works, and whatever I put in the executeQuery and init methods of the form seems to get lost or is overwritten with the ProdJournalFormTable class. If you can please help me, I would really appreciate it. Thanks! |
|
#4
02-09-10, 06:07 PM
|
|
|
|
|
See:
\Forms\Address\Data Sources\Address\Methods\addQueryDirPartyAddressRel ationship Is this an example of what you are trying to do? Alex "Celeste" wrote: [..] |
|
|
| Similar Threads | |
| Table & Field Properties Not available in ADOX.Catlog.Table.Fields for SQL Server 2005 Dear Sir, I am using ADOX Catalog, Tables & Fields Collection & Objects to get Table & Fields Property. If I use access database it displays all property of table &... |
|
| Make table from a range between 2 fields in another table I have a table that lists information for a gift card program we've initiated at my workplace. The basic format is: Date Store Product BegSerialNo ... |
|
| How to display Table Field names AND Field Definitions in a Report ? (ditto for query fields & criteria) 1 - We want to create a Report that shows the Field Names and Field Definitions of each table. 2 - Secondarily we also want to show Query Fields and associated... |
|
| applying a macro for a specific field to a range of fields I have a macro that takes information from two columns and builds a hyperlink in another column. I'm pretty new at this, so while I was writing the macro I wrote it for one... |
|
| How to copy content of one field to a range of other fields Hi, I have a newbie question: is there a simple way to copy the content of one field to a range of other fields in the same table? Example: I need to copy the content of the... |
|
|
All times are GMT. The time now is 06:31 PM. | Privacy Policy
|
Range on field that is not one of the fields in the table