.recordsourcetype = 4 && sql. in the erference it states that the sql statment is to be entered in the .recordsource property. i have tryed and must be doing something wrong, because i am getting the error:"Syntax Error", however, in the command window this command is working. here is the sql statement i have entered:
sele ; receipts.item, ; receipts.pono, ; receipts.qtyrcd, ; podet.qtyord ; from receipts, podet, pomast ; where ; receipts.pono = pomast.pono .and. ; receipts.pono = podet.pono .and. ; receipts.item = podet.itemi have no clue what i am doing wrong, can anyone put me on the right path.