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
Lookup Field with autofill from multiple tables
Re: Lookup Field with autofill from multiple tables
Hi,
maybe you can put up an example of what you try to achieve. I did not get it yet.
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.
Re: Lookup Field with autofill from multiple tables
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
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