Forms Designer Forum

We are building a training database. Consisting of three lists:

1. Personnel - Listing of all employees
2. Qualifications - Listing of all qualifications
3. PersonnelQuals - Listing of individual qualifications held by each employee. One employee can have many associated qualifications. Each record relates to 1 employee and 1 qualification. The form is to have lookups on the Personnel list (by employee name) and Qualifications list (by qualification name).

I want the qualifications dropdown to filter out any qualifications already associated with that chosen employee. Is that possible?

Hi,
Are you using Forms Designer for the PersonnelQuals forms?

Dmitry Kozlov wrote: ↑

04 May 2017

Hi,
Are you using Forms Designer for the PersonnelQuals forms?

Yes I am using Forms Designer.

Wondering if anyone's able to help me with this? Or is it not possible with Cross-site lookup & Form Designer?

Hi,
Our support team can implement a script that filters a Qualifications drop-down in the PersonnelQuals form so that it will display only those items that are not associated with a selected employee in another drop-down. The script will take 3 support hours. If it's OK, please, purchase the support hours in our store:
https://spform.com/buy/support-maintenance

Then provide temporary access to the PersonnelQuals form.