Documentation

Trace:

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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):
This website uses cookies for visitor traffic analysis. By using the website, you agree with storing the cookies on your computer.More information