copy table as many times as related fields ex-> name of copies same as related fields
Hi everybody,
I have a question.
I have a table, which is called "x". That table is related to several fields in another table "y" , say the fields are called "1", "2" and "3".
Is there a VBA code, which asks for the desired table to choose, then creates exact copies of the table as many times as relations exist, BUT every copy of the table needs to have the exact name of the related field (in my example, just "1", "2" and "3".
Best would be, if the VBA code gives the possibility for multiple tables to choose, and then does the desired procedure with every table one after another.
I would be thankful for everybody who could help me out with some code, thanks!
Hi everybody,
I have a question.
I have a table, which is called "x". That table is related to several fields in another table "y" , say the fields are called "1", "2" and "3".
Is there a VBA code, which asks for the desired table to choose, then creates exact copies of the table as many times as relations exist, BUT every copy of the table needs to have the exact name of the related field (in my example, just "1", "2" and "3".
Best would be, if the VBA code gives the possibility for multiple tables to choose, and then does the desired procedure with every table one after another.
I would be thankful for everybody who could help me out with some code, thanks!