That certainly is one way of setting up a 1-to-many relationship, yes -- assuming that the autonumber field is the primary key in the "parent" table. Be sure to set the data type of the AcctID field in the "child" table to Number - Long Integer. -- Ken Snell <MS ACCESS "jk" <jk@discussions.microsoft.com> wrote in message news:F4F41631-76CB-4B2C-8838-433BAD1C2F05@microsoft

If each invoice record can have only one account number, then you have a one-to-one setup for that record. You should be able to use the AcctID value in the ACCTS field, where AcctID is a foreign key to the primary key in the Accounts table. No need for another autonumber field here. -- Ken Snell <MS ACCESS "jk" <jk@discussions.microsoft.com> wrote in message news:20DCD8A7