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

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • Brain Food
    • Legacy FileMaker Platform Discussions
    • Command Line Data Migration Tool
    • FileMaker Pro Advanced 17
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker DataAPI
    • FileMaker WebDirect
    • Custom Web Publishing
  • FileMaker Server Administration
    • FileMaker Server 17
    • FileMaker Server 16
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • 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
    • Member Lounge
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


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

Product Groups

  • Site Donations
  • Site Advertising

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 58 results

  1. Hi i have 3 Tables Property , Units , Tenant. Each property has many units , Each unit has one tenant active but may have many inactive tenants from previous years. All working fine BUT..... i would need to show a table in the property layout of the units and each one only with its active tenant. The portal is based on the units table. However the tenant just show up the tenant that was first input to the unit. My question is , how could i get that only the active tenant should show to the unit? i would really appreciate it someone could guide me on this.
  2. I am running 12 03 on OSX and Windows.  I have two versions of the same program; versions 999J and 999H. The main Members Layout is based on Members table.  On the left (in red) is a portal based on a TOC of Members that when selected, a GTRR script is run and in the main Members section (to the right) the correct member detail is shown. This works.  The problem: When I click a 'delete' button, in v 999H it deletes a single record.                                                                ... in v 999J the same script deletes ALL members?   So, I assume it is a problem with the relatinship between the portal TOC and the Main Members Table? They are the same.  Allow Delete is turned OFF in both.  The Filter is the same in both and when turned off doesn't make a difference. The Sort is the same.  So, if the script is the same. And the relationships are the same, "What could cause a cascading delete in one and not the other?) Â
  3. Forgive me if I'm wrong but I was under the impression that when using the LIst(field) function to combine multiple records into one field, that the sort order was meant to be defined by the sort order set in the relationship. I've had this working before, but for some reason it doesn't seem to want to do it anymore, and is always reverting back to the order of when the records were generated. I've attached an example here, where i eneterd the data in this order: ONE, THREE, FIVE, TWO, FOUR (with each record having a number field corrsponding to the word to use to sort on: 1,3,5,2,4). As youcan see the portal sorts correctly, but the COMBINE (List) field which uses the List function does not, even though the sort order of the relationship is set to the number field. Whats even ore odd is that I managed to get this to work in two other solutions, though both of them initially didn't work, but onceI had put the portal on the page, the COMBINE (List) field then reverted to sorting acorrding to the relationship sort order ?? Any help greatly appreciated FM 12.3 test2.fmp12.zip
  4. Hi all! First off, I have been using FM Pro for about 15 years. While I designed basic databases, I never got real deep in. That changed this past week when I decided to re-design my main DB. This DB will contain injury records for high school athletes. I have been trying to grasp relationships for the last 4 days, and I must say, its been tough for me to fdully understand them. I did create a multi layer conditional value lists using a relationship, but I'm not completely sure how I did it though it works. Now I have a new desire. I want to be able to create a script button that does the following. If a specific injury is listed (in this case, a concussion), I want a script button that will create a new record in a separate table, then bring over the name, sport, and injury date to populate the corresponding feilds. This is where the relaitionship comes into play, but after about 12 hours of trying, I just haven't gotten it done. I've read through about two dozen different threads on here to try to get the solution, but at this point, I think reading and trying so many have just lead to more confusion. Any help provided would be greatly appreciated!!! (BTW, I've tried to remove the permissions, but Guest account has full access as does the user "Bill") SOAP.zip
  5. 4Justme2

    Many-to-Many Challenge

    I have been out of the Filemaker Pro arena for the past 8 years. I’m currently working to bring myself up to speed on FMP 11 Advance and have run into an issue and I can't seem to get my arms around a solution. First let me start by identifying my primary tables, primary, foreign and match key fields, and the current database schema: tblCONTACTS (fields: [pkCONID] primary, [fkHHID] foreign, [kContact_Type] match key and other fields) tblHOUSEHOLD (fields: [pkHHID] primary and a bunch of address fields) tblHOUSEHOLD_JOIN (fields: [fkCONID] and [fkHHID]) I have a join between tblCONTACTS::pkCONID on the one side and tblHOUSEHOLD::fkCONID on the many; likewise, I have a join between tblHOUSEHOLD::pkHHID on the one side to tblHOUSEHOLD_JOIN on the many. The reason I used the join table is because the Contacts who are labled as "Child" from the [kContact_Type] field can belong in several different households (mom and step-dad, dad and step-mother, etc). In order to get a one-to-many relationship for this specific cohort I added a join table between tblHOUSEHOLD and tblCONTACTS. The CONTACTS table is just as you would expect, a table that contains information relevant to all of the people in the database. The HOUSEHOLD table contains all of the addresses of the people in the CONTACTS table. The field [kContact_Type] in the CONTACTS table is used to distinguish between Children (<18 with no children of their own), and Participants (anyone else). [kContact_Type] field contents are drawn from a value list containing two words, "Child" or "Participant". My ultimate goal: To have the ability to report on Contact activity as a group within the same household [HHID], individually by [kContact_Type]= "Child" or "Participant", and the really tricky part for me… I need to be able to look at these two groups by their roles as they relate to one another: One mom can have many Children, one [Child] will have at least one, morely likely two or more[Participants] a/k/a parents. And not all Participants are parents (some won't have any children). I assume I need a seperate table for these relationship roles but I can't seem to work out how that would work. I tried creating a table occurance based on CONTACTS in a self-join relationship hoping I could link by both the CONID and the [kContact_Type] of "Child" or "Participant"... but naturally that didn't work and I was looking at a mirror image of the main table. I tried seperating the contents of "Child" and "Participant" into two different fields and then creating a self-join... but I still got the mirror image since the join didn't distingish between fields that had null values. Any help you can give me on how I might set this up to work would be greatly appreciated.
  6. Hello! Just migrated from FM6 to 12 and am enjoying all the power and flexibility! I have two tables (Materials and Restrictions) that are "joined" in a many to many relationship through a third table (MatRest_JOIN). The primary table contains information on organic materials, the second table is a listing of all the possible restrictions a material might have. That middle, joined table which allows the many to many relationship can be understood as... 1. A material can have one or many restrictions 2. A restriction could apply to one or many materials at one time 3. MatRest_JOIN table has an index (ID) of it's own records and then for each record has the fields MaterialID and the RestrictionID At present, I can select one restriction at a time to be added to the joined MatRest_JOIN table via a portal. However what I'd like to give user's the ability to do is see a list of ALL the restrictions possible, choose via a checkbox beside each of the ones they want and then add all those restrictions in one step to the joined table. So back in my main layout for Materials that has the Restrictions portal, they'd see all the restrictions they chose/applied to that organic material. I do have a couple ideas how to accomplish this, such as a loop in the script that looks at each record in the Restrictions table to see if the user checked it....then as it comes across those, it creates a new record in the joined table tying the ID's of the Materials and Restrictions table records, then it continues through the Restrictions list performing the same task until it hits the last record. That seems like the way to do it, however it also seems like a might be a big clunky...going step by step through one table (which at most would only ever have like 30 records/restrictions in there) and checking a flag, and creating a new record in the joined table, on and on. Any thoughts are greatly appreciated...thanks so much! Joshua FM12_Script_MultipleRestrictions.pdf
  7. Here is hoping that the forum has fixed their attachment problem:   In the Members Layout I have a field called (field--- yes, I know but I can't change it now. It will screw up my imports). Members::field collects information from a popup. It works and the Members::field information shows on the Members layout. ------------------------------------ On a second layout, based on Meetings I have 2 portals:    Portal 1 l is based on VisitorMeetingJoin. It works. I can pull information from Visitors as expected.    Portal 2 is l based on MemberMeetingJoin. It works EXCEPT that I can not get the MembersTOC::Field to show data???  Why can't I get information from MembersTOC (A table occurance of Members)  Thanks  Ron
  8. Hi guys, I've been searching through the forums here to get some insight into a problem I've been having, but I can't quite find enough info to figure it out. I have a FileMaker solution that tracks time spent on a job. Each job can have multiple time entries logged for it, and since a few people might be working on the same job, those time entries can overlap. For each job, I want to calculate the net amount of time that was spent. In other words, I want to ignore any time overlaps and calculate the total time spent in general, not just total up each separate time entry. Visualized, my data might look like this: 9 ------- 10 9 ------- 10 11 ----------- 1 12 ------------ 2 In the above example, I would consider the net time as being 4 hours, since some of the time logs overlap. I've attached a very basic idea of my database with some sample data. I feel like there should be a way to do this with self-joins and a couple calculations, but I still haven't gotten my mind wrapped around it. Any help would be much appreciated! OverlappingTimes_Demo.fp7.zip
  9. John Canino_71441

    Cannot figure out relationship logic

    Using: FMP Adv 11 on a Mac with OS X Lion. I normally consider myself pretty good with FMP, but cannot think through the relationship schema for a current project, which is for a language/dictionary database (for a constructed/artificial language. Nerdy, I know). Although the content of my database may seem strange to some, I think the techniques I am trying to learn could be of value to others. So here goes... My example here uses three tables. I have more, but learning how deal with the third will solve my problems for the remaining ones. TABLE 1 (my starting point) is called ENGLISH, containing SERIAL # (number), ENGLISH WORD (text) and POS (part of speech, text). TABLE 2 is called TARGET, containing SERIAL # (number), ENGLISH WORD (text), POS (text), ROOT (text) and TARGET WORD (text). TABLE 3 will actually become multiple tables, one for each PRE-DEFINED POS, containing SERIAL # (number), ENGLISH WORD (text), TARGET WORD (text), POS (text), ROOT (text) and various fields calculated as text based on the POS. For example, if POS = NM (noun masculine), then all words linked via tables 1 and 2 and having the POS = NM should populate this table. For each different POS, the correct table should be populated. Within each of these tables I will be able to automate word formation by concatenating the ROOT with appropriate affixes, which I know how to do already. I have tried the following relationships, but something seems to be missing: ENGLISH TARGET MASC NOUN =========== =========== =========== SERIAL# SERIAL# SERIAL# ENGLISH -------> ENGLISH -------> ENGLISH POS -------> POS -------> POS (I assume I need to auto-enter matching/pre-defined POS here) TARGET -------> TARGET ROOT -------> ROOT INDEFINITE FORM (text calc: root plus ending) DEFINITE FORM (text calc: root plus ending) PLURAL FORM (text calc: root plus ending) PROBLEM: With this set up, even after defining fields on the layout, in browse mode the field display says "unrelated table". I am not able to enter any data. I do not know how to trouble shoot this. I suspect it may be quite simple ... My intended workflow is as follows: 1) Manually enter or import words into table ENGLISH 2) Enter or correct field POS (in ENGLISH) 3) in table TARGET, enter TARGET WORD and ROOT With just these three steps, my hope is that the table MASC NOUN will take care of itself. Thank you for your help and consideration. I appreciate it very much. -John
  10. Hi, My students are developing a project in Filemaker using the separation model. The FM data file connects to a MySQL database. I noticed that when updating a foreign key value on the Presentation layer, the view of the value on the related table does not update. Like if the relationship didn't updated. Eg : I have a "buildings" table and a "building_types" table. There is a field "buildings::fk_building_type_id" which is related to "building_types::id". I am using a layout attached to BLD__BUILDINGS in the presentation layer. In the layer, there are two fields "BLD__BUILDINGS::fk_building_type_id" and "bld_BUILDINGTYPES::name". When I change the "fk" the "name" does not update directly. I must commit the record. Doing so in the data file, the update is instantaneous. What is the reason for this behaviour? Thanks for helping
  11. Ultradistance2005

    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.
  12. I am writing a book about privacy and identity, as part of the research phase I am finding that I need several databases. I done OK, so far, but my attempts at creating relational database today has left me stumped. I am ashamed to admit that I have worked in Filemaker for sometime but it is not my regular gig and after returning, post long hiatus, I find I am not so familiar with my old friend. I have to search online for for various terms related to the subject, often in other languages. I have to keep pairs of search terms: English and other language. Paper lists are not cutting it anymore. Its quite possible my concept is flawed, if so, I am more than willing to change tack and redesign. Just started so no major marriage to first try. I created a table named "English" with one field, "English Term" and another table named "German" with one field, "German Term." I then linked the two tables together via those fields. I created a list layout named "English Terms" with a field for the various English terms and a field beside it for German equivalent from that related table. I also created a value list named "English Match" that gets its values from the "English Term" field in table, "English." I tested this list, it works. In a layout named "German" I have a field for the related English terms and it is setup with a popup menu to show those terms from the value list "English Match" and that field is supposed to show those values from "English" table. To the right of that field is the field for German term. The Problem: What is supposed to happen is I click on the "English Terms" field, while the German table, and get a choice of English search terms, pick one and then enter the German equivalent in other field. The goal would be that while English list I could see each matching German term. Once this works I would copy procedure for many other languages. It is not working, while in the German table the English terms field remains unresponsive, no popup menu list appears, so I am unable to choose. Fairly sure that this is a relationship problem of some kind. I am working Filemaker Pro Advanced version 8.0v1. I am on a Mac running Snow Leopard. Thanks for any guidance. Attempted to upload file but received the following error message: "Search_Term_Translation.fp7 You aren't permitted to upload this kind of file?"
  13. I am working with a FileMaker application that was built and maintained in FMP4, and am trying to migrate into FMP11. The files were converted first to .fp5, then imported into FMP11 and coverted to .fp7. Overall the fields, layouts, scripts and security accounts survived the process with only some adjustments. However, there is a problem with deleting records through a portal. Our main DB layout contains a portal to another table in another .fp7 file. The Relationships chart shows the relationship, and has the "Allow creation of records in this table via this relationship" and "Delete related records in this table when a record is deleted in the other table" checkboxes set for the portal source table. New records can be added through the portal with no problem, but when trying to delete I get "This operation cannot be performed because one or more of the relationships between these tables are invalid." Some particulars: The delete button is a container field from another table/file (not the portal source file). The Relationship is keyed on an ID field, but that field is not shown in the portal; the Delete Portal Row script is preceded by a Go to Field[select/Perform] that references a name value field on the portal row. The portal source table has Relationships that also set the "Allow creation of records in this table via this relationship" and "Delete related records in this table when a record is deleted in the other table" checkboxes - so deleting the portal row should also delete rows in that relationship (cascade). Deletion doesn't even work when clicking the "Delete Record" button directly on the DB file. (I've seen on numerous occasions that this particular dialog is unhelpful and I agree - its no more helpful than the Check Engine light in your car). I will also note that this delete functionality DID work in the conversion from .fp3 to .fp5: I can open these .fp5 files in FMP5 and the app works fine. Any thoughts?
  14. Hello everybody, I am working on a Metanalysis DB and I have currently 2 tables: STUDY (Parent) and REFERENCE (Child). The STUDY table has a primary key __pK_StudyID, while the REFERENCE Table has a primary key __pK_RefID and a foreign Key _fK_StudyID. I have set up a relationship one to many between STUDY and REFERENCE so that __pK_StudyID (STUDY) --> _fK_StudyID (REFERENCE), and I have allowed record creation through that relation. Now, as expected, when I create a Portal of REFERENCE fields in the STUDY layout table, I am able to create new records (that is new references for the same study) and fK is automatically populated. What I would like to do though is to be able to auto-populate _fK_StudyID and add new records to the REFERENCE Table using the same layout (i.e. the STUDY layout) but without a portal. If I move the REFERENCE table fields into the STUDY layout (without a portal), everytime I create a new Study, a new reference is created and _fK is auto-populated as expected. The (hopefully silly) problem come when I try to create a new record in the REFERENCE Table (that is to add a new Ref. for the same Study): I have created a simple script that: - Create a variable: $StudyID to store the specific __pK_StudyID - Go to the REFERENCES layout - Create a New Record - Set field _fK_StudyID (of the REFERENCE Table) to have the value stored in $StudyID - Go back to the original (Study) Layout. Now the script works flawlessly, and the new records (i.e. new references) for the specific study are correctly created, so that when I go to the REFERENCES layout I can see them. Unfortunately, in the Study Layout I can see only the first reference I have created, not the additional ones. Of course, when I put the same fields of REFERENCE Table in the STUDY layout inside a portal I can see all new records I have created.... Anyone can give me a reason fro that ? At this time, the only way I have to create study related references (and see them) is changing layout and that is not the most efficient way to face the problem. Thank you always in advance for your help
  15. 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?
  16. 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!
  17. I created a database with a few layouts and one table off of a youtube tutorial and when I tried to customize it a little bit more, I inadvertantly screwed up the relationship between one of my layouts and the table that should go with it. My goal is to have a database for the horses I am training with a tab for the table of training entries I make pertaining to a given horse. I initially created a HorseIDFK field and related it back to the HorseID from the original layout. I wanted to make it so that from the Training table layout, instead of using the ID #, the table used the horse's name but now I've really messed it up. I still have all my training entries, but they are no longer attached to the individual horses (the tabs from the Horse Info layout are empty). Help?! Thank you!!
  18. letitmatter

    Relationship - tables and layouts

    Hi - I'm new to FMforums, but have been reading in here for some time. My challenge is a database, where I need to display some points earned by members in different categories and display their individual points so far - and finally have a tab/layout/button, where new records of points can be entered Plz find file attached. Any help will be appreciated Martin TølbøllClubPoint-vers.-2013.11.05.01.zip
  19. 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
  20. Hi there, In FM13, I have a layout with about 10000 records, i would like to create another layout/duplicate and display only specific records of the 10000 records already existing on the main/old layout, i have a drop down field that defines the category of the records(e.g, Employee, Ex Employee, Accommodation, Embassy, Car Hire etc) - is this possible, by relationship definition or any other way, how?
  21. 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
  22. pctechtv

    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
  23. 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
  24. Ok, BIG newbie. I'm trying to wrap my mind around how to have an item made up of a combination of items, ie: (hot dog + drink + chips; chips + drink; breakfast burrito + drink; etc...or even Hot Dog + Hot Dog + Chips + Drink) What I have are tables with the item categories (easy to keep straight "to me"), such as Hot Dogs, Toppings, Drinks, etc...so I could have a table Specials that would have a line item made up of the combinations. Hope this is making some sense. This is what I have so far (just making tables that make sense "to me" at this point...any advice is appreciated) I'll just attach my starting point db. (EDIT: says I'm not permitted to upload this kind of file...filename.fmp12) PDF attached instead. Also, I wondered how to have a conditional calculation for this scenario: I have multiple hot dog toppings that can be added for one price (.50), but still want the toppings as seperate items. To get a cost per item evaluation at the end of a day; cost of each condiment/retail price is needed to track----so, if customer gets coney sauce, cheese, and onions for example, but customer price is same for ANY/ALL toppings... Clarify: -customer 1 Hot Dog -coney sauce (.50 to customer), but get (cost to us) -customer 2 Hot Dog -coney sauce -onion (.50 to customer), but get (cost to us) -stadium mustard / -customer 3 Hot Dog -saurkraut -cheese -onions (.50 to customer...and a quick need to get to a restroom ), but get (cost to us) -jalapenos / -pickles / Again, I appreciate any insights! Thanks! HHD Menu.pdf
  25. 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

Important Information

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