Page 1 of 1
How to change the link field to a specific field
Posted: 2023-05-31 21:33
by dlee
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
Re: How to change the link field to a specific field
Posted: 2023-06-01 15:59
by dlee
Anyone?
Re: How to change the link field to a specific field
Posted: 2023-06-01 17:14
by jsetzer
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.
Code: Select all
Master
id
column2
...
Child
id
master_id
column3
...
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.