>Thanks for the response.
>
>Two things, I am using DB2 as back end and partno is a field of the parent table not the child table.
How are you joining these two tables? Can you show a simple JOIN that lists all records?
If it's not broken, fix it until it is.
My Blog