topic Re: Problem with table sync in App Development

Problem with table sync

luisguerra — Mon, 20 Dec 2021 21:02:46 GMT

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 — Sat, 13 Mar 2021 04:20:01 GMT

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

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

hth

marcus_sommer — Mon, 15 Mar 2021 14:16:58 GMT

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

- Marcus