Indented BOM Question

[Chris_Hibbert_(Guest)]

This question is similar to another I saw posted by Dave Thomas but no "discussion answer" was given. I am using R&R10+ Xbase on VFP tables. I need to explode out indented BOMs and may need to go 6 levels deep. I am pretty certain I have the report written correctly but R&R comes up with no records after far too short (time) of a scan.____I started with my table INBOMS (which is my detailed bill of material) I gave it an alias of LEVEL6 and created a key (KEY1) Upper(Fparent)+upper(Fparentrev) then I added another table (again INBOMS) and gave it an alias of LEVEL5 and related it using LEVEL6--->Key1 = LEVEL5--->FCOMPONENTKEY which is Upper(fcomponent)+upper(fcomponentrev)____I did this all the way up to level 1 and when I try to run the report I get zero records. Is the software limited to how many levels (relationships down a line) it can handle or is it maybe limited in how many aliases you can use for the same table?____Is my only solution going to be creating a report for the bottom level (6) and exporting the results to a new table and then using said table in a report for level 5 and so forth and then compile all the results together?______Thanks for your help,____Chris Hibbert__

[kfleming]

If you want to email your report and a sample of your data files to me I will have a look.____Kathleen__R&R Support

[Chris_Hibbert_(Guest)]

Kathleen - did you ever receive my files?______Chris

[kfleming]

I have them, started looking at them and have not yet had a chance to go back and re-look in depth to understand what is going wrong and how to fix it.____Kathleen__R&R Support