Ben,

Sel * from BLDetail t1, BLMaster t2 whe t1.BLNo = t2.BLNo order by BLNo desc

Worked like a charm. Found every column.

I also tried:

Sel * from BLMaster t1, BLDetail t2 whe t1.BLNo = t2.BLNo

which found one corresponding row for each Master BLNo. Data is fine. It's in the link, and the form still won't pull up the many table.

Thanks for the reply.

Damon

Damon D. Kaufman
President
Stalder Spring Works, Inc
ISO-9002 / QS-9000 Certified
2345 S. Yellow Springs St.
Springfield, Ohio 45506
Voice 937-322-6120
Fax 937-322-2126
email: [EMAIL PROTECTED]

Reply via email to