I have a form that looks up job titles and puts them into a table. It is pulling form a staff listing, so some items are duplicated. Is there a way to just pull the first unique title, or delete the duplicate titles?
This should probably be handled with the query rather than on the form side.
You could do it with a View or Stored Procedure that incorporates SELECT DISTINCT.
You'll want to set up a separate query rule to Select only the Job Title column, and set the Quantifier to "Distinct".
Then you can pull the unique Job Titles into your form using that query, and use your other/main query to fill in the remaining columns where Job Title equals Job Title.
Let me know if you want me to explain a bit better and I can spam you with some screenshots to show what I mean. :)
Editing to add: Sorry, wasn't thinking clearly - You should be able to add the other columns to your query as well, assuming that all of the other information matches & is unique to the job title. You just wouldn't want any unique/individual staff information as that would repeat rows. Hope that makes sense!
I haven't played with stored procedures before. Always something new to learn. Thanks.