Jump to content

Adding fields from different tables to a layout


This topic is 5753 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm pretty new to working with FileMaker Pro 8.5 and am developing a database to track quality assurance and staff performance data. Examples of tables in the database include one that tracks a supervisor's completion rates on staff performance evaluations, another table that tracks the amount of time a case manager takes to write a service plan, a table for staff overtime, etc. I want to create a layout that generates an individual report for each manager's performance over a specific time frame.

How can I take fields from these various tables and place them into one layout? I'm not sure if I would have to build a relationship between each table or not. Any advice would be greatly appreciated. Thanks!

Link to comment
Share on other sites

I would suggest you read the White Paper for FMP Novices: http://www.foundationdbs.com/downloads.html

Also FM web site has several good papers on this subject. http://www.filemaker.com/help/MacTOC8.html

It sounds as though you are looking to develop a complicated relational database and I would suggest you understand the basics before proceeding. Once you have the basics down you will find that development will go a lot faster and with a lot less frustration.

I would also suggest you read Kevin Frank's papers on the Anchor-Bouy relationship graph system. http://www.kevinfrank.com/demo-files-user-group.html

I wish I had before I got started. ???


In answer to your question, yes, you need to set up relationships for all your tables, although they do not, necessarily, need to be all related directly to your main table. That's why I suggest you read the above and then if you have further questions we all would be happy to help you.



Link to comment
Share on other sites

This topic is 5753 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.