Search results

CJ, Thanks for your input. I tried to use your code with changes to table name & field name to suit my need. TableDef was identified during compile as unknown function. I rearranged the code the way I know it works to get past that compile error. Then I found that the Select Inset statement that...

I have not been able to successfully apply above code perhaps due to my limited knowledge in VBA. I would appreciate if you could provide a more refined code.

Yes they are too many. Each table has different fields which is why I could not come with any simplified way of doing it. Each table have its own form which is added as a subform on the Master form. So all the data are tied to the Job No and Rev No. Can you think of any other way of doing it...

Scenario: I have "Master" table with fields "Job No" and "Revision No". Both together is a primary key, so that combination of both cannot be duplicated. I have 100 other tables to be related with referential integrity(+update&delete) to Master for both fields. Apart from Job No and Revision No...