Jump to content

Search the Community

Showing results for tags 'relationships'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 85 results

  1. Hi, I believe I'm having a problem with an unidentified key concept. I hope to get pointed in the right direction. I am attempting to build an English horse racing form here in Tokyo. I import all the data from Excel and am working from a single table (I believe this might be the root of my problem). I did a few tutorials and I felt pretty comfortable with the basics. At my first attempt (and I thought it was strange at the beginning), I gave every piece of info that would appear on the form its own field. With a possible 18 horses running in a race, and 5 lines of past performances per horse, I ended up with almost 2,000 fields. I filled in each past performance line through look-ups from the race id. It was pretty cool and at the same time obviously wrong. So I bought FMP12 The Missing Manuel, and while I feel as if I am getting through the text well enough (I can build an invoice!), when I come back to my project I have been lost -- to a point of great frustration. I moved to trial and error for a few days and decided to come here. I have attached a sample form I borrowed from the Daily Race Form (and simplified it) to show what the end product would look like. I see it as a Mast Head, 18 Sub-headers (1 for each horse), and then 5 lines of past performances for each horse. To get away from 2000 fields I figured I must have multiple TOs (18?) of the single table I have, then I figured I need portals for each horse to display the 5 past performances. I've been working this angle to no avail and figured I must not have grasped a key concept. From what I've written -- is the missing concept apparent? Thanks, Paul race_form_model.pdf
  2. Hi, im searching for a solution which will let me save the relationship history of records. I want to have something similar like a "snapshot" of every record if it gets modified. in my example i want so save which employee had which jobs and childs over time, so i can view the past history of a specific employee. What do you think will be the best solution for this problem? Thanks in advice.
  3. Surprise, surprise. I am also a newbie but hopefully I have a softball question for someone just lurking around. Okay, so I originally built a solution for our church directory with the following schema: FAMILY _kp_family_id _kf_member_id last name MEMBER _kp_member_id _kf_family_id first name It was structured like this so that we could do a printed directory page and make use of the portal to just list the first names and their personal cells, email, etc. Now, I'd like to take that solution and also integrate an Attendance chart so that we can take attendance using FileMaker Go and an iPad. This is where the extent of my knowledge begins to be stretched. My goal is for every unique service (Sunday Morning, Sunday Night, Tuesday night, Saturday afternoon, etc.) to have a list that has every members' full name (last, first) and then a group of radio-buttoned statuses next to each of their names. It will look, ultimately, like the attached pdf. I color coded items that I'm guessing will come from a unique table. Will you please help me sort this out? Thank you, Jason Attendance.pdf
  4. Using an auto-enter calculation on a field is a great way to populate its contents when other fields are modified, including itself. But what do you do if you want to use a calculation that references itself without having it trigger its own auto-enter calculation? The answer lies in thinking outside the calculation.... Read the Full Article Here…
  5. Hi i created a database for a food manufacturing company, they need to be able to link the product with the company that ordered it with its ingredients and be able to link on e to another. i created it that from the product you can select a value list of the company that ordered it , i created a relationship. however every time i create a new product and assign it to a company a new company is created. i assigned automated id`s so i cant even link them together. please help me
  6. Here is what I am doing from an excel spreadsheet Record 1 Program XXX Staffing Requirements Jan Feb Marc Apr May June Jul Aug Sep Oct Nov Dec 1.2 1.2 1.2 1.2 1,0 1,1 1,1 .9 .9 .9 .8 .7 Staffing .7 .4 .5 .5 .9 .8 .9 .5 .5 .5 .6 .5 Employee 111 .5 .8 .7 .7 .1 1.1 .2 .4 .4 .4 .2 .2 Employee 222 So it adds up to the requirements. I then want to pull an employee report that shows all the programs and total hours they are needed for. Woudl also like to pull program reports Can somebody get me started?
  7. Hi. I'm using FMPro 12 Advanced. Creating a database for our community centre and I need to add a membership number to contacts - but not all of them. I've created a separate table for Membership numbers (as not all contacts will have one, so serial numbers aren't appropriate). Each membership has a number of details fields. It's probably a REALLY logical and stupid problem I'm batting against - but I need to: Select a contact>go to their details>add a membership number (go to a floating window layout, enter the details to the serial-number-derived membership) and have the details including the number show up in a tab on the contact's details layout. I've created a relationship between my contacts file and my membership file via the Contact_ID>Contact_ID_fk and have played around with other relationships. I've also created a simple script from a button on the Contacts membership tab to go to the Membership Layout window and create a new record. But it keeps creating a new record in the Contacts, not Membership - even though the relationship only has to create new records in the memberships side. I'm now running around in circles - please can anyone help me out here?????
  8. I am setting up a sustainability assessment database and am new to FMP, and although I have worked through many of the main basic requirements, I seem to be stuck on how to connect one record in the 'clients' table and one in the 'indicators' table so that the join table, called 'client indicators' will show which clients have had which indicators assessed. I have the portal set up on 'client indicators' layout, but I can change the client and indicator records on the 'client indicators' layout. I need the client/indicator relationship to be static. I have 91 assessment tables to use eventually, having begun my development with EC01 Indicators to begin with. Is it my relationships setup or the dropdown lists? relationships.tiff GreenBusiness.fmp12
  9. Hey guys, I could use some help. I'm setting up a database and I'm a little stuck. I need to create a database with 90 records (machines), and each of those 90 records need 288 subrecords (positions on machines), and each of those subrecords need another subrecord to display info about said position, and I have no idea how to set this up. Currently I have 3 tables MACHINE POSITION POSITION_CONTROL I created 288 in the positions tables because theres always 288 positions. The user needs to select a machine, then a position on the said machine and then access the control sheet of the said machine on the said position.. Is there any other way to make this work other than creating ~25000 records manually? Any help whatsoever is appreciated.
  10. I've set up a database for my organization that can take our total client file (about 20,000 records), drill it down using finds to a targeted list, and export that to a spreadsheet. Easy enough. I would like to have the value lists of several fields dynamically update in find mode. For example, if I had the following geographic fields: State County Town Zip Region (we've already defined this) If I select state and region in find mode, I'd like for the drop down lists for counties, towns and zips to only include those values that are in the correct state and region. Basically, I want the current value lists for any of these geographic fields to reflect the most up to date constraints based off of the selected queries in find mode. All of the information is in one table, and I don't see any easy way to split it into several tables. Can someone help me out on how to do this using a self-join relationship? I haven't been able to get conditional value lists to work at all, even on the most basic level, so a step by step guide with specific instructions would be incredibly helpful. Thanks!
  11. I would really appreciate some input on this, as I think I've got lost along the way trying to figure this out and whilst I have a working solution it seems somewhat convoluted (and is a bit sluggish to update)... I needed to create a report from the context of contacts so that this can display sub-summary data (sorted by contact::area and contact::category) of related survey data for each contact from the single most recent survey record (within a specified report date range) as well as count how many survey events took place in that date range. Because of the context, I concluded – perhaps wrongly – that I couldn't simply put the required summary fields in the surveys table and instead needed to pull the appropriate survey data for each contact into the parent record, then add the summary fields in that table. To do this I've added a bunch of un-stored calculation fields, namely: 1) wasOpen – since I'm working with all contacts records, this evaluates whether the contact was added after the reportEnd date or closed before the reportStart data and should therefore be included (1) or excluded (0) 2) mostRecentSurvey – calculated using ExecuteSQL( "SELECT ''||surveyDate FROM data JOIN contacts ON fk_contactID = contact_ID WHERE fk_contactID=? AND surveyDate<=? ORDER by surveyDate DESC FETCH FIRST ROW ONLY" ; "¶" ; "" ; contacts::contact_ID ; globals::reportEnd ) and used to create a relationship to a single survey record – contactID = fk_contactID AND mostRecentSurvey = surveys::surveyDate 3) survey_Q1 – answer to first question in related survey multiplied by the value of wasOpen so will only have a value if the contact is being included in the report 4) surveys_carried_out – calculated using ExecuteSQL( "SELECT COUNT surveyDate FROM data JOIN contacts ON fk_contactID = contact_ID WHERE fk_contactID=? AND surveyDate>=? AND surveyDate<=?" ; "¶" ; "" ; contacts::contact_ID ; globals::reportStart ; globals::reportEnd ) as this needs a figure for each contact whether it is included or excluded from the report. 5) summary field, total of survey_Q1 6) summary field, total of surveys_carried_out etc (There are obviously other survey questions/dates being pulled in to the parent and summarised in the same way) So when I set the global reportStart/reportEnd dates, goto the report layout, find all contacts and sort by contacts::area and contacts::category I get the required sub-summarised results, but I just feel I'm missing something and there is perhaps a better, more efficient approach... Thoughts?
  12. Ah, okay that makes sense! Thanks so much for all your advice. Okay, my next issue is as follows.... So I have a layout for 'Tracking Sessions' which contains details of each time someone went out to find a particular individual/group of cheetahs. Within this layout, I have a Tab that contains different portals to different tables of information that could be (but not always) collected during a specific tracking session (e.g. kills found, supplemental feeding, and 'Tracking Notes'). Now, because of the Join table how can I set these portals up to allow for record creation in these child tables while also creating the necessary records for the join tables? I've included a screenshot of the layout. Everything under 'Kill Details' is contained within a single portal row, as there is usually only a single kill during a single tracking session (though I guess in theory there could be more than one at some point in the future). From my experience and what I've read, you can't place a portal within a portal so how do I solve this issue while maintaining the current format (or if there is a better way of doing this, I'm all ears!) I've also included an updated screenshot of my relationship table, so you can see where tracking sessions lies in relation to kills and cheetahs.
  13. I have the following: Table 1 – Expenses Field A: Date Field B: Concept Field C: Amount Table 2 – Flight Time Field D: Date Field E: Flight Time (in hours) I need a report that will give me the expense cost per hour, i.e. the total of Field C divided by the total of Field E. Table 1 and Table 2 are not related. What relationship must I establish between them to obtain my desired result? If establishing a relationship between the tables is not the answer, how else can I achieve the figure I need? Thank you for any help that can be provided.
  14. Hello I'm pretty new to Filemaker.  I'm using FM 13 Advanced.  I've taken 2 courses on filemaker on Lynda.com.  I feel that I've got a good grasp on the application, but I'm certainly still new, and still learning  I am designing a database for my group insurance business.  I'm working on the Relationship Diagram, and I think I have most of it sorted out, but I've run into one problem.  I'll start by describing how the DB will work.  Each one of our Clients will have a minimum of one Policy.  Each Policy will be through an Insurance Carrier.  Each Policy will consist of the lines of benefits that the Client has chosen (ex. Life Insurance, Health, Dental, etc.)  Also each Policy will have a minimum of one Class.  Roughly 80% of all policies will only have one class. 18% will have 2-3 and 2% will have 4+.  Each Policy will have rates associated with them and a date that the policy renews.  Every time the Policy renews, the rates are likely to change.  99% of the time, the rates will be the same for every class in the policy, however, it is possible for each class to have its own rates.  We need the database to track the rate changes in the policy every year.  Also, the Clients are able to change the lines of benefits their Policy covers at any time (ex. changing the amount of coverage, adding new lines of benefits)  We also want the ability to take notes on our Clients and their policies. I've attached A diagram of what I have so far.  The issues Im having is with the Policies/Renewals/Classes relationship.  The biggest problem i'm having is where to store the rates, so that they can be tracked each year, and can also be different for each class.  Any help/advice/suggestions would be greatly appreciated.
  15. I'm having trouble generating a list of transactions (using list view) that are attributed to a given Client. The aim is to have a button on the Client Details layout, that takes me to a List view (Transaction History), where I can then filter the transactions by date, and balance, for all horses owned by the client. (The transactions relate to invoices generated when their horses are treated). I have the date/balance filters sorted. The problem is that when I select the button on the Client Details page(that takes me to the List view, I am getting a list of ALL transactions for all horse owners, no the ones related to the Client I am currently viewing. I suspect there may be a problem with either, or both of, the table I am basing the List view on, and/or the way I have set up the relationships in the graph. Obviously, a subsequent problem with the script I am attaching to the button that takes me there, also. Here's a snapshot of the relationship graph, the script, and the final list view. Below is the final Transaction list view, but is showing (incorrectly) transactions for all horses, for all owners, however, the Owner name that appears in the merge field at top, in this case "Tania Drever", is correct. Should I simply use the value of "Invoice To" to act as a filter, within the script? Or do I need to change an aspect of the relationships graph to have this work properly? Thanks in advance.
  16. I am trying to chart and analyze sale data. In particular, "Most popular product(from a specific product category) this quarter/month/year/etc" and things of that nature. In this database there are several tables: I will try to explain how they are linked Sales Order -Sales Order Line Item --Product Product Category -Product --Sales Order Line Item For example, I want to see the most popular product during a certain fiscal quarter do do so, I need to filter the line items by the following criteria and then have a calculation of the sum of found line items grouped by product * order quantity: Based on the tables this criteria needs to be met: SalesOrder::OrderStatus /= "Open" (not equal) (i.e. closed/completed orders) SalesOrder::Year=CurrentYear SalesOrder::Quarter = Fiscal Quarter(or can be month or can be omitted entirely) Product::Category="my category"(whatever) I've tried many solutions and getting somewhat close, but I get stuck with Un-Index-able match fields(keys) dues to calculations from related tables or circular references. Any tips would be great. Lastly, I think I can accomplish the same thing with a script and perform multiple searches against the LineItems based on related tables, but wanted to know if there is a more direct way via the relationship graph. I'm happy to provide more details if needed. Thanks in advance.
  17. I am struggling with something that should be simple, but cannot figure it out. Below are three tables: Contacts, MaterialsTransactions, and MaterialsTransactionLineItems Within a layout showing records from the Contacts table, I created a portal showing records from MaterialsTransactionLineitems (so contacts could see each item and not just each transaction) Layout = Contacts Table; Portal = MaterialsTransactionLineItems The field on the left is MaterialsTransactionLineItems::Transaction_fk; the field on the right is MaterialsTransactions::TransactionDate Given the relationship, why is the date not showing correctly? Instead, just showing first record for all? Is it the relationship, or the way I have created the portal... both? Thanks
  18. Creating a pilots logbook database. I have a layout where you enter things like the date, the type of aircraft flown, its registration etc. I want the details of the aircraft (registration and type) to be linked (or have a relationship to) another table. The reason is I want to eventually auto-populate some fields so when the person types in 'KKK' the database recognises KKK as a C172. Another reason is to keep the aircraft types uniform when searching in other layouts as you can write C172 also as C-172. How would I go about this? Cheers!
  19. My name is Alberto and I'm new to the forums so excuse me if I miss important information on my question. I will try to be as accurate as possible. Ok here it goes I have two tables joined via a relationship. Table A (Records) and Table B (Forms). The relationship is setup via a global field in Table A (t.record.id) = field in Table B (t.form.name). I have a button that performs a script that sets Field (t.record.id) in Table A (Records) to the form name I want related info from. Then the script goes to a layout based on Table A (Records). At this point is where I can't figure out why if I place a field in the layout for t.record.id I get the value set by the script but when I place a field for t.form.name the field is blank along with any other fields from Table B. I have checked the data on Table B and there is a value on t.form.name = to the value being set by the script on t.record.id just unsure why the relationship is not happening. Also t.form.name is a calculated text field from 3 other text fields in Table B (Records) indexed minimal (as necessary) and as mentioned before t.record.id is a global text field being set by the script. Any ideas on what might be happening or where am I wrong or any steps that can be taken to troubleshoot the issue?
  20. Hi There, Can somebody please assist me on extending the projects starter solution to implement on the existing Projects, Sub projects with Sub Tasks - This is for the reason that some Projects are very broad and there is need to break them down into sub projects which also will constitute sub tasks. Will appreciate all guidance and thoughts shared, Many Thanx, Miss A!
  21. Is there a limit to how many fields a table should have? My solution requires the management of 6 categories. Each category has up to 34 sub-categories, although most have 9-12, and each sub-category has several items requiring data entry. This leads to 91 sub-categories and hundreds of fields requiring data entry. The records per sub-category require relationships to corresponding sub-categories that respond to the data recorded. It is like a question/answer system, so the initial question field has data entered that requires answers entered and/or available (from previous experience) in the corresponding answer table. I have been thinking that I need to have the 91sub-categories in their own tables to limit the number of fields per layout. Is this a limitation? Is there anything wrong with having loads of fields in one table? Each of the 91 sub-categories will need to be related to the entity asking the question and receiving the answer. The questions and answers will eventually be presented in a report. In the future, when the answers have been acted on, the process is redone using the same sub-categories and the latest report is used to show progress, or otherwise. I could create tables for each main category and split the one with 34 sub-categories into 3, making 8 tables populated with the fields from the sub-categories which would result in approximately 50 to 100 fields in each table.
  22. hey guys! Im having some real trouble working with a relationship and portal... i have a table that keeps records of my reptiles: Record_ID - auto serial Record_Date Reptile_IDCode Reptile_Nickname Then I have a table that keeps track of different types of Morphs (color and pattern variations): Morph_ID - auto serial Morph_Name Morph_genetics so one reptile can have one or more different morphs related to it, on the form showing reptile records i would like to show a portal listing the morph(s) relating to that specific reptile. is there a way to have this listed on the main reptile form? will i need to create another instance of the morphs table? any help is much appreciated!
  23. I have a table which is related to another one. Trying to keep it simple lets say one is a table of cats (first table) which has fields for cat species, colour, weight etc. I can also record the details of when I bought the cat, price paid etc. It is linked to another table where I record all the prices of cats I can find (second table) and they're matched according to species and colour. I create a report based upon a time period using the first table and by doing a find of records which match certain criteria I wish to includewhich shows certain data for example: min price, max price, av. opening price, av. opening price. The report doesn't need a script it is simply another layout which pulls the data from certain calculations fields some of which are based upon the other table (eg a summary field). The problem is the table (first table) picks up references to any cats given away (eg $0) as part of its minimum search and I only want to include cats whose price is at least $50. Also, I wish to exclude the $0 values in the summaries of average prices in the second table. I suppose what it comes down to is how can I ensure 'summaries' never include 0 values without just excluding them from the DB altogether (I could do a find on the price field for $0 and then delete all these records).
  24. I'm new to Mirrorsync and have a question about what setting up primary key relationships does during configuration. When setting up a new sync and matching primary keys, if I am unsure of all of the table relationships is it ok to just ignore those relationships and then add them later in Filemaker Manage Database? Does setting it up at the mirrosync config level change any scripts or anything else I should worry about if I later add relationships between tables in Filemaker?
  25. Hi, Â I am designing a FM12 database to allow people report their progress of work. I've seen a database design that allows customizsation by the users (not just admins) to create their own question templates, which will then appear in a separate reporting page for users to fill in. Building on this design, I wonder if it is possible to give users the ability to choose which questions they would like to answer. I am however at a loss as to how to create the relationships and designs to achieve such functionality, and would really appreciate your expertise in the matter. Â From the database design I've seen, the users can essentially access a layout to create a template of their own quesitons by typing in the question, and assigning the answer type: text box, radio button, check box. For the latter two, the user will also need to provide the available options. For example in the screenshot below, Q3a is set to answer with text box, while Q3b is set to answer with radio button: Â 3a: Â 3b: Â The selections: Â In a separate layout designed for users to report their progress, all the questions, in their designated format (text box, radio buttons with options, etc.) are presented to the users to be filled in. Following with the previous example: Â 3a: Â 3b: Â This flexibility would be hugely useful to the database design. However I'd like to take it a step further, if feasible, by allowing users to choose which questions they would like to answer. For example, the user may want to answer only 3a but not 3b due to lack of information. The design will allow users to create a record, choose one question from a full list they would like to answer, which then automatically presents the chosen question with its answer box in the correct format (e.g. text box, radio button) to be filled in. Â I would really, really appreciate you and the community's help and guidance on creating the relationships and designs of such a system, even if it is only the first part. Many thanks for your time and help. Â With best regards, The MacGuffin
  • Create New...

Important Information

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