SELECT PART#, DESCRIPT, ONHAND, LOCATION; FROM INONHD RIGHT OUTER JOIN INMAST; ON INMAST.PARTNO=INONHD.PARTNO; WHERE INONHD.LOCATION=THISFORM.TXTLOC.VALUE AND; INMAST.PARTNO=THISFORM.TXTPARTNO.VALUEDUMBASS ME!! I've been fiddling around all this time, when all I needed to do was include the location search in the ON like this...
...ON INMAST.PARTNO=INONHD.PARTNO AND; INONHD.LOCATION=THISFORM.TXTLOC.VALUE; WHERE INMAST.PARTNO=THISFORM.TXTPARTNO.VALUEOnce bumbled accross the above it gave me a select with all the part numbers and descriptions, etc. but those that didn't have a value in the onhand table and of course didn't have a location number, came up with part number and location = .null.!!!! Then all I had to do is add an IIF() to the fields affected and viola!!! DAMN!!! Ah well, I've learned alot from your help...so I want to thank everyone that patiently gave me replies and help:)