Northwind Table Field Rename Error

[sigma788]

Hi,
i am incorporating inventory tracking in Northwind 2010 Template using a sample provided on this forum.

Northwind 2010 stores Quantity Purchased in [PurchaseOrderDetails Table in field name Quantity]
And Stores Quantity Sold in [OrderDetails Table in field name Quantity]

Same field name " Quantity " gave error in Queries that " The field Quantity could refer to one or more tables"
So i changed PurchaseOrderDetails>Quantity to PurchaseOrderDetails>PQuantity.

Now i am facing a new problem.
While making purchase orders using forum it gives error on selecting products that
[ the identifier "[Quantity]" could not be found].

i am not able to track the error.
Help greatly appreciated.

sample link in other post by the name Northwind2010Client.zip
http://www.access-programmers.co.uk/forums/showpost.php?p=1119250&postcount=4

Sorry, this is to avoid unnecessary resource wastage.
Thanks.

 

[boblarson]

You didn't need to change the field name. You just needed to find the place where it referred only to the field name and you would have added the table name like

[PurchaseOrderDetails].[Quantity]

where it just had

[Quantity]

before.

 

[sigma788]

Thanks Bob, it worked.
now its not giving errors.