iamthebestuk
Technical User
I have a 'Main Table' which gets updated every month with three other smaller tables (smaller in terms of records).
My problem is that the smaller tables may not necessarily have all the fields of the 'Main Table' or may not be in the same format (ie. datatype, field size, indexed) and/or in the same order.
So I'd like to create a macro that cycles through the 'Main Table' storing the field names, formats and order then changing the three smaller tables to reflect the design of the 'Main Table'.
Help welcomed.
Power is Knowledge
Knowledge is Power
My problem is that the smaller tables may not necessarily have all the fields of the 'Main Table' or may not be in the same format (ie. datatype, field size, indexed) and/or in the same order.
So I'd like to create a macro that cycles through the 'Main Table' storing the field names, formats and order then changing the three smaller tables to reflect the design of the 'Main Table'.
Help welcomed.
Power is Knowledge
Knowledge is Power