Portals

Hi All- i have a relatively simple question (i think at least) but i can't seem to figure it out... I have a Master database for DNA sequences from a project i'm working on, and a related sequence database. The master database contains the Organismal identification (genus/species as well as locality etc.) The related sequenceDB consists of dna sequences that i'm generating and is related to the masterDB based on genus/species. Now for the question: In the sequence database, some organisms are sequenced more than once and are distinguished based on an autocalculated serial number. Therefore, in the MasterDB, the portal can contain more than one row.…

Hi, I've been trying to solve this issue for a while. Here is the deal. I have a order table and orderItem table (which track item ordered). orderitem is also linked to Product table. FYI, I had to add productName, productCategory in orderItem table as look-up fied, otherwise, the productName (from Product table) would not show up when I was adding a row. It would after I go to the next row in the portal. I have 2 other tables called ShippingOrder and ShippingOrderItem. When I go to ShippingOrder layout, i click on New which open window where I can select the actual order i want to ship. (shippingOrder layout is for recuring orders). ShippingOrder layou…

I have been trying to figure out how to do the following. I have a Table of Performers linked to a Table of Shows they were in. It is a M to M since one performer can be in many shows and each show can have many performers, thus there is a join that links the two tables and contains the Performer ID & Show ID. I am trying to create the following navigation using a portal... The user selects a show that they want to view. The found set (using a script) becomes the performers in that show. A global Variable in the Performer Table is set to the current show id. The layout that appears is based on the Performer Table and has a portal to the right that relate…

In practicing with portals I created a small DB where I would enter a brand name and I wanted to see in the portal below, all the items previously entered with that brand name. I did a self join on the field brand. I can get the related records to show but only after I exit the layout and then come back to the same record. In MS Access they had a trigger that could be applied when one exited a field. How can I get to see immediate information in the portal when I exit the brand field? What would be the "trigger" for the DB to do what ever it does when I exit and come back? Thanks all and have a safe holiday

I know how to add highlighters to list views but how can I add a highlighter to portal rows? Anyone got an example of this or can tell me how its done?? Thanks Simon

have anybody ever have the following problem?: I have a portal in my data entry layout where the user enter the details of an item for an estimate (to create a new item they press a button setup to run a script to addd a new portal row)..... my problem is that when I try to create a new record (the whole thing, not a new portal), and go click on the buttong to create the first item, the system bring in the information from items previously created (even if it is a new customer and not a repeting one for which I have created items before), if I tell it to delete the portal row, it dooes, and then I click the create the new item again, then it gives me the row with empty …

