We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content

Recommended Posts

123    1

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

Share this post


Link to post
Share on other sites

 

2 hours ago, 123 said:

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

I think you may be confusing Tables with Table Occurrences.  You  can have multiple table occurrences to create the relationships you need to accomplish your task.  

I don't have a complete idea of how I would set up the DB, but some thoughts.

Restaurants can be a table.

Employees a table.

But I may put an Assignments Join table between them, so while an employee is at one restaurant, you can see his assignments.  I also have to assume assignments should have a start and end date. For reporting you can then pull up an employee and see his assignment history, and where he is currently assigned.

For meetings, the relationships get a little more interesting.  Do you need to only pick employees who are currently assigned to a restaurant when the meeting occurs, or any employee in the employee pool can attend any meeting at any restaurant at any time.  Meetings would be their own table where your assign the restaurant to the meeting (date time etc.), and employees based on the above mentioned criteria.  And here is where you could use another table occurrence for a value list or picker list that will only show the employees assigned, once the restaurant is chosen.

As you are aware, it's probably most important to completely (or what you think is completely) nail down the relationships on paper before you start building to avoid the scenario of going too far in the wrong direction and wasting time starting over.

Share this post


Link to post
Share on other sites
ggt667    6

FileMaker lingo = unix / SQL lingo

---

table = table

table occurance = table as seen in a specific query

layout = view AND / OR CUBE

valuelist = sort | uniq as in ORDER BY

relationship = part of query AND / OR CUBE

7 hours ago, 123 said:

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

You will add a record through a relationship aka related record, in Filemaker there is no need to fiddle with the keys and related keys, you just need to add a record in a related table through a relationship; possibly via a portal.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Similar Content

    • By Richard Carlton
      FM Starting Point European Union and Coaching |FileMaker Pro 16 Videos |Online FileMaker 16 Training
      https://www.youtube.com/watch?v=gFnjRqtP4R0
      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 open source project
      http://learningfilemaker.com/FIAS.html
      Video introduction to iOS App Training https://www.youtube.com/watch?v=cVxQe_yAshw
      For 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 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
      #WhatisFileMaker16
      #FileMakerPro16Training
      #FileMakerPro16Videos
      https://www.youtube.com/watch?v=gFnjRqtP4R0&list=PLjTvUZtwtgBQVDIUvoRkcvrMLi7sTZmj5&index=26
      http://feeds.feedburner.com/FmStartingPointEuropeanUnionAndCoachingfilemakerPro16VideosonlineFilemaker16Training
    • By jaboda
      I was interested to read that FileMaker 16 now supports the ability to sign in with an HTTP POST.
      I was wondering if anyone had tested this yet?
      I'm looking at creating a custom login screen so any examples would be great. Thanks.
       
    • By troi
      Updated file management plug-in for FileMaker Pro 16 improves Drag and Drop function
      Alphen aan den Rijn, Netherlands, June 19, 2017–Troi today announced the immediate availability of Troi File Plug-in 9.0.1 for FileMaker Pro 16.
       
      What is new in version 9.0.1?
      Version 9.0.1 is a maintenance update of our plug-in for manipulating external files and folders directly from FileMaker Pro. In this version we fixed a bug with the TrFile_DragAndDrop function on Windows, which prevented drag and drop when running FileMaker Pro 16. We also improved the DragAndDrop.fmp12 example file: the calculation for the bounds of the three drag zones is now correct when running FileMaker Pro 16.
      To read what was new in version 9.0 please see: https://www.troi.com/news/file90_pr/
      More detailed information on all changes and improvements implemented in Troi File Plug-in 9.0.1 and earlier can be found at: https://www.troi.com/products/fileplugin/
       
      Pricing & Availability
      A fully functional demo version of Troi File Plug-in 9.0.1 is available for downloading at Troi’s Web site at: https://www.troi.com/products/fileplugin/
      Licenses cost US$ 99 per user. Details on developer licenses and multi-user discounts can be found on our web site. You can order licenses from our web site.
      Upgrading to version 9.0.1 is free and recommended for all users of version 9.0: version 9.0.1 works with the same registration as the 9.0 version. Users who bought a license for Troi File Plug-in on or after May 10, 2016 are entitled to a free upgrade to version 9.0.1. Eligible users have been sent a new 9.0 registration. Contact us if you have not received yours.
      Upgrades from licenses bought before May 10, 2016, are available from US$ 59 per user. Upgrade prices for other licenses can be found on our web site. You can order upgrades from our web site.
       
      Contact information
      D. Budding, Troi Automatisering
      Newsroom: https://www.troi.com/news/
    • By 123
      Hey,
      what happens if I create a solution in FM16 and use the "Card Window" feature and someone else who still has FM15 wants to work with my solution? Will this work or is it not even possible to run the FM16 solution?
      Thanks in advance,
      Mike
×