Trace:
Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
visionx:masterdetail_nofk [2020/03/09 11:22] admin |
visionx:masterdetail_nofk [2020/03/09 11:26] admin |
||
---|---|---|---|
Line 37: | Line 37: | ||
{{:visionx:masterdetail_tables.png?nolink|}} | {{:visionx:masterdetail_tables.png?nolink|}} | ||
- | The data area contains the Projects table (1) and the Tasks table (2). Now we need to create a relation between the Projects and Tasks table. To achieve this edit the Tasks table (1) and Show more (2) options: | + | The data area contains the Projects table (1) and the Tasks table (2). Now we need to create a relation between the Projects and Tasks table. To achieve this: |
{{:visionx:masterdetail_edit_tasks.png?nolink|}} | {{:visionx:masterdetail_edit_tasks.png?nolink|}} | ||
- | Enable Database changes (1) and Navigate to the Projects Id column (2). Press Define Combobox (3) | + | edit the Tasks table (1) and Show more (2) options. Next, enable Database changes (1) and Navigate to the Projects Id column (2). Press Define Combobox (3) |
{{:visionx:masterdetail_edit_tasks_dbchanges.png?nolink|}} | {{:visionx:masterdetail_edit_tasks_dbchanges.png?nolink|}} | ||
Line 49: | Line 49: | ||
{{:visionx:masterdetail_edit_tasks_projects.png?nolink|}} | {{:visionx:masterdetail_edit_tasks_projects.png?nolink|}} | ||
- | Now we have a relation between Projects (ID) and Tasks (PROJECTS_ID). Be sure that you pressed Finish. No worries, the database won't be changed in this case.\\ | + | Now we have a relation between Projects (ID) and Tasks (PROJECTS_ID). Be sure that you press Finish. No worries, the database won't be changed in this case.\\ |
\\ | \\ | ||
As final step, we have to define the master table reference. Start the edit Tasks table wizard once again and set the Master Table to Projects (1): | As final step, we have to define the master table reference. Start the edit Tasks table wizard once again and set the Master Table to Projects (1): |