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
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • 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

  • 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 61 results

  1. What does the superscript letter in the upper left corner of a field mean? I'm trying to relate fields in one table to fields in another table . . . Thanks!
  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. 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
  6. 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
  7. 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?"
  8. 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
  9. 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.
  10. 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
  11. 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?
  12. 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!
  13. 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
  14. 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?
  15. 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.
  16. 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
  17. All files/tables in this discussion are fmp12 using FM 17 and both files are opened when initiating the app. "logging" is opened as the primary file and "claims" is opened as an external data source. I have a table called "newclaim" in "logging" which contains mailing address information including a USPS zip code. I have a table called "lu_ZipCode" in "claims". There is a relationship set between "newclaim" and "zipcode" on a field called "COID" (company ID). This field is automatically populated in both tables with "DCSI". This is an old method (used in Fm6) of establishing a simple relationship so that global fields can be used to pass parameters into scripts for zip code lookup and verification. In the parent script (in "logging") I set the related field "lu_ZipCode::_gZipCode" with (for ex) "12345" with the intent of calling a subscript in "claims" then using "12345" to do the lookup. However when the subscript is called the "_gZipCode" field is empty. As a workaround I called the subscript passing the "12345" as a parameter which of course works as one may expect. After setting the parameter to a local variable in the subscript I'm able to do the lookup then populate the global fields "lu_ZipCode::_gCity" and "lu_ZipCode::_gState" while still in the "claims" file. Yep, sure enough when I go back to the parent file the global fields I just populated are empty. It's worth pointing out here that prior to yesterday "zipcode" was a separate file and the methods described above worked like a charm. This effort is being put forth to consolidate this old FM6 solution with 40+ files into just a few files. I imported "zipcode" into the "claims" file then copied and modified the scripts anticipating that this would be a quick little project to get rid of one more file. I know there are better methods (ie JSON) to get this done and I will probably go that route. At the same time I'm left scratching my head on why this tried and true method doesn't work. Why would global fields I can populate from one side of the relationship not be populated when viewed from the other side?
  18. 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!!
  19. 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
  20. 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
  21. 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
  22. 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.
  23. 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
  24. 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?
  25. 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
  • Create New...

Important Information

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