I have two tables that both have the field growerid in them. I need to link the master-detail using the field growerid; how can I do this?
Thanks, TD
How to change the link field to a specific field
Re: How to change the link field to a specific field
Basis lookup functionality of AppGini:
https://bigprof.com/appgini/help/workin ... kup-fields
This is just my personal recommendation for naming columns. As you can see I am not using identical column names when designing lookups. But this is up to you, of course.
Master.id is primary key.
Child.id is primary key.
Child.master_id is foreign key / lookup to Master
After generating code you will have a master-child relation in User Interface.
When editing a Child, you will be able to select a Master.
When editing a Master, you will be able to insert Children.
https://bigprof.com/appgini/help/workin ... kup-fields
This is just my personal recommendation for naming columns. As you can see I am not using identical column names when designing lookups. But this is up to you, of course.
Code: Select all
Master
id
column2
...
Child
id
master_id
column3
...
Child.id is primary key.
Child.master_id is foreign key / lookup to Master
After generating code you will have a master-child relation in User Interface.
When editing a Child, you will be able to select a Master.
When editing a Master, you will be able to insert Children.
Kind regards,
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
[code]...[/code]
blocks for better readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools