Creating Relationships Macro or Module

[SeaMonkey83]

I have a database named Testimater v1.3 and Four Tables that are constantly being recreated via a macro, so the relationships are constantly being deleted as well. I want to create a macro or module that would recreate differently named fields from Table1 and Table2. Also similarly named fields from Table2 and Table3 and Table4. It would be helpful to know how to create those relationships through a macro or module, also if it is any different to create the different types of relationships (one-to-many, many-to-many, one-to-one, etc?). I'm not a VB programmer but I can follow it most of the time, so I'd appreciate your help. Thanks.

 

[robwistar]

Sounds like something you would have to do in SQL code, not VBA. I don't know how to do it, but maybe it will point you in the right direction.