Richard, I would like to see a database with more many-to-many and one-to-many tables. In your example there are only 2 of many to many . what if you have 10 of many on many, it is difficult to place 10 forms - subforms on 1 form.... to complete a record. Or do I have to split my input per part to enter and not everything in 1 form with the necessary 10 combo boxes with the necessary one to many fields. would like your opinion on this.