Page 1 of 1

Lookup Field with autofill from multiple tables

Posted: 2020-10-22 17:40
by SkayyHH
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

Re: Lookup Field with autofill from multiple tables

Posted: 2020-10-22 20:36
by pbottcher
Hi,

maybe you can put up an example of what you try to achieve. I did not get it yet.

Re: Lookup Field with autofill from multiple tables

Posted: 2020-10-22 21:35
by SkayyHH
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