I'd like to use Access to create electrical construction estimates with professional looking bid documents to send to clients. I currently use Excel and Word for this process and it sucks.
I'd like to start by creating forms that I can fill out that will have combo boxes of various "Assemblies" I can select and add quantities and labor factor to. Each "Assembly" will be made up of individual parts. Each part will have an associated cost and labor component, and each part selected as part of the assembly will have quantity unique to the that assembly. Like an outlet box will have 20 self tapping screws. Each screw costs $.06 and takes .0005 hours to install.
I've created a material table with part cost and labor fields. I then created an assembly table that simply has the ID and the name of each assembly. I know I need to create a many to many relationship with a junction table, so I created an AssemblyJunctionT with the two foreign keys and a field for quantity that is unique to the relationship between the part and the assembly. When I go to do the query and create a form for simplifying filling this out I get stuck. I can draw it out out on paper but I can't seem to figure it our on Access.