Search results for query: *

Something like that, except that its only for for Items A, B, and C that may occur in the BOM list more than once: i.e. BOM Item List for a Dining Room Table consists of: 4 of Item_A (legs) 1 of Item_B (table top) 4 of Item_D (chairs) that each consist of 4 of Item_C (chair legs) etc...

Sorry for the confusion, but the Variants are actually in a field in the table in seperate lines, AND NOT AS COMMA SEPERATED STRINGS. VARIANT CODE TABLE ITEM_CODE VARIANT_CODE ITEM_A RED ITEM_A WHITE ITEM_A BLUE ITEM_B RED ITEM_B BLUE ITEM_B BLACK ITEM_B YELLOW ITEM_B...

Hi, I have table #1 "Items" with "Item No" as the Primary Key. I also have linked table #2 "Item Variants" with foreign Key "Item Number" and Primary Key "Variant Code" (alpha-numeric). Each Item nay have multiple Variants, but only one...

Thanks Simon, I have tried this before and it will work, but if I tried to reference more than one data item using the dataset method it prompts multiple times. I want both the start and end dates from the dataset, as well as the Trip ID. Is there a way to reference more than one data item...

Thanks for all the suggestions guys. I've been toying around with this some more and still haven't come up with a sufficient solution. I have used the macro approach to open both reports and pass the hotfile info to the summary report. But to no avail, I need to display (in the header) in the...

Thanks Dave, It sort of helps, but I was trying to avoid using macros, hence the use of the dataset. To enable users to manipulate more than one report without macros was the purpose of applying the dataset functionality. I initially had the first report being opened by a macro on the second...

Hi all, This is my first post so please excuse my ediquette. I have successfully passed information from a detail report to a summary report using a "dataset" filter in the final report (Report 2) from a data subset filtered in Report 1. My question is, can I pass the "Date...