How to change the link field to a specific field

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
dlee
Veteran Member
Posts: 137
Joined: 2020-04-14 00:21
Location: South Carolina, USA
Contact:

How to change the link field to a specific field

Post by dlee » 2023-05-31 21:33

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

dlee
Veteran Member
Posts: 137
Joined: 2020-04-14 00:21
Location: South Carolina, USA
Contact:

Re: How to change the link field to a specific field

Post by dlee » 2023-06-01 15:59

Anyone?

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: How to change the link field to a specific field

Post by jsetzer » 2023-06-01 17:14

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.
Kind regards,
<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 readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

Post Reply