Jump to content

Search the Community

Showing results for tags 'relationship'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Custom Function Library

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker REST API
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • FileMaker Schema & Logical Functions
    • Managing Scripts
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • OS Level Database Automation
    • Hardware & Networking
    • Bar Codes (Printer, Scanners, Software)
  • FileMaker Discussions
    • FileMaker Pro 16
    • FileMaker Pro 15
    • Legacy FileMaker Platform Discussions
    • Product Ideas
  • Productive Computing Support Forums
    • Visit Productive Computing
    • General Discussion for Productive Computing Products
    • Core CRM Solutions
    • QuickBooks and Accounting Plug-ins
    • Contact and Calendar Management Plug-ins
    • FileMaker Utility Plug-ins
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • 360Deploy
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • FileMaker Vendors
    • FM Starting Point - By Richard Carlton Consulting
    • Monkey Bread Software (MBS Plugin)
    • SyncServer Pro by LinearBlue
    • Comm-Unity Networking Systems (CNS)
    • SmartPill PHP Edition
    • FileMaker Plug-Ins
    • Accounting Solutions
    • FM Easy Suite Framework
  • FileMaker Training Resources
    • Professional FileMaker Training
    • ISO FileMaker Magazine
    • FileMaker Developer Conference
    • User Group Central - Sponsored by FMPug.com
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Member Lounge
  • 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

