Problem with table sync

[luisguerra]

I have to similar tables "Current records" and "History records" both have two similar fields

Id_user and Id_course both need to join with a table call course_catalog using the id_course to show the name course and other data.

If I unqualify both fields the process create a Sync table, but i dont wan that. 

[ArnadoSandoval]

Hi @luisguerra 

There is a simple way to handle this scenario, follow these steps:

1. Rename the column; Id_course to Id_course_h in the History_records table.
2. Add a second column with the Id_course to the Course_catalog table, and renamce it to Id_course_h
3. The table will be associated as expected without any synthetic table.

hth

[marcus_sommer]

Why not simply skipping the qualify-stuff and concatenating the current and the history table by unifying the fieldnames?

- Marcus