I have four tables: Table A: client information ex. John Doe (DOEJ); Kate Bell (BELLK) Table B: client file information ex. John Doeâ€™s Business One (DOEJ 1001), John Doeâ€™s Business Two (DOEJ 1002); Kate Bell Business One (BELLK 1001), Kate Bellâ€™s Lease (BELLK 2004). Table C: storage information ex. Box 10 was stored on 6-1-06, Box 11 was stored on 7-1-06 Table D: extended information for both boxes and files ex. Box 10 has DOEJ 1001, BELLK 2004, Box 11 also has BELLK 2004. Inside Box 10, file BELLK 2004 is correspondence and notes, inside Box 11, file BELLK 2004 is documents and final drafts. I have set it up that the alias (DOEJ) is the primary key in Table A, and an autonumber is primary key in table B, Table Câ€™s primary key is the box number. But I am having problems joining Table D to Table B. So far I have a one-to-many enforced join from Table Bâ€™s autonumber to Table D in a number field. This works for building a relationship. But how can I set up a query/form which makes selecting a file simple? I was thinking that through a query I can build a combo box displaying the autonumber as a combination of client alias and file number ex. DOEJ-1001. Is there a way to accomplish this? Or am I approaching this wrong? Thanks for the help.