Filemaker pro 11 Script

I have a database that has a single table ('Projects') with two table ocurrences. I have a layout based
on the Projects table. What I want to do is be able to have a user enter the number of projects he wants to look at
and the script should be able to return to a portal in the 'Project Details Layout' the employee id (s) that have
that number of projects entered by the user request. See database attached.
Thanks
Search2.fp7
PachecoPrimoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Will LovingPresident, Dedication Technologies, Inc.Commented:
When you say "the number of projects" do you mean the projectID? I don't understand whether you want the user to enter multiple project ids and see all of Employee/Project records (which is really what you have here) or something else. It doesn't make much sense to me to have the user enter "3" projects and just select three at random...

Also, for what it's worth, you probably will want to divide this into two tables, "Projects" and "Project Component". The Projects table would contain the Project ID and the name of the Project (a field that you currently don't have) and the second would contain the "Description" field (which I'm referring to as Component) along with the Employee ID, costs, start, end and comments. And, a third table would be "Employees" linked to the Employee ID.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
North2AlaskaSenior EngineerCommented:
Here is a sample I put together for another use, but it may help you with your problem.
Relation-Selection2.fp7
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.