Merging Two Completely Different Tables
Greetings, I couldn't delete this post so, I am just completely modifying it, for anyone who navigated their way back to this and is thinking, "This isn't what I was looking for". lol I have two...
Forum Discussion
Are you really merging data or does a relationship between the two tables solve your issue?
For example you can have a Project Table and Group Table
In between them you put a Project Groups Table.
The information from Projects and Groups is used in the third table but is not actually merged into. Changing a Project Name automatically updates the Projected Groups related to the Project.
Will that do what you need?