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:20]
admin
visionx:masterdetail_nofk [2020/03/09 11:22]
admin
Line 2: Line 2:
 ~~Title: Use Master/​Detail without Foreign Key ~~ ~~Title: Use Master/​Detail without Foreign Key ~~
  
-Usually, VisionX creates Master/​Detail relations with Foreign Keys in the database, e.g.+Usually, VisionX creates Master/​Detail relations with Foreign Keys directly ​in the database, e.g.
  
 {{:​visionx:​masterdetail_fk.png?​nolink|}} {{:​visionx:​masterdetail_fk.png?​nolink|}}
Line 17: Line 17:
 {{:​visionx:​masterdetail_nofk.png?​nolink|}} {{:​visionx:​masterdetail_nofk.png?​nolink|}}
  
-The foreign key is missing in the database. But no worries, it's still no problem to create a screen with a Master/​Detail relation as shown above. Best would be, to create a new empty screen (2):+The foreign key is missing in the database. But no worries, it's still no problem to create a screen with a Master/​Detail relation as shown above. Best would be, to create a new empty screen (1):
  
 {{:​visionx:​masterdetail_newempty.png?​nolink|}} {{:​visionx:​masterdetail_newempty.png?​nolink|}}
  
-Next, lets include the table objects. Start by creating a new table (2). The new table wizard will appear:+Next, let us include the table objects. Start by creating a new table (2). The new table wizard will appear:
  
 {{:​visionx:​masterdetail_newtable.png?​nolink|}} {{:​visionx:​masterdetail_newtable.png?​nolink|}}
This website uses cookies for visitor traffic analysis. By using the website, you agree with storing the cookies on your computer.More information