Jump to content

Search the Community

Showing results for tags 'relationships'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New Claris Platform
  • Community Resources
    • Community Videos, Tips, & Techniques, Articles.
    • FileMaker Marketplace Discussions
    • FileMaker Videos
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro 19
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Proof+Geist
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
  • FileMaker Friday Night Chat's Topics


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • 1-more-blog
  • Productive Computing
  • Geist Interactive
  • Soliant Consulting


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

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development
  • FileMaker Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

  1. Confused on how you should set up your relationships in FileMaker? In Day 1 of this Livestream, we slowly and methodically cover Claris' officially recommended relational design process, Anchor Buoy! Future live streams: https://fmtraining.tv/#LIVE support@rcconsulting.com www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com
  2. I'm not even sure to describe under which category my specific problems fall into, I can only advance some hypothesys, so I'll just describe it and let the wisdom of others guide me. I have a DB with several tables, I use them to make invoices. With every invoice I input the desired price and it adds automatically 19% taxes and produces a neat invoice which I can print, these three tables are called: Invoices 2018 Invoices 2019 Invoices 2020 Now on to my problem. I wanted to create a forth table where from every previously listed table it would calculate the total revenue of the year in question, broke down like this: - Total Net price paid for 2018 - Taxes for 2018 - Total revenue for 2018 (net+taxes) - Total Net price paid for 2019 - Taxes for 2019 - Total revenue for 2019 (net+taxes) - Total Net price paid for 2020 - Taxes for 2020 - Total revenue for 2020 (net+taxes) I am unsure how to proceed, I tried creating a forth layout and a new table but I have problems brining the summary field from each year's table into the forth table/report/layout.
  3. The tables. Items::ID Items::Item Items::Publisher Items::Date The Genre data is already arranged like this: Genre::ID (Unique Key) Genre::Name Genre::Category_ID Genre::Category The Platform data is 'simple'. ID and Name. But each item could be multiple platforms. (Example #1 vs. Example #2) Platforms::ID Platforms::Name An item can have multiple Genre Categories related to it, and those usually have a single choice from within their Category, but might have multiples. It's supporting the possible multiples that I'm trying to work out. At this point there's 15 possible Genre Categories that each Item could have a selection from. Most have 4-6 of them. Example 1: Items::Table on the left, Genre::Table on the right, with some Genre Categories (Genre, Perspective, Pacing, Gameplay, Interface, Setting) and their sub-options. This one has just one sub-option per category. Example 2: The Gameplay Genre Category has two sub-options related to it. Example Genre Table content: Just cracking the surface on One to One and One to Many relationships, I don't think this scenario is quite covered this way. Would each of those Genre Categories be portals showing only their related category ID? I presume that I would add fields to the Items::Table so I can pull related records: Items::Platform_IDfk Items::Genre_IDfk Items::Category_IDfk But those only support one relationship. Would I make value lists from those Genre Categories and Platforms and set them as tick box fields?
  4. I’m new to FMPA 18, and have been “playing” with it over the past few months after being asked by my supervisor to create a small database to keep track of our customers. Nothing too fancy, but just enough that we can search for a name/company, create a few notes and print a pdf/invoice when required etc. I’ve been creating a few test databases and have checked out hours and hours of online tutorials, but this particular issue has me confused & frustrated. I’m trying to figure out how to have many contacts (employees) associated with one company (many to one?). I created a portal in the “Contacts” layout which references only the “CompanyName” field in the “Companies” table, and then created another portal in the “Companies” layout to show all employee’s in that company. My setup:- Tables: I currently have a “Contacts” table, and a “Companies” table, and will eventually add the “Notes” table before looking into more complex items (pdf’s etc). Fields: Both tables have Primary Keys (formatted as Text) setup to use the “Get( UUID)” reference (“Calculated Value” box in the Options/Auto-Enter window with also the “Do not replace existing value of field (if any)” box). Also in the same Options/Validation window, I’ve checked “only during data entry”, “Not empty” & “Unique Value” to complete the Primary key setup. I’ve followed this same process for the “Companies” table PK field. Next I created a foreign key (“company_id” - my PK’s are upper case, and FK’s lower case), which is formatted as “Text” in both tables and has no other formatting or field “Options” applied. Finally, in the “Relationships” tab, I initially connected the PK (Contacts) & FK(Companies) together and checked “Allow Creation of records in this table via this relationship” in the “Company” table. (See attached screenshot) The problem: When I create a new record in the contacts layout, and then add the company name, a new company is added in the companies records. But when I create subsequent contacts and add the same company, a new RECORD in the companies Records is created. Only one employee shows up in each “Companies” (portal) record. I also tried removing the relationship between the PK and FK, and using a text field in each named “Company” - this produces a list of employees in the “Contacts” portal window (Companies Layout), but again adds a new record which duplicates the first record. If I then add a third record I have 3 employees and 3 records in the Companies Table. Obviously I don’t require a new record every time I enter the same company name but want to reference each employee to a single company record, so I’m missing something and have not yet been able to find a tutorial which helps. Hope the above is not overly confusing. Any feedback or help very much appreciated. Insert existing attachment
  5. Hello, Here is my scenario. I have two tables. One with dog houses, each record has information about the doghouse, etc. Second I have a table with each individual dog, each dog is linked to a doghouse by a housing ID. Each dog also has a status of "Active" or "Otherwise." What I want is each doghouse to have a count of how many "Active" dogs are linked to it. I can then do searches and calculations based on that. Is there a way to have a doghouse record value that is a calculation, or will I need to write up a script that is run every time I want a report. As a side note I have some 6,000 doghouses and close to 60,000 dogs registered. The faster it works the better. Thanks in advance!
  6. I have a table named Sales with the following data: ---------- ID DATE UNITS ----------- Based on Sample data below, i am trying to query the table by creating a relationship to find the ID that achieved a specified Unit amount on the earliest date. In other words, and for example, which ID achieved a specified Unit amount first (earliest date) Specified Unit Amt of 5 = 1 Expected records returned result 301 10/13/2018 6.5 Specified Unit Amt of 2 = 2 Expected records returned result 766 10/03/2018 2 360 10/03/2018 2 I think a selfjoin may be required. Any thoughts appreciated! Thanks Alan SAMPLE DATA ID DATE UNITS 301 10/15/2018 9 301 10/14/2018 8.5 301 10/13/2018 6.5 360 10/14/2018 5.5 305 10/15/2018 5.5 301 10/12/2018 4.5 656 10/13/2018 4.5 360 10/13/2018 4.5 305 10/14/2018 4.5 611 10/14/2018 4.5 305 10/13/2018 4 15 10/13/2018 4 301 10/11/2018 3.5 360 10/12/2018 3.5 611 10/13/2018 3.5 301 10/09/2018 3 15 10/11/2018 3 656 10/12/2018 3 611 10/12/2018 3 200 10/14/2018 3 301 10/06/2018 2.5 611 10/09/2018 2.5 200 10/13/2018 2.5 766 10/03/2018 2 360 10/03/2018 2 785 10/05/2018 2 301 10/05/2018 2 611 10/05/2018 2 439 10/10/2018 2 656 10/11/2018 2 510 10/15/2018 2 360 10/01/2018 1.5 510 10/04/2018 1.5 611 10/04/2018 1.5 305 10/05/2018 1.5 200 10/08/2018 1.5 656 10/09/2018 1.5 785 10/02/2018 1 766 10/02/2018 1 305 10/03/2018 1 439 10/03/2018 1 15 10/04/2018 1 301 10/04/2018 1 200 10/07/2018 1 656 10/08/2018 1 766 10/01/2018 0.5 510 10/01/2018 0.5 611 10/01/2018 0.5 200 10/06/2018 0.5
  7. Summer is over and our weekly FileMaker webinars are back! Our first one is this Thursday at 11am PDT, on “Relationships for Beginners”. Register Here: https://attendee.gotowebinar.com/register/6892433068111504642 We will spend 30 minutes covering a specific topic. Then the last 30 minutes will be an open Q&A on any topic. Topic List: Sept 13th: Relationships for Beginners Sept 20th: Find Records, Date Ranges, and Special Operators Sept 27th: Conditional Formatting (Can I making something Red?) Oct 4th: Automation (Repetitive Tasks can become Scripts) Oct 11th: Reporting & SubSummaries Oct 18th: Merge Fields and Hiding Objects (Harry Potter Invisibility Cloak) Oct 25th: Sharing your FileMaker App with Co-Workers Nov 1st: Basic Concepts for Building Mobile Apps All the best, Richard Carlton CEO & Video Trainer
  8. Hello All. Just dipping my toes into FM and finding it opens many possibilities. Still must learn a lot to be proficient, so TIA for help. Background: I sign out molecular diagnostic cases. We have a compendium of tests run in the laboratory (all the tests that can be ordered, run and reported out) A Test (type) can be run on many patients. A test (instance) has one patient and each test/report/result has a patient (one). Each patient can have >1 tests. There are a set number of reporting options per test (TestA results can be Positive, Negative, Suspicious, etc (options are in a value list) Each report (ex: TestA/ReportPositiveHomozygous) has a specific text content (Table TestResults) (Pos/Neg, Report text, disclaimers, method, references) I seem to have figured out many of these relationships (I've attached my db) Where I'm stuck: 1) I have not been able to create the relationship between the test result (tr_TestResult) and the patient instance to link the result text to the patientTest instance (currently TOC Patient|TestResult). 2) (not relationship related... rather a calculation problem): How to do the calculation so that TestOrdered:TestFinalized gets timestamped when TestOrdered:TestStatus is set to "Finalized". Thanks for the help! Molecular Reporting.fmp12
  9. I'm sure there is a simple solution to this problem, but I can't seem to figure it out! I have a custom app that allows the user to write letters amongst other things. Each patient is linked to a GP and a Consultant, when writing a letter to a patient there is the option to CC both the linked GP and Consultant. However, occasionally another GP or Consultant might need to be CC'd in the letter (in addition to the ones already linked to the patient). So I would need the address of this additional consultant/GP to also be CC'd in the letter. For the life of me I can't work out a simple way to do this. Does anyone have any suggestions? Thanks in advance.
  10. For an inventory management database, I'd like my main screen to be able to accept pulls from three related databases: - Serialized (valuable tools, which I track and want back - the paintbrush); - Replenishable (cheap tools that I buy by the yard and if one gets left behind I don't care - the paint-mix sticks); - Perishable (disposable tools that are left on the job site - the paint). These will handle their related requests differently. The serialized I'll be tracking properly to make sure we keep track; the latter two I'm looking for more like a system of 'tick marks' to help me know what we use on job sites. We print our barcodes. For ease of use, I'd like staff to scan into a single field in an interface that is smart enough to do the right thing based on a key digit in the barcode. So when I scan barcode 'S1234', my db knows to move it to the Serialized relation field; when I scan 'P1234,' it knows we're in Perishables. Looking for the elegant approach. My thought is that that central hot field (Scan_Here) will, when entered, store a variable and trigger a script built within the context of the related table, but I'm sometimes prone to reinventing wheels and doing stuff the long way, so I'm asking for suggestions / examples.
  11. 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.
  12. 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
  13. Change of Ownership I have written a database which manages my dog breeding activities, I am not great with databases - it was never my day job - and I have have hit a snag with which I would be grateful for some help. I have a three tables; One contains all the dog's (puppy's) details that I need (Dog's Unique ID No., DoB, Sex, `Sire, Dam, etc...). One contains all the Owner's details ( Owner's Unique ID No., Name, Address, Phone Nos, Emails address, etc... One Join Table which uses the Dog's Unique ID No. and the Owner Unique ID No. as foreign keys and links the two tables together using a DogOwner Unique ID No. This works fine when I sell a puppy or dog and I have no problem with assigning more than one dog to an owner (some owners have several of my dogs) but... Sometimes a new home doesn't work out and I buy the puppy or dog back and resell it to different owner. What I can't work out is how I can keep records of all the owners (active or not) whilst transferring a dog from one to the other, I don't want to delete an owner as I need to keep a record who has owned my dogs in the past but I also need to produce a file of information for the new owner using layouts for Insurance Cover Notes, Microchipping, Registrations etc. i have tried deleting the DogOwner Unique ID No. from the record (which I thought was the only link between dog and owner) but somehow all layouts still display the original owner. I just can't get the database to recognise the new owners - the old owner's data is displayed on every layout - including the new Agreement of Sale which I need to send to the new owner. It is rather like a serial numbered product being returned and resold so there must be a way of doing it. I have just installed (yesterday) FMP 16 - upgrading from FMP 12, running on a Mac. Sorry if I haven't explained this very well.
  14. I’m attaching a cluster of screenshots that document a join table. All field are indexed. It looks correct to me, but I’m not able to enter groups in the portal. I can’t even access the field. Any help would be appreciated. Thanks. Join.zip
  15. Understanding FileMaker Relationships | FileMaker Pro 16 Videos | FileMaker 16 Training https://www.youtube.com/watch?v=8sZ9O7948ko Most Recent Upload https://goo.gl/Dbn9fm Get up to speed with the FileMaker Pro 16 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 26 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference, Richard will teach you all the ins and outs of building FileMaker Solutions. The course is 50 hours of video content! Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide. Richard works closely with RCC's staff: a team of 28 FileMaker developers and supporting web designers. He has offices in California, Nevada, and Texas. Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client-server integration. Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution. Looking for FM Starting Point free software download: http://www.fmstartingpoint.com Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development. RCC, Filemaker Videos, and LearningFileMaker.com are headquartered in Santa Clara, CA. http://www.rcconsulting.com/ Please feel free to contact us at support@rcconsulting.com FileMaker Pro is simply a powerful software used to create custom apps that work seamlessly across iPad, iPhone, Windows, Mac, and the web Transform your business with the FileMaker Platform Free FileMaker Training Videos Channel https://www.youtube.com/user/FileMakerVideos 50 Hour FileMaker Pro 16 Video Training Course-FileMaker 16 News-Online FileMaker 16 Training Videos https://www.youtube.com/watch?v=KpQqLLDcZ8I Playlist https://www.youtube.com/watch?v=KpQqLLDcZ8I&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_&index=13 Top 10 New Features in FileMaker 16-FileMaker 16 News-FileMaker 16 Instructional Videos-FileMaker 16 https://www.youtube.com/watch?v=urh8iHOCxkg Playlist https://www.youtube.com/watch?v=urh8iHOCxkg&t=130s&index=1&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_ Sharing your Database with Other Devices and Users-FileMaker 16 News-FileMaker 16 Database Sharing https://www.youtube.com/watch?v=GF82vkYtCtA Playlist https://www.youtube.com/watch?v=GF82vkYtCtA&index=8&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_ Introduction to FileMaker WebDirect 16-FileMaker 16 News-Online FileMaker 16 Training Videos https://www.youtube.com/watch?v=uaZKIpBjMAM Playlist https://www.youtube.com/watch?v=uaZKIpBjMAM&list=PLjTvUZtwtgBSVV1-4pFG4SHAhCIP3Yy-I&index=17&t=10s FileMaker Behavior Change-Go To Object-FileMaker 16 Video Training-FileMaker 16 News-FileMaker Video https://www.youtube.com/watch?v=MFwFjZem3AM Playlist https://www.youtube.com/watch?v=MFwFjZem3AM&index=15&list=PLjTvUZtwtgBQVDIUvoRkcvrMLi7sTZmj5 A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data Official site provides the SDK, Developer's Guide, Reference, and Android Market for the open source project http://learningfilemaker.com/FIAS.html Here is a video introduction to iOS App Training https://www.youtube.com/watch?v=cVxQe_yAshw For more Free FileMaker videos check out ...http://www.filemakervideos.com Download the FileMaker Pro 16 & FileMaker GO 16 for mobile devices training videos at http://www.learningfilemaker.com Download FileMaker Go 16 video training at http://learningfilemaker.com/FMGO-16/fmgo16.php Download FileMaker 16 Full Video Training Bundle at http://learningfilemaker.com/subscription.php FileMaker Video Training Review-FileMaker 16 Video Course Review-FileMaker Pro 16 101 Course Review https://www.youtube.com/watch?v=mF6Uor0KmKo Playlist https://www.youtube.com/watch?v=mF6Uor0KmKo&list=PLjTvUZtwtgBT8tNHuzF6cOKC_37zCTQl6&index=18 Learn how to use FileMaker to create an app with the FileMaker Training Series FileMaker Pro is a cross-platform relational database application from FileMaker Inc. Please Comment, Like & Share All of Our Videos. Feel Free to Embed any of Our Videos on Your Blog or Website. Follow Us on Your Favorite Social Media Facebook Twitter Google+ #WhatisFileMaker16 #FileMakerPro16Training #FileMaker16VideoTutorial #FileMakerPro16Videos https://www.youtube.com/watch?v=8sZ9O7948ko&list=PLjTvUZtwtgBQVDIUvoRkcvrMLi7sTZmj5&index=28
  16. Hey, I started working with FileMaker a while ago and so far it's been pretty fun and fairly easy to learn because I worked with MySQL in the past. However, there are still a few questions I have. I'm used to having complete freedom when it comes to databases, because in Python or C++ for instance I would simply write my own queries and get whatever data I need, no matter if a database is related to another or not. Anyway, the flexibility is still what causes me some problems. I have the following problem. I'm working on an ERP (Enterprise Resource Planning) software for the owner of several restaurants. I need to have the following tables to start with: Restaurants Employees Jobs Visa Health Insurances Meetings Now, the person using the solution needs to be able to create as many restaurants, employees, jobs and meetings as they want and assign them to each other. For instance, Restaurant A is going to have 5 employees, Employee A, B, C, D, E and so on, and all these employees will have one or multiple (this is really important) jobs assigned to them. This process has to be flexible, so I can assign an employee to whichever restaurant and job I choose. You also need to be able to assign one or more visa to a job (and the assigned employee), the same goes for one or more health insurances. The next problem is about meetings. Each restaurant needs to be able to have meetings every once in while, which need the ability to keep track of employees that attend the meeting. So you should be able to select employees form a portal or card window (in FM16 for instance) and they will be added to another table MeetingAttendees or something similar. Again, this needs to be flexible so every restaurant can create meetings and check which employee is present. (I need to be able to create a layout to display the meetings and who has been present, if possible also to see who wasn't). Normally I would simply take the IDs and create tables that join these iDs together, however I'm not able to recreate this in FileMaker, if one relationship works, the other breaks for some reason. If anyone could give me a simple layout of what my database needs to look like, or if possible and not too much to ask an example in FileMaker. Your help is much appreciated. Thanks in advance, Mike
  17. 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?
  18. 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?????
  19. Hello guys! I wish to everyone a happy new year. I am new to FM. I'm trying to create a Diary. I have the following tables: Diary --< StudyLog >-- StudyPart >-- StudyContent In my diary Layout, I have a portal. Through this portal I want to: Create new records to StudyLog, StudyPart, StudyContent IF there are existing records to StudyPart or StudyContent I want to keep those the same! Example: I create Day: "1/1/17". Through the Day's portal, I create StudyLog: "Log #: 1, Time: 9:00, Duration: 1hr" StudyPart: "StudyPart: Chapter 1, Chapter Title: Coulomb's Law" StudyContent: "Title: Quantum Physics, Author: ..., Type: Book" In the same Day, through the portal I want to create: New StudyLog Same StudyPart Same StudyContent When I write the StudyPart and it exists, I want it to auto complete. Same for the StudyContent. I tried to make it as simple and compact as possible. If you need pictures or anything else, please tell me. I would appreciate it if anyone could help. Thank you so much! Again, happy new year!
  20. I am so frustrated after two solid days of working on this really simple join table example. I am trying to create a little iphone application in which I can quickly track my homeless outreach contacts on the fly. I have been so frustrated. I made a lot of progress at one point by just deleting the portal and starting over. I attached two databases, test which works just the way it is supposed to. A simple widget model based on something I saw on youtube. and Client test which is my attempt. Test works fine. Client test is very similar with a couple of extra fields including a calculated full name field but nothing significantly different. Right now the problem is the relationship will not create a new record in the join table. Maybe I don't even need a join table. Not sure but the join table was one of my attempts at a solution. I have been using filemaker since 6 but only sporadically. I used to be able to create simple solutions on the fly but I just spent the whole weekend trying to get this to work. I don't have any hair left to pull out! Help! test.fmp12 NewClientTest.fmp12
  21. I'm pretty new to filemaker and databases in general, and are strugglig with the following problem. I got a table for registering damage done to art prints. There is one table for a complete edition of a print (table 1), with a child table for every single instance of the print (table 2). For instance "Title" (table 1) and "52 of 250 (table 2). The table for damages is done as a child of "table 2". When entering information in table 3, it would be great to choose the name of the print from table 1 (the grand parent) first as a drop-down list, and then only get the related options in a new drop-down list from table 2 (the parent). There is probably a pretty simple solution to this, but I can't seem to figure it out myself.
  22. Many to Many Relationships in FileMaker | FileMaker 15 Videos | Filemaker 15 Training https://www.youtube.com/watch?v=FAbpv6Ag-Qw Understand the concept of 'many to many' relationships in FileMaker! Get up to speed with the FileMaker Pro 15 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro15.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 26 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference,Richard will teach you all the ins and outs of building FileMaker Solutions. The course is 40 hours of video content! Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide. Richard works closely with RCC's staff: a team of 28 FileMaker developers and supporting web designers. He has offices in California, Nevada, and Texas. Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client server integration. Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution. Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development. RCC and LearningFileMaker.com are headquartered in Santa Clara, CA. http://www.rcconsulting.com/ Please feel free to contact us at support@rcconsulting.com If you want to explore building I.O.S apps for I Phone or I Pad and deploying those out to the Apple App Store. Here is a video introduction to our iOS App Training https://www.youtube.com/watch?v=cVxQe_yAshw Looking for FM Starting Point free software download: http://www.fmstartingpoint.com For More Free FileMaker Videos Check out Http://www.filemakerfree.com Visit http://www.learningfilemaker.com for all facets of FileMaker Award Winning Video Training. Please Visit Our Channel: https://www.youtube.com/user/FileMakerVideos Please Subscribe While There. Please Comment, Like & Share All of Our Videos. Feel Free to Embed any of Our Videos on Your Blog or Website. Follow Us on Your Favorite Social Media https://www.facebook.com/FileMakerVideos https://twitter.com/filemakervideos https://plus.google.com/+FileMakerVideos/videos Filemaker Pro 15 Training Videos FileMaker 15 Videos Filemaker Pro 15 Video Course #WhatisFilemaker15 #FilemakerPro15Training #Filemaker15VideoTutorial #FilemakerPro15Videos
  23. Hello, I am newbie to filemaker pro but love it Said so, I am struggling a solution that I am building for management of holiday apartments, based on FMSP. I have created a table for bookings, and apartments, and now I am working with another table call Daytariffs that would give the price for each day of the year for each apartment. So far I have being able to show the available apartments for a range of dates, but what I am struggling now is to show the prices for those days. Basically, what I have done on the DayTariffs table is to load 365 days (records) then I have created a field called "Range" and put a calculations that shows "YES" if a date is within the dates I have set on the Booking layout as StartDate and EndDate (this dates are global fields). I have created relationship between Daytariffs and Bookings through ID_DayTariffs (Daytariffs table) = id_daytariffs (Bookings table). Later, I have also created a global field called "BookingDAYS" on Bookings tables and set the field value as "YES", and I have created a new relationship that relates BookingDAYS = Range. Then I have created a portal based on the the relationship between BookingDAYS=Range, on the Bookings Layout but wont show any records I am stuck here because if I change the Range field to be just text without any calculation and I write "YES" then the portal works, but as soon as I put the calculation back, the related records disappear... I have checked that calculated result on Range field is set as Text as well as BookinDAYS is a text field... also what have noticed is that the relationship graph for BookingDAYS=Range has this simbol at both sides "|---" when normally would have a three lines (like a folk) when I choose any other filed for that realtionship instead of Range. I am attaching screenshots of relationship graph, booking layout and DayTariffs Table Any ideas what I am missing here? Thanks a lot. Luis
  24. I have a table named transactions with a field named ipn_status. The status can be either "Verified" or "Invalid". I'd like to make separate table occurrences that will display only Verified or Invalid records. In the past I would do this by creating a global field in the table called something like relVerified, and I would just put the value "Verified" inside this field. Then I could create a new table occurrence of the same transactions table, and I could setup the relationship like transactions::ipn_status = transactions::relVerified. This would get me what I want. Not long ago, though, somebody pointed out to me that this is no longer necessary, and there is a better way to handle such a scenario. I can't for the life of me remember how to do it, though..?? Any information on this would be greatly appreciated. Thanks!
  25. I think I have a relationship problem here even though the problem appears to be with the Portal or Popover. As you can see from Screenshot1, the popover is showing the data for the wrong record. Interestingly, clicking the Go to Full Record button which calls Go To Related Record does go to the correct record as indicated in the Portal. This is also happening with the Siblings Portal, see Screenshot2. However, the Go to Full Record button on siblings portal behaving differently - it is going to the record showing in the popover which is the same record being display. So it goes nowhere of course. The Relations screenshot shows the relevant relationships as well as the more complicated one I am using to get the siblings. On the Parents layout I am doing the same thing - showing Students via the Parents_Students and Related Parents and the popovers are working fine. Let me know if you need more data. - Brad
  • Create New...

Important Information

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