Jump to content
Salesforce and other SMB Solutions are coming soon. ×

template help


Recommended Posts

I am a beginer at filemaker pro. I have used Access and am a beginer at it also, but am use to the way it works more. I am working with filemaker pro 7.0 and need to know how to display the contents of a table in a template, that are related to a true or false feild in the table.


for example: I have a table that has the following feilds

Workers Id

First name

Last name

Sur Name

Communities Id


Secondary Workers

Guest Workers


The "Main workers" is a Check box that has only yes as an option and I want to be able to make a report that shows only the {yes} "Main workers"


is there any one that coould help me with this?


acob Melnick

Anything Builders


177 Perry Rd.

Cochecton, NY 12720

Link to comment
Share on other sites

Go into Find mode, click into the Mainworkers field to make its value turn to "yes", hit Enter to perform the Find.



We don't generally call the results of a simple Find a "report" but there you go.


If you want to print out the results as a list, go to (or create) a List View layout for this table.

Link to comment
Share on other sites

I don't know if this is going to work. the reson is that I have a "Layout" that has to have a header and other information in difrent areas. The list of workers would be in a sub form or somthing of the like. for example in a statement you would have the information that is in relation to the customer in a lower area and the customer address and so on in the top area, making a "report" as i have called it.


so we are trying to capture the workers and the job that they are working on.


is this making sense?

Link to comment
Share on other sites

Well, you could


a) create a relationship between a value "Yes" (which could be placed into a global field or could be a constant field defined as "Yes") and the field Mainworkers. Then create a calc field, MainworkerCount, = Count(ThatRelationship::Mainworkers) and toss that field onto your report layout.


b) Do a Find for records such that Mainworkers = "Yes". Then set a global number field to 0, then loop through the found records, setting the global number field to itself + 1, go to next record, exit after last. Put that global number field onto your layout report.


c) Do the Find for records such that Mainworkers = "yes" after doing all other finds and sorts and whatnot, if that's an option. Then all you need is a calc number field, defined as Get(FoundCount). Put that field onto your layout.


d) Play with Filemaker and discover any of the myriad other methods possible for doing whatever you want. Anyone who could get the hang of Access is going to be able to do FileMaker. Seriously.

Link to comment
Share on other sites

I might not be understanding ... it won't be the first time. Do you have a child table holding the related items which you want to list? Perform a find on "Yes" then GTRR to this child table. I think your report should be designed there. You would put the worker information (from your parent table) in the header and the body would be the child items. Use your existing relationship from WorkerID to child::WorkerID. So perform your find then execute Go To Related Records [ Show Only Related Records; Match Found Set (Match All Records in Found Set) ; From Table: "child". Sub-form makes me think one-to-many relationship. Just a thought ...


Ah! Your Workers *is* your child table! Then add a leading part to your list layout, put your CompanyID in it (and be SURE to sort on it). Also include any other company details in the leading part). Workers will be the body! I think. Opps!



Link to comment
Share on other sites

thank you Ahunter3. I have not implemented your ideas but a) seems the most logical in my sircumstance.


Yes it seems to be coming together and it is vastly diferent then the way Access works (things are not in the same places), but i am getting the feal for it. the more I drudge the quicker i become.


again thank you for your help.



Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

Terms of Use