AboutJamey Key Expertise NEW and INTERMEDIATE USERS. WHAT CAN FILEMAKER PRO DO FOR ME? I have been using FileMaker products for over 10 years and have basic knowledge in all areas of FileMaker database set up and use. I`m not prepared to answer questions about complex situations or calculations but can help beginners and intermediate users set up and use FileMaker databases.
Experience Have been using FileMaker since 1989 in our business. We have 10 users on the network who use these databases every day. Our largest databases have had over 30,000 records at one time. In 1995 one of my files was chosen as "Most Unique Database" in a contest sponsored by Claris, maker of FileMaker. Recently I have developed a set of files for new computer system installed at our church.
Question Hi Jamie. I'm hoping you might be able to interject a few ideas in your spare
time. I've been trying to make this work for about two months no and still no
luck. I am having relationship trouble and I mean the FileMaker kind. :-P
Anyway, I am creating a database to track the knowledge base of our
employees. The goal is to have a list of the same software packages for each
employee and a unique rating of 1 to 5 for each particular package per
employee.
Layouts:
Software Package Layout: Used for entering new packages as they become
available.
Employee Layout: Enter employee info and list ALL the software packages
from the other layout, then apply a rating to each one (possibly in a portal?)
I currently have three tables:
Software with 2 fields: Software ID, Software Title
Employee with 6 fields: Employee ID, Employee Name, Software ID, Software
Title, and Rating
Competencies: was using this two join the above, but with no success joined
them directly via Workshop ID.
I believe I am looking to create a relationship as follows:
ALL WORKSHOPS = EACH EMPLOYEE = A UNIQUE RATING FOR EACH
WORKSHOP/EMPLOYEE
Any help figuring this out would be greatly appreciated. I think I am close,
but no cigar. I can return all workshops, but cannot get the rating to be
unique. I either end up with the 1 rating being the same for all employees or
all workshops.
I have the file in progress if a visual would help.
Thanks,
Steve
Answer Steve;
Im sorry it has taken so long to get back to you. I did send an answer, but i must have not submitted it correctly because it didnt get to you. If you will email me, I will make a small sample and send it over to you so you can inspect it. Send to jameykey@jkat.com
