Обсуждение: Access 97 and Postgress

I have a Access 97 application that I am porting to Postres.  I would like
to continue to use Access as a front end.  Forms with parent/child data (for
example, and order form with many order lines) don't seem to work.  The
order looks great but the order lines are blank.  I tried creating a foreign
key reference on the column that join orders and order lines with no
success.  When I look at the ODBC trace, I see the prepareSQL for order
lines is looking up by orderlinesid rather than by orderid.  Any one
encounter this problem or have any suggestions (other than finding a new
front end) on how to work around this problem?

Thanks, Michael