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: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|}} |