Attaching to Access with a subform

We found a problem using Access as a front-end to Oracle when dealing with main/subforms and multiple field primary keys.

We prototyped a Visual Basic/Oracle database by creating Oracle tables on a UNIX server, creating some forms in Access, and attaching the Oracle tables to Access by ODBC. We created two Oracle tables, and created a main form in Access, and a subform, which worked fine in our original table design. The main form was based on the main table, and the subform was based on a query using the related table. The main table had an ID field (unique meaningless number) for the primary key, and the related table had the same ID field as a foreign key. The main/subforms worked properly, showing a one-to-many relationship between main and child.

The problem occurred when we changed the structure of the tables, and made the primary key in the main table a combination of two data fields, and had corresponding foreign keys in the related table. For some reason, Access has trouble linking the main form and the subform in this situation when using the attached tables. If we import the tables into Access, then the link works! We checked the Microsoft Developer's Network CD for possible solutions to this, but couldn't find anything. Is there a solution?

--
Bill Jones			e-mail addresses:
Computer Sciences Corp.			(work)	wjones14_at_csc.com
Norwich, Connecticut			(play)	billj_at_mindport.net
(203) 823-2168