Search results

Bumping my post and also looking for some info. I have been considering how I can get the contractor number and standard number to copy into the tblStandResults and create new values. I have created a make-table query that is based on the contractor number, so the user selects the relevant...

Thanks, I look forward to hearing from you.

Please see the db attached (i have replaced the data with generic info). As you will see, there are various standards in tblStandards - all (except the ones in use) will have a result recorded in tblStandResults to each contractor in tblContractor. All standards with StandardTypes A, B & D...

Hi Thank you for your response. The relationship diagram you have posted is how the relationships work for those tables you have mentioned (obviously the tblStandardsGroup also has a relationship to the tblStandards as a one to many). The form you have created looks like a possible solution...

Nobody got any ideas?

Hi I am looking for some help in creating a form to use for data entry. Here is my situation. I have the following tables: tblContractor (pk ContractorNum - autonumber) tblStandards (pk StandardNumber - text) tblStandardsType (pk StandardTypeID) tblStandardsGroup (pk StandardGroupID)...