Aptean Pivotal CRM 5.9 and 6.6 - Pivotal Table

 Aptean Pivotal CRM 5.9 and 6.6 - Pivotal Table

Nghia Song

Tel - WhatsApp: +84967324794

Email: songnghia.uit@gmail.com

The Tables by Type window is displayed with searches listed for Table, System View, and Read-Only View tables.

The primary key field is automatically defined when you create a new table and is always the first field in the table. The primary key contains the name of the table with the suffix _Id. Question. 1. Key only has 1 field? 2. How to define the relation of tables 3. If we define the relation of tables, Can we navigate from table to link table? Ex: Click Class ID in Table Student, Sys will move to Table Classes? 4. Do we have a temp table with type temporary and memory? It just receipts data in session 5. How to set up restrictions on foreign key in the table? 6. How to set a log-in table to know what is updated? 7. Could you give a sample for Don’t sync and compare sync and Don’t sync