Found 57 results

  1. 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.
  2. The Problem: I have a filterable portal (1) displaying contact names from a staff table. I need to click on a contact to add them to a separate portal of invitees (portal 2) on the same layout (Events) . I then need the original portal to either hide (or in some other way denote) the people already added to the second portal. In other words, it needs to be clear that a person already invited can't be invited again. The layout is from the table: Events Portal 1 is showing records from Staff (filterable via a global search field) Portal 2 is showing records from EventInvitees I need Portal 1 to only filter through those staff who haven't been invited yet. Any help would be gratefully received. I am struggling around using 'conditional formatting', 'hiding when…' options and non-matching field relationships!! Thanks in advance! Fumblewinter
  3. Personnel Availability

    Hello, New to Filemaker and new to this forum. Hoping someone can help me out. I am working on a personnel planning system with, among others, the tables Employees, Shifts and Availability. tblEmployees has fields like Employee ID tblShifts has the fields Employee ID, Start Timestamp, End Timestamp tblAvailability has the fields Employee ID, Start Timestamp, End Timestamp and Status When in the layout Shifts I want to open a portal in a popup and I want this portal to be sorted by Availability and I want the portal rows with employees to be 'greyed out' when status = 0, green when status = 1 and normal when no Availability is given. I basically need to know which records from tblAvailability match records from tblShifts and then which records from tblEmployees match records from tblAvailability. How do I go about this? Do I need SQL? Hope this is a somewhat clear question. Many thanks!
  4. L&G, I have read the guidelines for posts in this forum. Therefore I did not enter the Post title that came first in mind: Do I understand portals (aka do I understand Filemaker) and I do not emphasize now on being new in Filemaker issues. I am trying to achieve something simple at a first step of a big plan: Entering recipes in a Filemaker testversion database. The longterm goal should be a database in which I can enter my collected recipes. Followed by tool for a weekly menu plan for my family and a shopping list coming out of the database after taking care of my fridge's stock => so far so good, but currently this is a plan for the next ten years I realized starting with Filemaker. I searched different apps and database programs, and Filemaker seems to be my solution as I did not find anything that fits exactly my expectations. So back to the first problem: how to enter my recipes? I created a table of recipes with an unique ID_pk (I learned already about pk and fk), Name and How-To-Make-it as well as IDs(fk) from the other tables which are Zutaten (Ingredients) with the name and the amount, Form_Zutaten (how the ingredients are used i.e. chopped, sliced, etc.) and Einheit_Zutaten (unit i.e. cup, liter, etc.). Why I have choosen this structure: because all ingredients must be combinable with different units and how the are used. otherwise I have to enter e.g. avocado sliced, avocado mashed, etc. or make rules like liquids can only be liter or mililiter or cups while flour can only be gramms etc. So a combination of all three tables should be possible. What I though might be an easy task is to create a recipe layout than with recipe ID recipe name and a dynamic portal depending on the number of ingredients constisting of: Zutat - Form - Menge - Einheit in english: Name of the ingredient - how is it, which kind/form - how much (qty) - which unit so I related the tables via pk and fk, created the layout and bam: complete disaster. after needing a couple of days to make the values appearing in the dropdown (learned about the value list), some fields in the portal do show the all entries of the ingredients, while the kind/form and unit fields do always show the first value of the table? and although I locked the fields, the first entry is always shown and is getting overwritten by the choice I choose from the dropdown... and nothing is dynamic, meaning that 7 ingredients will make 7 lines and it always starts with one empty line, etc. I am not sure if my descriptions do make sense, therefore I am attaching my work, hoping someone could help me with how to use the portal for a convenient data entry. thx in advance! br HJS 2017_09_Essensplan.fmp12
  5. Hey, I have the following problem. I'm working on a solution for the owner of several restaurants. Each restaurant has meetings once or twice a month. How would I structure the tables so that I could have a layout on which I select a restaurant and then inside a portal I get a list of all employees. On the portal for each row I want to have a button or checkbox to mark if an employee is present or not. I already have the following tables: Restaurants, Employees and Meetings So far I have a relationship between the Restaurants and Employees table which I use to assign employees to a restaurant, and a relationship between the Meeting and Restaurant table, which allows me to show all employees that work at a selected restaurant using a portal on the meetings layout. How do I proceed to solve my problem? Do I create another table MeetingAttendees or something similar that I use to keep track of people attending a meeting? How would I create a relationship then to allow me to mark certain employees as present and absent? Thanks in advance, Mike
  6. Hi, I have a configuration table (named 'Usager actif') with 'Projet ID actif' and start/end date values (field name 'Bilan date début' and 'Bilan date fin') linked to a timesheet table (named 'FTemps lié Projet bilan') to show only the records that match, according to the following relation: This table is also linked to a step table (named 'Étapes lié FTemps lié Projet bilan') to show a list of steps used by the timesheet table (named 'FTemps lié Projet bilan'), base on the following relation: So the last table (named 'Étapes lié FTemps lié Projet bilan') is shown in a portal and it's working correctly (show only two steps used, for all the timesheet records). But I wanna show the total time used for each step (first step is 5 hours, and last one 95 hours). It's working correctly if the start/end date included all timesheet records. But if I shrink the ending date (removing 2 hours from the timesheet in step 2), the total time by step still show all time since the context does not follow from timesheet table to the step table in relation. I still see 5 hours for step 1 and 95 hours for step 2 (should be 93). The total time for all step is now 98 hours, since the ending date has been shrink (removing 2 hours on step 2). How can I do this (hope fully I'm clear enough)?
  7. I am currently building a database to handle the inspection sheets used by our Quality lab. Here is the relationship layout: For each revision on the Revisions table, I have a differing number of Dimensions that need to be measured (some parts/revs will have 5 dimensions, while others will have 15). Each dimension has a specified type of instrument used in measurement, and a max/min value. The instrument used is a drop down menu that references a list of instruments/gages that we use. Here is how I have my inspection sheet currently laid out: The portal on the left points towards my dimensions table. It shows the data corresponded to the specified Part Number and Revision level. The data contained in this portal is uneditable from this form. The portal on the right points towards my RecordedDimensions table. It will store data that will correspond back to the Lot# associated with that inspection sheet. I also have a table that pairs all the different types of instruments we use, with their corresponding gage ID's: Now I would like my user to be able to click on the dropdown box under Instrument#, and that drop down box will only show the Gage ID's for the specified gage. So, if on the dimensions table, a dimension calls out for Digital Micrometers to be used, then when my user goes to select the instrument ID (which is saved in the RecordedDimensions table) it will would allow them to choose 151, 152, 153, 306, 324, 330, and 331. Please let me know if I have not provided enough information/pictures, I will gladly provide more. Thank you in advance for any assistance you can offer me!
  8. Go to Related Record in Portal broken

    Hi...I have created a database using a "modified" anchor buoy method and so far everything works great...but...I have a portal in a "join table" that works fine...however, my button that is supposed to open the record in the portal row does not function...it returns nothing. The records are indeed related (see RG) as the fields show up from the related table without relational conflicts, but this button that is supposed to open the "library" table with the related record pulled up simply does nothing. I have attached the DB. Also a screen shot of the table where the portal is (it is actually a join table layout, this may be the problem). I don't understand how the button (with the little arrow) does not go to the table that the actual portal record, which IS related because I see it show up on the portal row...what is not right here? Thanks! Todd **MusicalAmericaPRESUB copy.fmp12
  9. 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 pounds per gallon of fuel consumed, for each of the two dozen chemical compounds I’m interested in tracking. Those emissions are relatively simple to calculate: Multiply the Emission Factor times the number of hours operated (or times the gallons of fuel consumed) and we’re done. Except for the fact that the Emission Factors are based on the Year of Manufacture and, in some cases, the horsepower rating of the engine, so I have to circle back around to the Engine table: I don’t know how to connect the emission factor for, say, Arsenic to a specific engine, say a 154 hp Chevy made in 2014, based on that engine’s year of manufacture and hp rating. So my ERD keeps looking something like this: Engines --->Emission Factors--->Engines or Engines ---< Emissions >---Emission Factors--->Engines My computer keeps puking ones and zeroes all over my keyboard when I try either setup in my Relationship Graph! The only other way I can think of accomplishing these seemingly simple calculations is to write a boatload of scripts with variables, but I’m not even sure I could come up with all of the combinations/permutations involved. And, unfortunately, I can’ even spell SQL, let alone know how to execute one of ‘em! I have attached a (simplified) copy of the spreadsheets I currently use to better explain my problem. I hope one of you will find this to be mind-numbingly simple and explain how it should be done. Thanks very much for your time and consideration. Sincerely, Guy Engine Emissions Calc Sheet MOD for FMF.xlsx
  10. Relationship help

    Hi guys, Sorry I do not know the terminology of what I need. I am trying to setup a database to record some info on postcodes. What I need to do is, each supplier can have 4 types of lead (back data, profile, survey, 2nd use). I have two tables for suppliers and postcodes already. I also have 2 join tables for many to many relationships. I need each field in the postcodes database to be able to store a count for each supplier's lead type. Eg: Supplier - Lead Type - Postcode - Count Supplier A - Back Data - AB - 20 - BB - 155 - CB - 30 Profile - AB - 55 - BB - 27 My problem is with the way I have set the relationships up currently. When I add a count for a postcode it adds that count for all suppliers. I need the postcode count to be specific to each supplier and lead type. Can anyone tell me what I need to do to get this working correctly? I have attached a screenshot of my relationships. Thanks
  11. Hello! I have re configuring the Research Notes Starter Solution - it works quite well for what I need. But I want to create a couple of extra tabs with portals, but I'm having trouble understanding the how the current IDs are being created (using a calculation) for the TYPE MATCH FIELD in the Data table for Notes, Documents and Media? Could anyone help me understand this? Should I just build it from scratch? I'm using Version 14. Thanks for your time.
  12. I've driven myself more or less crazy trying to figure this out on my own. The relationships themselves are rather simple: Each project has a list of questions. Each question has a person who created the question, and someone the question is assigned to. A question also has a number of responses associated with it which each have their own "creator". There are 3 main tables to cover: Questions, People, and Responses People consists of 3 fields: The UID, the person's name, and the person's email address Questions has 2 fields which relate to People: creatorID and assigneeID Responses has 1 field which relates to People: creatorID. The way the relationship graph is set up now, I have 3 instances of the People table that relate the UID field to the appropriate ID field in Questions or Responses as needed. What I want to happen is when I set an Assignee or Creator for a question or response, I want to use the corresponding record details from the People table - if one does not exist, then create a new one. Instead what happens is a get a new record in the people table every time. Even if I set the Layout field to give me a drop down of the existing values (and I use it to select one when, say, setting the assignee on a question) it still creates a new record. So confused... any help is much appreciated.
  13. Copy Relationship?

    I have a solution with 4 Databases. There is the main-data-database on a Filemaker Server (only data, no relationships in the Table-Occurences (TOs)) and a GUI Database on the Desktop (only Layouts, TO's are included from the Server-Database and on this TO's the relationships are defined, so I can use them in the Layouts. Than I have a 3rd database, which is a subset of the server database and lies on an iPad. This 2 data-databases will be synchronised by MirrorSync. And the 4th Database is a special GUI Database on the iPad which uses the 3rd database for Data. The iPad GUI Database also holds TO's with relationships. Now, I need a custom privilege set to forbid changes and deletions of records when they are marked as Locked. To see all tables in the privilege dialogs, I can only do this in my data-databases, because in the GUI databases I can't see the tables in the dialogs. But in the data-databases I have no relationships defined, so I can't use related tables in the formulas. Now I have to add these relationships also to the data-databases. Is there a simple way to "copy" them from one database to an other? Thanks, Hans
  14. Relationship problem

    I have a database with each record representing one account. Within each account record, there are ten different companies the account may have been sent to (one individual field for each company within the same table), along with the results of that effort. Both of these make up the company data set. Also within that single record there is an identifying ID Code, which represents the type of account it is. What I want to do now is create a table with a portal where I can select or enter an ID Code, and get each instance of that ID Code with each individual company data set. So if with the individual account record I noted that I sent it to four of the ten companies, I want it to return four responses, one for each of the companies I sent it to, with the unique responses (also in a field in the main account database) with the details of the individual record. I feel like the answer is right there, but I just can't get it to work. Any suggestions would be much appreciated. Thank you.
  15. I have a table with NAME field containing Return Separated Values (RSV). I want to run a script that will add more RSV's to the same NAME field in the same table. This will be from the same NAME field on other rows. It will be based on a "match" on a PRODUCT field. I don't want to wipe out the values already in the NAME field obviously. Any ideas?
  16. This is one of the hardest thing I been trying to acomplish, I want to transform the contacts module into a Donors module for our blood bank. I have transform most of the fields already to match the donor information we will need. However I want each donor to show in a portal all the units or (products) associated to that donor. Example: 1 Donor can donate blood every 56 days 1 unit (which has a serial number associated to it) I want each donor to show all the products or units associated to him. Im sure this might be something really simple to some of you so any help will me much appreciated Thank you in advance for all the help
  17. Hi Forum, I am working on a script to be triggered when a field is modified so that it can pull data and update fields on a layout. Some data is in another file and i do not know if possible how to access this file and search for the data i need? Any thoughts on how to accomplish this? Thank you for assisting, Miss-Amen
  18. Hello, I have two tables: Companies and dupcheck_companies...Self-joined with Companies:company = dupcheck_companies::company AND Companies:pk != dupcheck_companies::pk And attached script trigger with layout (onrecordcommit) to show custom dialog if duplicate key (serial of table occurrence not empty) is found .. it works fine when duplicate company name value is found , but what if I want to check another field (phone number) for duplicates , I think it would be better if I could self-join with an OR condition instead of AND , but don't know how Please help!
  19. I have two tables Claims and Premium Records on both tables have dates I want to do an analysis for both tables on monthly and yearly basis with a calculation field Analysis (Claims::claims + Premium::premium) my objective is to be able to gather all the records for each month and each year on both tables using that analysis. That is my basic task. There are other fields like Remark, and recommendation but they are based from the result I get from the Analysis. For example, Analysis field is > 120 , Remark shows Excellent.. please how do I achieve this?
  20. In my attachment, when I search for "Cutting tools" in the main table. It produces the following message. Is there a way I can get rid of this message. I think I know why because I got my product line through calculation of look up. "This operation cannot be performed because one or more of the relationships between these tables are invalid. " fmdata.fp7 fmdata.fp7 newfmdata.fp7
  21. Need through relationship

    While creating a database that has Products, Suppliers and Lines I have come across the need to calculate a count of the suppliers from the context of a Products record. My relationship is like so: My question if I want to pull a lot of information about Supplier is should my portal in the Products record be from Suppliers or from Lines? If the best answer is Lines, could I still have a count of related Suppliers by using the primary key from that table in the portal? Is it a bad idea to use fields from a related tables portal other than its own? Thanks
  22. Hi, I'm developing for a service company that has a telesales and a field sales team. They then have a service team that visits customers and services products on site. Question: Both prospects and customers are currently in a table called 'companies' and have a simple flag (dropdown list) to indicate the difference. Challenge is that the table has grown to 124 fields with some of the fields only relevant to either Prospects or Customers. Remarkably I have never needed to create 1:1 relationships in such a scenario but I'm thinking of doing so. Would it be advisable? I'm thinking specifically it may lead to performance improvements on list layouts with some 20,000 prospect records being loaded? Also having not used this technique before is there a way of having the related 1:1 records in the separated tables auto create when I create a record in the main company table? I'm thinking this might be a really stupid question but I'm quite tired and just can't see it? I look forward to your opinions. Thank you, Simon
  23. Hi there I've been banging my head all day, several days in fact, to create a sub summary report which can reuse records, have a part appear only once and allow me to assert more behaviour over the parts themselves. To complicate the matter it's in a crosstab format as well. I've seen on other posts that what developers do occasionally when preparing reports is to create a temp table of sorts to either store just what records are needed, or to store them in the way they're needed as well. The solution I have at the moment uses lots of summing up and calculations and is intolerably slow to load locally (10 seconds at worst) although it does give me what I need. I obviously want to improve this so ultimately a second table related to the parent with just what I want, just how I want it sounds good. At this point I will add I may have this completely wrong - apologies, it's an idea I'm throwing around! The whole reason I'm looking at this is because I cannot get my sub summary report to behave the way I need it, which may be a failing on my part, but it's a pretty complex report as I've said. So, in concept, is this whack or normal?
  24. Hello, I'm having trouble with the initial set up of my relationship. For the most part it is a simple 3 table (one to many...many to one) design with a sort of "line-item" table in the middle. There are two sticking points for me:1) I would like to set up the relationships based on the "status" of the line items and 2) the portal should only show records that belong to the user logged in. I am attaching a picture to show the simple table relationship between my current tables: user, charges, patients. I have set up the privilege set so that the user can only see his/her charges when logged in, so I think I have sticking point 2 taken care of without requiring the relationship to handle it. The problem with sticking point 1 is that I want the "Patients" layout to contain 2 portals, one pulling the charges with a "current" status. I would use table occurence "Patients" for this portal. The second portal would be for showing the charges with status "archived" and would use table occurence Patients 2 (normally I would just use portal filtering to get the results I need, but I am calling the data via PHP and portal filtering doesn't seem to apply while using PHP, so I need to figure out how to do it based on the relationships). How can I incorporate the status of the Charge into the relationships between the patients and their Charges where the Patients table is related to Charges with the corresponding kf_ID_Patients and ChargeStatus = "Current" and at the same time where the Patients 2 table is related to Charges with the corresponding kf_ID_Patients and ChargeStatus = "Archived" ? Currently the patients are simply related to the charges via the Primary to Foreign key relationship, but this allows the portals to "see" all the charge records for each patient. I need them to reflect only the charges dependent on the appropriate status. Thank in advance for your help! I feel so close, yet I can't seem to visualize how to do this!
  25. Now I know you are all going to say “don’t use repeating fields to store editable data!” but I am running into all sorts of other problems with my solution using a separate table of records that I thought it may just be that repeating fields could offer a solution. Contacts table with multiple addresses. Pop List for field AddressType based on editable custom value list - Address 1 street, Address 2 Postal, Address 3 Billing, Address 4 - Shipping, Address 5 Other …Edit to generate a dynamic relationship. The current solution uses a separate Contact_Addresses table and the dynamic relationship is based on a calculation field in Contacts - AddressTypeAbs = Abs(AddressType), which returns just the numeric value from the value list. A transparent portal then displays the related address fields on the Contacts layout. This is an elegant way to save space on the Contacts’ layout as only one address is displayed at any one time but unlimited addresses are possible. My problem is however that many other tables in my solution have a relationship to Contacts, e.g. Invoices, Purchases, Quotes, Personnel and on and on and on. So in order to display address details in these other tables each has to have another relationship to Contact_Adresses. The deeper it goes the more complex it gets with relationships, workaround scripts and key fields. I thought that maybe using repeating address fields in the Contacts table itself might simplify the database by drastically reducing the need for the extra relationships, key fields etc. but I cannot seem to find a way of achieving my goal to display each repletion in a portal. What would fit my needs perfectly would be to have say 10 repetitions of each of the address fields in the Contacts table itself. The relationship key AddressTypeAbs would remain the same but relate to the address fields’ repetition number. It doesn’t seem possible to relate to a repetition number but I might just have missed something. Just thought to post this before giving up entirely. Any thoughts?
×

Important Information

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