Recent content by DeansOnToast

1. BoM is Bill of Materials - Very generic 2. I stated that I removed some identifying information that's why

SELECT [table1].FORMNUMBER,[table1].PARTNO,[table1].PARTDESC,[table1].COST,[table1].QTY FROM [table1] INNER JOIN [table1] ON [BoM].ManufactuererPartNo = [table1].PARTNO; Removed some identifying info just for safety sake, and seems it is an inner join. Was intending to use the relation as a...

Was investigating an issue where a query based on form parameters were not returning all relevant records and found it went one level worse and even a new select query with no criteria just passing the table through doesn't even return all the records. I'm confident its a rookie error as in the...