silentwolf
Active member
- Local time
- Yesterday, 18:39
- Joined
- Jun 12, 2009
- Messages
- 545
Hi guys,
unfortunatelly I would need some help with a Query.
Attached the Query in Design View...
And this is the Query in SQL
As I created the query it showed me all the BaseItems from 1 to arount 8000 records correct Result.
But after saving the query and reopen it it is stuck with BaseIID =1
So there are the correct amount of Records 1 to about 8000 but with the BaseIID 1
I am not sure what or why it is doing that?
Can someone please advice?
Hope the naming is now a little better for you?
I still like to differentiate the FK so hope this is not to bad?
Cheers
unfortunatelly I would need some help with a Query.
Attached the Query in Design View...
And this is the Query in SQL
Code:
SELECT BaseItems.BaseIID, BasePacs.PackageContent, Units.Description, BaseItems.BaseCIDRef, BaseCategories.Description, Manufacturer.ManufacturerName, ItemCategories.Description, BaseItems.ItemCIDRef, BasePacSuppliers.ArticelNr, BasePacSupPrices.BPSupIDRef, Discounts.Discount, BasePacSupPrices.DiscIDRef
FROM Discounts INNER JOIN ((Manufacturer INNER JOIN (PackagingUnits INNER JOIN (Units INNER JOIN (Suppliers INNER JOIN (((BaseCategories INNER JOIN (ItemCategories INNER JOIN BaseItems ON ItemCategories.ItemCID = BaseItems.ItemCIDRef) ON BaseCategories.BaseCID = BaseItems.BaseCIDRef) INNER JOIN BasePacs ON BaseItems.BaseIID = BasePacs.BaseIIDRef) INNER JOIN BasePacSuppliers ON BasePacs.BasePacID = BasePacSuppliers.BasePacsIDRef) ON Suppliers.SupID = BasePacSuppliers.SupIDRef) ON Units.UnitID = BasePacs.UnitsIDRef) ON PackagingUnits.PacUnitIID = BasePacs.PacUnitIDRef) ON Manufacturer.ManuID = BaseItems.ManuIDRef) INNER JOIN BasePacSupPrices ON BasePacSuppliers.BPSupID = BasePacSupPrices.BPSupIDRef) ON Discounts.DiscID = BasePacSupPrices.DiscIDRef;
As I created the query it showed me all the BaseItems from 1 to arount 8000 records correct Result.
But after saving the query and reopen it it is stuck with BaseIID =1
So there are the correct amount of Records 1 to about 8000 but with the BaseIID 1
I am not sure what or why it is doing that?
Can someone please advice?
Hope the naming is now a little better for you?
I still like to differentiate the FK so hope this is not to bad?
Cheers