Hello all, I've been wrestling with a problem I have with the generation of a new record within a portal. I use a script to show the related records within the portal, and if there are no related records present, the script creates a new record and presents me with what seems to be an empty portal awaiting my new record. The catch is that after I've input my data (or even if I don't input any data), and click outside the portal I always get one blank related record appearing at the top. I've tried go to first record, portal row, and can't seem to cause a new related record to be created without getting the bonus blank record. Can anyone shed some light on this? …

I've got my Time database that has a daily time record for an employee for each day with a portal to a related database that has the line items records for each job number they work on and the time increments. In my layout, I've set up the portal to show 25 line items, with a scroll bar that allows additonal records greater than the 25 showing. My desire is to be able to have the employee print a daily time sheet if they'd like that will show all the line items even if it exceeds the 25. Is this possible, if so how? Thanks Jana

Ok, this might not come out the way I mean to say it, but bear with me and PLEASE reply if you are even close to knowing what I'm talking about. I'm totally lost with this right now. SO, what I want to do is in an invoice "description" field; I want to display 1 or more than one description line, depending on the amount of text in the field. Example: Sku: Description: Etc: 123 3' Poles blah blah blah 213 Custom item with blabidy blah blah multiple lines 321 Item no. 3 more blah blah Under Sku: "213" I have a return with the amount of text having more tha…

I need help again from you experts out there!!! .. I need to print a report with data gather from a data entry layout....I need to sort the information depending on the contents of a field selected in the data entry layout. i.e: items to be sold: 1- computer apple 2.- computer ibm 3.- printer laser 4.- scanner twain 5.- printer jet 6.- computer pc 7.- scanner other (selecting scanner, computer, printer from 1 pop-up list, and apple, ibm, etc... from another related pop-up list. Each new item is enter into a portal row created using a add portal row script from with a relationship with data from other database I need it to print as following: …

Ok. I may be confused here so feel free to correct me. So far I've always used portals to show related items to the main one. This is all good and it works for me. Now I face a different problem. I'd like to have a portal of records from one database (like a list view) where items can be checked and then two addditional boxes in the same layout: 1.-A "detailed" box that shows all the stats for the selected item in the portal. 2.-A smaller list that shows the items that have been checked in the main portal. Example (fictional): I have an inventory database. I'd like for one single layout to show a scrolling listing of all possible items in the in…

Is it possible to put buttons on the portal rows? I have them there at present, but they do not appear to be clickable. I have 2 portals to 2 separate files. 1 contains all records and the other contains a user selected subset. I need to button to 'add' from the all, and a button to 'delete' from the subset. Is this possible? Thanks

Hi everyone, Can you help me with this one please? I am running a script from a button within a portal. this shows a dialogue box containing the contents from a related record (using Troi's Dialogue Plug-in) Two other very similar scripts (which are NOT activated from within the portal) work fine, and enable me to view both the contents of the dialogue box and an important field in the current file at the same time. My problem is that although the one running from the portal button shows the dialogue box with the related data in it, the contents of the field in the current file disappears until the dialogue box is cancelled. one clue that might be h…

Hello everyone.. I have a easy one... maybe Setup: Tables: "Main", Policies" On the Policies table I have a field called status -- Active or InActive I wish to make a Portal on the "Main" table that can list all of the actives -- by there last Name. Can anyone help...

Hello Everyone... Here is the situation... I have tables named: "Main", "Policies", "Beneficaries", "Premiums" The relationship between them is: Main has a portal on it that shows all policies relating to the customer Policies has many portals on it; 1 showing all beneficaries on it and 2, shows all premium information on it.. They all work well.. I have now tried to make a report that combines all of these and I am having some trouble.... How do I make a report that can show multipule lines... Let me explan a little better.. I have made a report that uses premiums as it informational start...this works well to show all the premiums f…

Hello Everyone... I really need help with this one... Here is the situation: I have 2 tables: "Policies" and "Beneficaries" On table 1 "Policies" I have a portal linked to "Beneficaries" on this portal you can fill in name address etc... things like this... I have a contract that only allows for one beneficary at a time on it...SO if I have lets say 2 portal rows each one being a beneficary..Is there a way to print the same contract, but have it replace the beneficary each time it prints until there are no beneficaries left...there could be more than 2.. Help? Joseph

Hi everyone... Here is the situation... I have 2 tables -- "Policies" & "Premiums" On the "Policies" table there is a Portal that shows "Premiums" relating to that Policy only. Simple so far.. I wanted to make a report that would print some policy information and all of the lines of the "Premiums" portal...(Only the ones which relate to the file I am on). Can some one show me how to do this or show me an example of a file that does this... Thanks Joseph

Hi all, what is the simplest way to do a count on a portal and how can i do this so that it can count via a certain value list? Thanks for any help Simon

What

Hi, I learn that in FMP7 we can set up such that in the same record when user clicks out of the portal, the same records will stay displayed in the portal. I could not figure out. Any advised? Thanks

I remember seeing a tech note or publication somewhere demonstrating how to use a portal to show matching records for a search. It would display matches dynamically as data was entered into the search fields. I'm looking for a simple solution to search only first and last name and an identifier number, 3 or 4 fields. How is this done. I remeber the use of a repeating field with calculations for the data fields....

I'm creating a text field which will generate a text flag via calculation that indicates all of the line items in my portal meet a certain criteria, (ie. "complete" status of related purchase order records from my related purchase orders database). I tried the following calculation but it is generating the text flag if ANY of the items meet the criteria rather than if ALL meet the criteria: Case(PurchaseOrders::POStatus = "Complete", "All outstanding PO's are completed") What can I change in my calculation, or what other approach can I use? Thanks!

Hi all: I'm just working on a project in FMP7, and find that a couple of my portals are displaying very strange behavior indeed. Every now and then I'll reopen the project and find that the fields in a portal are no longer defined correctly. The layout is right, but the actual field definitions have changed. Granted, I've been fiddling with some relationship definitions, but the changes only manifest themselves when I close and then reopen the file. I have yet to try to replicate this behavior on purpose due to lack of time, but wondered if anyone had seen this sort of thing? -Stanley

Howdy All: I have a relationship set up between two files in my solution. I am asking the users to do a fairly basic find of which the results are displayed in a portal. From this portal, i need to have them select one or two records that apply to the project they are working on, and have those records copy to a table where they can add more detailed notes and follow-up info. I have run head first into a brick wall on most attempts to make this fly. Any thoughts at all? Thanks Lakota

have a question. is there anyway to format information gather in a portal in a non-portal way (as a sentence):.I have a data entry layout that gathers information using a portal (it is for a sales department and when the sales rep is creating a bid for a custumer he creates new portal rows for each item.). in the report/print out layout, I have a portal that display the information gathered from the data entry layout throough a portal, but was wondering if I could get filemaker to display some of the information gathered in the portal as a [color:"blue"] sentence. (with programing languages such as C, I would either use an array, a loop or similar to give a new name to…

Hi all, I am trying to create a portal with a flexible comment (text) field. For example, if you user type only one line, the portal would resize that row to display only one line of text. If the field is 5 lines, the portal displays 5 lines for the field in that row, while display differently for other rows. Does anyone know if it's possible to do that in filemaker? Thanks, Ha Pham.

Can anyone please help me sort this out. I've got two related databases (Time and Time Line)...Time creates a daily time sheet for each employee and the related Time Line database records are generated via a portal in the TIme database for each time increment related to a specific job number. My challenge is that I need to have the portal rows sort by Begin time automatically when an employee enters a new portal line that could be for a time increment that's earlier than one that's already been entered. Ie. if the portal records are created in the following order, then I want it to automatically sort the 7:00a Begin time before the 9:00a Begin time. 9:00a - 10:…

Hi, I was wondering if anyone knew of a way to change the layout of a portal so that it laid out across as well as down. In other words, I have a layout with a portal into another file which is related via a code. The portal shows a container (containing an image file). What I want to do more than anything is to have this in a 4x4 format rather than a 1x8 (ie, I want to be able to display the images like thumbnails on a contact sheet. Is this possible at all? Thanks a lot

Hello All: I am stuck here. I have two tables in my database that are direct imports from Excel data. I am trying to use one of the tables as a search form and have the results from the second table display for the users to interact with. I think I am looking for a portal solution, but im not sure. Any thoughts would be great. Thanks Lakota

Post deleted by spk

I have portal only one row (scroll bar active but transparent) and I have buttons Next/Previous/First/Last to move forward and back through the questions in the portal (using script Go To Portal Row [...]). This works fine except the first time going to the layout - person needs to click NEXT twice before it works (understandably, I guess, since there was no 'previous.') But another problem ... Person needs to be able to edit the questions - access to each field - but every time I click on the portal (except specifically into a field) the whole thing lights up and tries to select. I have made sure all fields are set to just enter field and not select all content…

I'm working with two databases - the first "CustomerData" contains a portal to "ItemSales". CustomerData is customer contact information, billing address, shipping address, etc. ItemSales is purchase information So when I view CustomerData I can see their purchase activity from within the portal. My problem is: I'm trying to define a calculation field in CustomerData that returns the last InvoiceDate (the most recent one) from the ItemSales data inside the portal. For example if I have 3 sales records for a customer showing inside the portal, each record begins by showing the InvoiceDate field.... 1. 6/4/03, ......... 2. 12/15/03, ....... 3.…

I wonder if anyone can help? I have tried to use the normal lookup function based on various relationship configurations to no avail. Looks like a portal is the way forward but I am not sure if you can use a lookup within the portal I have 2 Tables Table 1 Fields Sample No. 1 Sample Details No. 1 Sample No. 2 Sample Details No. 2 etc up to 10 sets Table 2 Sample No. 1 Sample Details No. 1 Sample No. 2 Sample Details No. 2 etc up to 4 sets In Table 2 the Sample Details field is set up as a pop up list based on a concatenated value list of all the Sample No. 1, Sample No. 2 etc records in Table 1. The list of matched return…

We have several houses, apartments, etc for hire. I'm preparing a dB to control the reservations. I have two files: reservations has the records of every reservation (datein, dateout, house, etc). The second file is the parent one, in which I have a portal. the relation is one to many by the field house: then I can see the reservations for a single house. I would like to filter this portal in order to see only the reservations for a period of time (actual month, three months, or from one date to another). I've been thinking in a calculated field like: housename & datein & PM & housename & month(datein) But whan if the date range doesn't match wi…

Hi everyone, I am trying to highlight an overdue tasks on my portal. This is what I have so far. The name of the task has a calculated value: Case (Get(CurrentDate) - T_DUE_DATE > 0; TextStyleAdd(Red(T_NAME);Bold); TextStyleAdd(Black(T_NAME);Plain)) Red and Black are custom functions; They do work. Now here is my problem. If I create a task and I entered the due date and that due date is prior to today's date, The task is colored red. For all those tasks that were entered prior and show a due date prior to today, they are ignored. If I go back and reenter the same date, they change the text color to red. I am beginning to think that tomo…

hi all I'M TRYING TO GET THE OMIT RECORED'S LIST IN THE PORTAL ( 10 ROW'S) BUT CAN SEE THAT I GET THE LIST LIKE - 10 TIMES 1th REC THEN 10 TIMES 2th REC AND SO ON . thanks for quick answer RUB FileMaker Version: 6 Platform: Windows XP

When I was learning to set up portals last winter, I remember stumbling across a setting for a portal that allowed the rows in a portal to be columns instead (vertical vs. horizontal). I can't seem to find where that setting is. Does anyone know how to do that, or did I dream it? Thanks FileMaker Version: 5 Platform: Mac OS X Jaguar

Just got my copy of FM7 Dev this past week--moving all the way up from FM3--which didn't have portals (I think they arrived in v. 4?). I'm beginning to figure out some of the "ins and outs" of portals (pun only partly intended;), but I have a lot of new stuff to figure out here. Since there are no FM7 books on the market yet, would a FM6 vol. be useful to learn the portal system? Or have there been substantive changes in how portals work in v. 7? If so, any recom. on what book might be most helpful? I know FM3 fairly well, and though 7 has a familiar look and feel, I'm discovering just how much more is hidden under the simple interface. Thanks, Decker FileM…

I am a beginner on FMPro, setting up a portal to view related records in an inventory from a related file. The records and the fields I specified show up OK, but there are no scroll bars at the edge of the Portal. I can click where I think they should be, and the records precess, but its almost like there are two sets of hidden bars as they skip around. I've only been using it for 2 weeks, but the manual is so paltry, I can't figure out what I'm doing wrong. Thanks for any help! GWilson FileMaker Version: 7 Platform: Mac OS X Jaguar

Hey Everybody, hopefully I'm not repeating a post b/c I looked around but I'm trying to figure out exactly how to use a script to find the sum of some displayed figures... Basically our database is set up for donators of which you can view the history of each particular person or company via a portal with the pertinent information. Basically, I want to write a script for a calculation field found underneath the portal that takes the Amount field from each donation instance in the portal and sums them up and places the grand total in the calculation field "Total". Every script I have tried just adds the values in a horizontal fashion but we need it to go down the l…

I have a portal that hold a subject line and a date line...they are lined by the company name. Really a call log that I made. All I want to do is have the most recent date (newest entry) show up on a differnt form and maybe a report. Is there a simple way to do this. FileMaker Version: 6 Platform: Windows 2000

I have two tables, Visits with a record for each patient visit, VisitCharges with many records for each charge for that visit. I have a relationship with the VisitID to the many VisitCharges (VisitToVisitCharges) and a portal works great to show all the charges for that visit. I then have a selfjoining portal from Visit to Visit that works great to show each visit in a horizontal fashion, each column shows one row and has a differing starting row. I then created a VisitToVisitToVisitCharge relationship. My problem is when I place the portal with the VisitCharges in this VisitToVisit portal, nothing shows. I believe I have the relationship correct because when the fie…

Hi guys/gals, I hope you're all doing well. I have a question that doesn't really matter but would be nice. If you have a button in a portal row to Set Field [whatever] to a value that will then switch the portal row relationship to another, you have to click out of the portal and almost off screen before it refreshes both portal windows. Is there something I can add to my script which will refresh the window without having to do this? I tried adding in REFRESH WINDOW but that seems to be for something different. Also, one more thing - in FM7 you can have multi windows. They are independant from each other - if i scroll through records in one window…

I have images in a container field that I am displaying in a series of portals to simulate a sheet of image thumbnails. The concept is working fine, with the exception of a minor glitch when viewing the file over the internet. In layout, I have chosen the graphic format options of "Reduce or Enlarge" and "Maintain original proportions". This format works fine when viewing the portal from within FM7, but when viewed through a browser, some of the images are distorted, ie it appears to ignore the "Maintain original proportions" option. Has anyone got any suggestions? FileMaker Version: 7 Platform: Mac OS X Panther

Hi, I'm trying to set up several fields such that when you select a value in one, the options for the other fields are decreased. The fields will contain stuff like Company, Product, Size, etc. When a specific Company is selected, the available products from that company are narrowed down. And then when a specific Product is chosen, the available Sizes are further decreased. Also, I would like to have the order of selection be variable. (I have a separate file with Company names, products available from that company, and their sizes.) I tried doing this with portals, but couldn't get anywhere. Any help is much appreciated. Thanks in advance! …

I have a database that I use to track Mortgages. I have a contact log, which is a portal, that I use related scripts to do data entry. (Keeping the phantom record out of my portal.) Last week, I made some updates to the database, mostly layout changes, and now, new records will not show up in the portal. All records that were previously there, are still there, and new records I put in, show up in the "Contact Log" child file. However, new records don't show in the portal itself. I've rebuilt the portal, the relationship, and the fields. Same thing. Another strange aspect, I went into the child DB directly, and duplicated a record that is still showing up, and…

Hey, I'm developing a Contact Management System for a school team project and we're a little new to filemaker pro. Very new actually. We're working with FileMaker Pro 7 and need to if and how to mix different fields from related tables in a single portal. Here's the deal: The client wants a Contact Activity Log, tracking communication and donation activity. The Communication and Donation are related back to Contacts via 1-to-M relationship Contact Table (ContactID, Name) Communication Table (ContactID, MessageID, Message, Date) Donation Table (ContactID, DonationID, Amount, Date) For a given contact, I can get a portal to show either the related c…

Hi, Lets say I have: "ITEMS INFO" with three records, being the field "name" content "A","B" and "C" "INVENTORY OF ITEMS", related by "name" to "ITEMS INFO", with six records: A,A,A,B,B,C Can I have a portal in "ITEMS INFO" so it can show and inventory, as follows? A: 3 B: 2 C: 1 Thanks in advance! FileMaker Version: 5 Platform: Windows XP

Hi, First ever post so here goes... Overview I am trying to create a portal showing all the unpaid invoices for a client. The ultimate goal is to have a button to produce an individual client statement of amounts due. Structure I have a client table, an invoice table and a payments table. The fields I'm using are 'client ref' and 'pay status'. 'Pay status' is calculated by taking the sum of payments in the payments table ('due') and subtracting it from the invoice total ('total'). The calc for 'pay status' is If(due=0,"paid", "unpaid") The Problem I'm trying to define a relationship between the client and invoices table based on a calculated…

I have a self-join relation and a portal based on that. Within the portal I want a calc field to compare the value of a field in the portal, with the value for the current record (outside the portal). There seems to be no way to get them both at the same time. If I base my calc on the portal's relation, I can get the portal row's field value, but not the current record's field value (it evaluates to the related value). If I base it on the current layout, I can't get the portal row's value. Any ideas? FileMaker Version: Dev 7 Platform: Mac OS X Panther

Hopefully there is an easy answer to this: My invoices file has a portal that contains client files from a related file. If they have paid, the paid field says "yes", if they have not paid the field says "no". Let's say I have a client that has not paid for 3 items and those 3 items show in the portal. When they have paid, I would like a script that would change the 3 portal row paid fields from "no" to "yes". Thanks in advance for you help - sam FileMaker Version: 6 Platform: Mac OS X Panther

I have 6 views of the exact same data - in two of the views, the data is filtered based on different globals, in the other 4 of the views, the data is sorted differently. Is there a way to Duplicate Layout, change the portal to the appropriate relationship and then do something (other than having to reset each field - there are 25 per layout) that will force the fields to take on that relationship?

This is my first FM and contains the in/out post between my office and others in diferent cities. I made one file (register) and two related files (in and out): each record with the fields (from, to, date, reference, issue, reference out). In the register file I made two layouts (in and out), each one with a portal that shows and filters the records. I would like to automatize one thing. When I create a new record in the out portal, and I type de "reference" field, I'd like FM to find this record in the "in" portal, type the reference in the "reference out" field and get the "issue" field value and type it back in the "issue" field in the "out" portal. I don't know …

In my invoices file I have a global value list to check on a customers paid status. Value list = yes, no and all. I have created a calculation field in invoices: paid_filter & " " & customer_id The paid_filter is the global field that has the value list. In the right hand portal relationship I have creaded a calculation field: Paid & " " & customer_id & "

We use filemaker for publishing of books and we want to use filemaker to also create our flatplans onscreen - this makes sense as the databse holds all our production details. So what is needed is a layout where there are 32 records per page. These have to be in four rows of eight,so the page is landscape. Now this can be easily done by setting up the layout to have 8 columns across etc which can be seen in preview mode. However in preview mode you cant access the data. For that you have to go to browse mode which reverts to a single column. This is no good, we want to be able to access data while in the layout mentioned before. I figured that this could …

Hi there, i wish to create some calculation field to validate the record inside a portal. For example if a field length more than 15 characters then it will display a message to let user know. Now my problem is the validation field is out site the portal and i will only display the validation message for the first record of the portal. If the fiest portal record contain no error but the second record contain error, it will not display anything. What i need is to display out the corrent error message inside a portal list, not only the first record. I have attatch 2 sample testing files that let you all know more clearly about what problem i face. Regards, Henry…

When I show a portal on my main Form Page and submit data, the portal rows are not consistant. It will show the first 3-4 rows ok, but then starts leaving related rows out of the Form View. Is there a limit as to how many rows can be shown? Ar portals just sporadic within IWP? Thanks for any help you can give me. Very frustrated. Version: Developer v6 Platform: Windows 2000

Hi All, I have a portalk with 3 fields, I want to know from the main page ...i have 3 buttons, I want each button to sort each field in portal as I want. Is there a way to do so since the relationship from portal and main page is sorted already, i can not change anything? Any help Thanks Version: Developer v6 Platform: Windows 95/98

i have trial 7 - i created three simple relational tables suppliers, components & products products contain many components in 6 all in well same theory in 7 doesnt allow me to into into the portal I have created to list all components and their various quantities ::?? what am i missing : Marcia

What I am trying to do is to move lots of info into a portal using a script. I have about 90 lines and for each line I want to make a new record via a portal, so i can create some reports in another database. I wrote a few lines in my script..Surmized..copy field 1 row 1;paste field 1 row 1, and it goes to the right fields in the portal. Now when i go to copy the second line (the portal does allow creation of records), it pastes it over the first record. I Tried using the, goto portal row (next), but that works like firetruck without water! Thanx think [outside the box] Version: v6.x Platform: Windows 2000

Gday all, I have two tables, one for Schools and one for Students, with a one-to-many relationship set up using SchoolID::SchoolID. I have a Portal in Schools displaying the students for each school, that's all working fine. Now I need to be able to refine this list by various properties, a couple of which can be drop down lists (student classes, grading), a couple are wildcard text comparison (names etc). I have read many many posts on this problem on this board and others, and I understand the issue as presented in djgogi's Article (http://www.fmforums.com/threads/showflat.php?Number=54888), that using Find in the portal will only search the Schools tabl…

Greetings everyone. Sorry for the newbie stuff, but having followed the manual to the letter ( I believe), and reading many of the portal-related emails here, after several days I still need help... I

Hi all I have a portal that i want to use for finding drawing number. I have create a simple script that would goto related records Goto to Layout Main Goto related records (show only related) And attached this to a field in the portal. Put when someone picks a record the first record in the portal is shown, no better which record is chosen. I have create a self join relational to create the portal and the related record script is base on this relationship, What am i going wrong. I an using FM 6. Thanks in advance Lionel

Hi, I have a portal with a delete graphic (a global) in the portal row. Unfortunately the graphic shows in the new entry row at the base of the portal (background formatting to the other fields shows too). I can see people trying to delete what seems like an empty record. Can I get the last portal row to not show any formatting? thanks Version: v6.x Platform: Mac OS X Panther

This project is for a school. I have a group of records with data: State_________Days_______Billing Days PA____________29 PA____________60 PA____________193 What I need to occur is have Billing Days be a calculation that says if any of the Day fields are over 180, put the following calc: If(Days >180, 180, Days). So the data would look like: State_________Days________Billing Days PA____________29____________29 PA____________60____________60 PA____________193__________180 But this should only happen if one or more of the State records has over 180 in one of the Day fields. If the records look like the …

Okay here is the situation, I have four tables; events, group, students and schools. I want a portal on the events layout to display information based on data from the group, students and schools tables. Where lationships between the tables flow like this: { events -> groups -> students -> schools } events::Id -> group::Id group::studentId -> students::studentId students::locationNo -> schools:locationNo Here is a sample of the table schemas EVENTS: eventId eventName ... GROUP: eventId studentId studentName currentAge currentGrade currentSchool ... STUDENTS: studentId studentName studentDateOfB…

Hello everyone. First post, but have received tons of info on here already. Thank you. I have a DB that has 5 tables. One is equipment.fp5 and one is who_had_last.fp5. The relationship is based on an Inventory_NO field in both. When a tool is checked out, the check_out date is filled in along with Assigned_to. When it is brought back in, the user presses a button that runs a script to put in the current date to the Check_out date field, and the warehouse it was returned to. They were wanting a way to track who had that tool last. I came up with adding to the script to move the data from Check_out date and Assigned to over to the who had last.fp5 file. …

I have a pop-up list field and a portal. I would like to make each new record in the portal contain the information selected in the pop-up list. I tried using a global field, but this interfered with other areas of the database. By dropping the pop-up list in the portal, I can get the info to show in the first portal row, but no subsequent portal rows. Any ideas how to get this to work? Would like to avoid scripts if possible. Thank You. Version: v6.x Platform: Windows XP

I have a calculation that uses future (planned)invoice record totals. These future invoice records are presented to the user via a portal. When a future invoice record (located in another file) is deleted from the portal (delete portal row button)the calculation doesn't immediately update. However, if you change the invoice total in the portal the amounts update. This seems strange. In addition, after deleting a record, the calc field will show the result of the deletion once another field being used in the calculation is changed. I don't know is this is important, but I am using a "sum" operator in the calculation. Please help. I would like the deletion of a r…

I have an Events Table (fundraising Events). I have another table that has Categories - each event can have its own Donor Categories, and the user can add categories as they wish for the event via a portal. So, they have entered "Donors", "Silent Auction", "Program", etc. to record the various categories for that Event. The portal on the Event Form selects records in the EvtCat table where Event::RecordID = EvtCat::parentRecordID. Now, of course they want sub categories added - and so I created a SubCat Table so that for example the Donor Category could have "Gold", "Silver", "Bronze" etc for the level that the donor contributed. So on the same Events Form I would like…

Hello, Is it possible to have a calc field the calculates only on defined lines of a portal. eg a 'sum' calc for only the top three records in the portal?

Hi, I'm sorry if this has previously been discussed, I haven't been able to find anything on it. I have a portal with listings from a column of a related database. I would like that portal to display instead as a string, with each entree separated by a comma. For instance, if "red", "green, and "blue" were all entrees in this field, I would like to create a layout that says: "red, green, and blue" (will the ending and be a problem?). Thanks, Jeremy

I am really stumped on this one...perhaps it is too late in the evening. I have successfully implemented the technique that will allow a user to enter a range of dates from a parent and then display all of the records in the child. I need to specify a date in the parent (say 3/10/2004) and then display all of the records from the child where Field1, Field2, Field3 or Field4 match that date. Any ideas? Thanks

Well, I am excited and ready to explore, but I was so hoping that they would give us a better portal scroll, not one that pops back to the top when you click out. Oh well.

Is it possible to export part of a record, that has been filled in with a portal, to another database table? I would hope to do this with a button on the record's line in the portal.

Hi all, I am building an application and am really stuck with this issue, perhaps someone could help. What I would like to do is have a portal automatically size itself (in terms of the number of rows) to fit all the contents. This may sound confusing, but here is how I am using it: I have an order form, with a portal to another record containing line items. Using the same record as the orderform, I have created another layout, which is the invoice for the order, but just for printing (not data entry) purposes. The problem is: If I start with a portal of say 10 rows, I need it to add more rows if I have say 14 items. Can anyone help with this st…

Is it possible to enable a pop-up list set up in a database table, to function when that table is viewed in a portal?

Hello! I've got a problem and hope that someone can solve it for me. I've have on file with undefined number of records. Each record contains two fields. One field is a text field and contains different kinds of training intensities (A1,A2,A3 etc). The other field is a container field containing a colarbar. Then I've a second file with a greater number of fields (maybe 15). One of these fields uses a valuelist based on the values from the text field in the first file. Finaly I've a third file wich is a calender. It contains portals which through a relationship will show values from the second file. This file works fine overall but I'm trying to use the color…

Hi, I have a several portals setup in a main window. I would like to be able to set a transparent button over the area of the portal so that when I click anywhere in a portal row, it takes me to that record. Is there anyway to do this.

I finally set-up my portal properly. The way that it was explained to me. I went to select data in the field (pop up list of data) and then this error message popped up - "This field cannot be modified until "studentID" is given a valid value." I am an extreme beginner in FMP. If anyone can please help, I would really appreciate it. Thanks Geeker

Hi all I am trying to get the portal to sort by employee last name after finding which company they are working for.Press the button in the upper right corner to goto the layout for the portal. The view layout sort properly but the portal does not. What am i doing wrong. Thanks in advance Lionel company.zip

We have a basic PO tracking program. Currently we have just under 4000 entries. One of our accounting personnel noticed that portal info (data) that indicates purchased items and their prices are slowly being removed from the data base. It currently is deleting data from the back and moving forward with new entries. The quirk with this is sometimes it skips some of the old entries in the process. We have paper backup to confirm that the data was originally entered. Any thoughts from anyone would be greatly appreciated. The files are stored on a central independent server with access from a variety of staff. Thanks in advance, -Mr. Morning

have a portal with dynamic value lists and relationships based on globals. Here's my issue... If I don't click outside the value lists, I can keep changing global fields and the portal updates automatically. Otherwise, it seems to stick and I have to continue to manually click outside the lists to get the portal to update. Why will FM cease to recognize the changes in the global fields once until I click outside the lists? Thanks. -Ruth

I have a main file "Contacts" with a portal showing 2 fields from another file "Donations"(Related by Contact ID). The fields in the portal are "Date" and "Ammount". I want a script that will perform a Find using a logical "and" between "Date" and "Ammount". Currently it performs a logical "or" Find. The only solution I have been able to find, requires concatenation of the 2 fields in the portal. Is there another way to do this? Thank you, Chipper

I use a key field in each database for relationship. There are 3 records that should show in portal, but only the first is showing - 3 times! What is it???

Hi All, I have spent a while trying to solve this question on the forum before asking this of you ! I have created 4 files. Invoice + Customers + Items + Ordered. The invoice file is the control file in this instance which presents the other 3 files as portals. They exchange data AOK,,,,whooopeee ;-) 2 Of the portals have a script attached to pull of records and enter them in the invoice file. The customer file has in excess of 2000 records and displays 6 rows in the portal. I wish to search the portal by name or part of name but due to the attached script I am unable to enter data in the portal row whilst in find mode. I have made several perhaps clumsy at…

Has any one got any examples of stopping deduplication in a portal. Using portals to display contacts with in a company if someone enters a similiar first name it flags it and then if someone enters a similar surname it flags it. Any help would be appreciated Thanks Simon

How can I show multiple records from two fields which sometimes match and sometimes don't, on one portal row? I'd like the end result to look like this: txt_Name.fp6 Ptl_Associated record(s).fp6 Fred 1,7,99 Joe 4 Rick 2,3,5 Etc... #1.) I cannot figure out how to derive Txt_Name.fp5 from two different fields: Txt_Composer.fp6 and Txt_Author.fp6, where Txt_Composer.fp6 sometimes matches Txt_Author.fp6, only return one record/ match. Where Txt_Composer.fp6 and Txt_Author.fp6 don't match, it should return two seperate records. #2.)I cannot find a way to make a portal show the wa…

I am using a FilemakerPro calendar that utilizes a portal. Is there a way to back-up the data or even export it out of the portal? Thanks! Tarheelfan

Hello, I am having a problem with a portal I have created. It displays data from a related field (about 4 columns), ,but the last line of the portal will not let me enter data into the portal. I have seen other files that allowed this, but it is not an option for mine. Can I fix this? Thank you.

I have a question regarding the way I am using portals in my database. I am new to Filemaker and have just begun to learn about scripts and calculations. My database is used for patient records. I would like to keep track of various other service providers that these patients see, such as orthotists, medical clinics, doctors etc. I have a contacts database which lists all the other service providers and need to associate them with the patient record. Originally I just used a lookup field to pick the contacts unique ID number, used relationship fields to show some of their basic info and a button which would go to the related record. However this se…

I have a DB where users only access one blank ("view") record, populated with a portal based on a constant that makes all other records (in the same DB) appear in the portal. This is the names of Special Projects we have open. They click on the record they want and are brought to that record. From there, they are linked to all the info for the Special Project, portals to stores involved, vendors involved, etc. Works perfectly when it was me developing it. However, I just discovered that when anyone is scrolling the portal, the "view" record is locked, so no one else can scroll. I then replaced the "view" record with 10 "view" records, and each user is sent t…

Hi I want to show 5 related fields from a related file in a portal. When I create a portal, it appears with only one column. How do I configure the portal columns (related fields) I want to display? Thanks Alain

I need to create a script that will add a new record in a protal at the line where the cursor is situated. The new record step just throws me to the last line of the portal. Am I missing a step somewhere . Any help would be really appeciated. Many thanks

Hi, I have a portal in a primary file that has 2 fields from a file related by Resource Number. The parent field is Resource Type and the child field is Resource Name. Both fields have value lists with drop downs. I want to have the capability to select a Resource Type and have all of the Resource Names with this particular type appear all at once in the portal. I also need the capability to choose more than one Resource Type. Some Resoure Types may have 100 or more Resource Names. At present we are choosing them one by one. All suggestions are appreciated!

I am working on a project management type system. Part of the project report will be a portal which lists "involved people." I have a couple questions about how I should set this up. The portal would look something like this: -------- ------------------------------------------------- [ menu ] First Name_______________________________________ Last Name________________________________________ Company__________________________________________ -------- ------------------------------------------------- [ menu ] First Name_______________________________________ Last Name________________________________________ Co…

Hi all I have create a type ahead portal, but i have one question. How do you keep the curor form leaving the field you are typeing in and going into one of the fields in the portal after you type the first letter and press the tab button on the key broad. I have reviewed Russ namefinder and he has formatted the fields for "do not allow enrty" and have also reviewed Ugo type ahead sample and he has a Go button but you have to click in the type field everything time to push the button. If you press the tab button in Ugo example,you goto a field inside the portal. We have a contact db that has about two hundred names in it. Our sales people would like to search the db f…

Hi! I'm wondering if there's a way to display portals in columns instead of rows? Thanks for any input!

Hello, What is the found set in a portal? When searching for specific records the portal of course has all the associated records with it. Does this mean functions like lookups etc will apply to all the records? Or am I just hopelessly confused? Thanks, Glenn

This is my first time on this forum,So bear with me guys.I have a done a invoicing system on the lines of the one shown at http://www.maclane.com/portinv.htm .It is extactly the same ,except In the Inventory file I have added a new field called "Qty" holding the stock quantity of the product.And also added a button called "Process" to the Invoice file.What I want to do is when I click this button I want to run a script that will substract the oder quantity in the line items file from the stock quantity in the Inventory file.Every way I try to do this only the first entry in the Inventory gets udated.Please not that the invoice line items are displayed in a portal in the I…