This problem has reared its ugly head before and I've been able to work around it. Now I need this to work. Table fields are PartNumber, Model and Description. PartNumber is filled in via a drop down. Model is filled in with [PartNumber].[Column](1). Model fills in just fine, but Description is blank. Model is the 2nd column over and Description is the 3rd. I am trying to fill in Description with [PartNumber].[Column](2). This is how the SQL statement looks:
SELECT InventoryData.PartNumber, InventoryData.Model, InventoryData.Description
FROM InventoryData
ORDER BY InventoryData.PartNumber;
What am I doing wrong?
SELECT InventoryData.PartNumber, InventoryData.Model, InventoryData.Description
FROM InventoryData
ORDER BY InventoryData.PartNumber;
What am I doing wrong?