Tables: tblCustomers, tblParts, tblToolRfqs
Relations: 1 to many-Customers to Parts
Forms: frmMain- has bound combo boxes for Customers, Parts(1+2), and txtboxes for PartCounts(1+2). also cmdbutton to open frmToolRfqs in add mode.
frmToolRfqs-Has txtfields set to "Format"=general number, 0 decimal points for Customers,Part1,Part2,Part1Count,Part2Count.
Notes: fields in tblToolRfqs are not related to Customers or Parts. Customer combobox on frmMain filters Part comboboxes with only chosen Customers Parts. Some times Part2/Part2Count will not be needed.
I would like to be able to fill in the combo and txt boxes on frmMain and press cmdbutton which would validate input ,open the frmToolRfqs and fill in the fields,then lock them from being edited. Any help would be appreciated. I know that table normalization would suggest seperating Part1 and 2 in tblToolRfqs through a tblToollRfqDetails, but there can be many tblRFqs scenerio combinations per project before one is actually settled on and then all the others will be deleted. Also, I may actually add one more Part/PartCount set of fields to frmMain and tblRfqs.