Lookup Field with autofill from multiple tables

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
SkayyHH
Veteran Member
Posts: 425
Joined: 2015-04-27 21:18

Lookup Field with autofill from multiple tables

Post by SkayyHH » 2020-10-22 17:40

Hello everybody,

I get stuck at one point.

I have several tables from which I want to call a lookup table (follow_up). When I call the follow_up table as a lookup, I want to fill some fields via autofill. I can do it with one table but not with several.

Maybe one of you has done that before?

Many thanks and best regards,
Kai

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: Lookup Field with autofill from multiple tables

Post by pbottcher » 2020-10-22 20:36

Hi,

maybe you can put up an example of what you try to achieve. I did not get it yet.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

SkayyHH
Veteran Member
Posts: 425
Joined: 2015-04-27 21:18

Re: Lookup Field with autofill from multiple tables

Post by SkayyHH » 2020-10-22 21:35

Thank you very much. I'm trying to explain better. My English is not that good ;-)

I have i.e. 2 tables:

1. Table tasks
> ID
> Employee
> Description
> Follow_Up

2. Table meetings
> ID
> Employee
> Description
> Follow_Up

Then I have a table "follow_ups". I need this as a table for all follow_up (dates) for different tables like the two tables above.

3. Table follow_ups
> ID
> Employee
> Description
> Follow_Up (date)

I would then like to call up table 3 in table 1 and table 2 from table follow_up, set a date and autofill the employee and description fields.

I hope you can understand this.

Thanks again, Kai

Post Reply