ExecSQL - New to this Wondeful Filemaker World
Sorry if this was asked before...; I'm new using EXECUTESQL function.
I have two joined tables, one for Training and the child one for Employees. I would like to Automatically retrieve data (Such as name, function, etc ) from Employees Table based on drop down list in the Training one (the list is related to Employees ID).
Thanks in Advance.
You'll need to describe what you have and what you want to do in more detail--especially since what you describe may not be a good place to use ExecuteSQL. If you have the right relationship defined in Manage | Database | relationships, maybe all you need do is put a portal to employees on your training layout.