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

Blogs

There are no results to display.

There are no results to display.

Categories

  • 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

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

Found 85 results

  1. Here is my situation. I have a 25x25 grid - let's call it a map. Think of it like a game board, like Battleship or perhaps an Excel spreadsheet. I have a 9x9 view of this grid since it is not possible for a phone user to practically view 25x25, but 9x9 seems to work fine. And I have the concept of Current_Location on the map, which is dynamic and changes based on other factors. In TABLE1 I have records of all the "cells" in the 25x25 map that hold information about the cell (for example, the color of the cell). There is other information stored here that includes, for example, whether you can "see" other cells from this particular location in the grid. So in the record for, say, cell B5, I have a field that houses a return-delimited list of the other cells that can be "seen" from this cell (B5 in this instance). Another table, TABLE2 has records that are also have a field for Current_Location, and it tells me which cells (of the 25x25 grid) should be displayed in the 9x9 grid. Usually, the Current_Location is the middle cell in the 9x9 grid, but if the Current_Location is on the edge of the 25x25 grid, then the 9x9 view is adjusted accordingly and the Current_Location is shown on the edge of the 9x9 grid. The user can also change their orientation so they can view the map from a different direction. The way I store this information is in a field that simply lists (return-delimited) all the cell that should be shown in the 9x9 grid. So in our previous example of B5, the record for B5 has a field called Grid that is a list of the 81 cells that should be shown in the 9x9 grid. For other reasons, I cannot combine these two tables even though they both are based on the concept of relating information to Current_Location. TABLE1 is actually not as simple as described, but I'm trying to limit the scope of my question. So here is my question: I have 81 (sigh) objects on my layout for this 9x9 grid. I need to access information in TABLE1 for each of the cells that are represented in the 9x9 grid. For example, let's again assume that my Current_Location is B5 and by using TABLE2 I know the names of all the cells shown in the 9x9 grid (they are stored in a list in a field in TABLE2). How do I then get information about each of those 81 cells out of TABLE1. I.e., each of the 81 cells should be colored according to information in TABLE1. So, for the top-left cell in the 9x9 grid (which appears as the FIRST item in the list field in TABLE2), I need to be able to look up the color in TABLE1, and use it to drive Conditional Formatting of the cell. So if Color(B5)=3, then make the background color of the cell green. I can grab the cell name, and could easily write a script to figure out the color, but I need to *look up* the color to use it in Conditional Formatting. I was trying to generate another field somehow that was an analogous list of 81 items that showed the color of each of the 81 cells (in the correct order), but 1) I couldn't figure out how to do that without running a script (which would take too long since these things are changing frequently and I really just need a data lookup); and 2) I think there must be a much cleverer way. I am still very new to join tables, but I think the answer is in that arena somewhere. The other idea I had was trying to write a Custom Function since I can easily grab the name of the cell, B5. But I don't know how to create such a function since it needs to access a particular table and it seems like functions don't really work that way. Thanks in advance for any help!!
  2. 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
  3. 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.
  4. 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
  5. 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…
  6. 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
  7. 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?
  8. 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?????
  9. 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
  10. 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.
  11. 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!
  12. 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?
  13. 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.
  14. 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.
  15. 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.
  16. 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.
  17. 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.
  18. 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
  19. 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!
  20. 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?
  21. 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!
  22. 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.
  23. 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!
  24. 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).
  25. 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?
×
×
  • Create New...

Important Information

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