A few things here, first, my focus for this thread is FORM: F3Engineering.
1. I was wondering how the database structure looks. I used to have fewer TABLEs. T3ENG used to contain all of the information for T3BatchPrice, T3EngineeringCost, T3EngineeringSpecs, and T3EngShopCapes. Those all used to be one TABLE. Each record in T3BatchPrice, T3EngineeringCost, T3EngineeringSpecs, and T3EngShopCapes are going to be unique to the same record in T3ENG, so I was wondering if the way that I was setting this up is the right way. Your thoughts and suggestions would be most welcome.
2. I have been having difficulty with adding data to certain controls on FORM: F3Engineering. These would be the Specifications, Capabilities, and Batches; the fields appear to be locked for some reason. I can change information in ENG Cost fields on the form for record 1, but I cannot add information on Record 3. The source of this problem began when I split the tables up from a single "FAT" table to several smaller ones. I can fix this issue by going back to my old ways, but there must be some solution for making this work the way that the community suggested that I do things.
Thanks
bytreeide
Database attached