Jump to content

Search the Community

Showing results for tags 'erd'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Claris Engage Vendor Discounts

Community Forums

  • The New Claris 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 19
    • FileMaker Pro 18 Advanced
  • 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
    • Geist Interactive Product Support Forums
    • 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 & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 8 results

  1. I am trying to set up a database to calculate and report exhaust emissions from diesel engines and am stumped at Step #1: The infamous Entity Relationship Diagram! I am looking at a few thousand engines and need to calculate how much of what kind of pollutants they kick out into the air. I have spreadsheets that list the Year of Manufacture, the horsepower, the serial number, how long the engine ran during a given year and how much fuel it consumed during that year. I also have some spreadsheets that list what the Emission Factors, usually expressed in pounds per hour operated or pound
  2. I run a school and keep track of everything school-related in an FMP12 DB on Mac OS 10.11. I used to be more immersed in FMP, but now I'm a bit rusty with some of the logic. Last year I kept track of all non-tuition expenses (books, supplies, elective courses) in one table (ItemPurchasers), and that was sufficient for manually tracking what each student owed. But it didn't allow me to easily see at a glance which students ordered Item X or signed up for Elective Y. ItemPurchasers was not a join table since I did not keep a table of Items to select from (hence the manual aspect). So
  3. Hello everybody, I'm just returning to FileMaker development after years away. The last time I developed in FileMaker was... version 6!!! Wow, has a lot changed, and thank goodness it has. I'm trying to understand FileMaker database schema design. I have a decent knowledge of normalized database forms, but the concepts of having multiple Table Occurrences, and Table Occurrence Groups, are quite foreign to me. I understand what they are on the Relationship Graph, but I don't yet understand how to plan and use them while constructing my solutions. Can you direct me to some good tutor
  4. I hope I can make myself understand correctly (I’m not English native speaker). I’m trying to find out the correct ERD for this. I have properties (Table), owners (Table) ONE property can have MANY owners (no problem with that), but after this, there are many things that can change and I don’t know how to face them. - Let’s say: A boat has two owners. Each one have 50% of the ownership. First owner sells his part to a third one. Now I need some kind of historical because owner 1 has been so from XX/XX/2015 to today and owner 3 from today until ... - Another example: John owns a house
  5. Hi everyone,  I'm  new to Filemaker and have a beginner question about how to structure my tables (ERD'style).  Here's the situation:  I want to create a database in which I connect three entities:  1. Clients 2. Invoices 3. Artworks/Artists  - Clients can have multiple invoices - Invoices can have multiple artworks (however, every artwork is unique!! unlike generic products) - Artworks/Artists: every artwork is unique, and one artists can have multiple artkworks  *I would like to add a feature in which I can connect multiple pieces of art with multiple clients -
  6. Hello, I'm a FileMaker newbie, attempting to build a database to track invoices & payments for a food broker. I can find plenty of information on straight invoicing, but here's my issue - because this is a brokerage, I have both prinicipals (the suppliers) and customers - we are the middle men. (We work with roughly a dozen principals and over a hundred customers) The principals invoice the customers directly, and we are paid a commission (usually monthly but this varies from principal to principal). What I am trying to create is a database where we can generate POs (pulling from both
  7. 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 prod
  8. Hi everyone, Â I'm pretty new to FileMaker but I've had quite a bit of experience designing databases for MySQL and web applications. So I've got a pretty good handle of how to design a database and define relationships, but this one has been throwing me for a loop. Â I've been trying to figure out for ages how to streamline data entry for the company that my husband and I own, I was working on a web solution and then found FileMaker and realized that, if I can get it set up right, it will do exactly what we need. Â Our business works like so (it's so unlike the traditional "Customer
  • Create New...

Important Information

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