Hi, below is a link to my ERD:

Gliffy Public Diagram - PurchaseOrder

When I have set this up in Access it works fine, but when I have made the same database in SQL, and used Access as the front end, it seems to have problems putting the data in the ItemOrder table. I think this is either because the cascade updates are not working properly, or more likely when access tries to insert an ID into the table ItemOrder, it loses focus, and both PurchaseOrderNo and ItemNo are PKs in this table.

Any help is much appreciated.