Portals

Anyone know of a good way to snap shot the displayed row range of any given portal? I.E. the top most displayed portal row is 17 and the bottom is 26 for a 10 row portal. Running scripts always horks portal row positions and I'd like to restore the portal to the way it was before the script ran. Thanks

I have three tables: STORES --< PRODUCTS >-- CATEGORIES Each store can hold many products (one-to-many relationship). And each product belongs to one of several categories. Several products can share the same category. So, for example, the "Main Street" store might have the products "Frog Fountain", "Copper Birdbath", and "Lion Fountain" in stock. The "Frog Fountain" and the "Lion Fountain" are each assigned "Fountain" category. The "Copper Birdbath" is assigned the "Birdbath" category. When I'm on a STORE layout, I'd like to see a list of products in stock. That's easy: I just create a portal between STORES and PRODUCTS. However, I would l…

Over the last year I've become fairly comfortable with portals but this one has me stumped. Excuse my typing but I have the flu...so don't get too close to this post! I've overlayed an object over a portal and placed several fields on top of that. No matter what I try I cannot keep the user from entering into a portal row or a field inside the portal. I've set the fields in the portal to "no entry", I've tried overlaying an object over the entire portal then placing my object and fields on top of that, I've placed a large field over the entire portal set it so that it can't be entered, locked it and got a notary to stamp it. Still no good. When I say I'm…

Hi, I'm a bit over my head here and would be grateful for any ideas that anyone has about this problem. I'm working on a student database for my department. This database (whose relationship layout is attached in a pdf) has tables for students, teachers, and courses, and a join table called Enrollment that serves to show which students are in which courses and to hold the grades and attendance records. What I'm having trouble with is creating a layout that shows, for each teacher, a list of all students in his/her classes, and for each of those students, a list of all their grades in each of their classes. So each line of the report needs to have the student …

I have two fields in a portal: Resource and Amounts. The resource field is based on a conditional relationship, which works fine, except that it does not display values until something is entered into the amounts field--it would be better to have the resource values display from the beginning. If I have the amounts field auto-enter a zero, that succeeds in creating resource values up front, but it only works for the first row in the portal, not subsequent ones. Any ideas how I can get the resource values to show up initially in each row?

We have a Registrant table and a Program table in our non-credit database and I'm having an issue trying to filer the list of registrants in the portal that resides on the Program layout. Each registrant in the Registrant table has a status within the program; Active, Completed, or Cancelled. The Program table contains a portal displaying all those that have registered for the program. I would like to filter the portal out to only display those registrants that are listed as Active in the Registrants table and I'm not sure how to do that...if it's even possible. Thoughts? And sorry for the newbie question. Thank you.

Hello, i have a layout (diary) that show a complete week from monday to sunday and on that layout i have portal of another occurrence of diary (diary_p) related by X on Diary_ID that shows all the weeks in the diary (1 per row of the portal). when i enter the layout Diary i have a script that goes to the portal row of the current week. My problem is when i change the record of Diary the portal of diary_p goes back to the first row even tho i have the portal option "reset portal when exiting record" unchecked. I would like to have the portal row stay where it was. Any help would be greatly appriciated. Thanks mfrapp

I have a portal that lists current records correctly. I placed a button next to each record so i can go to that record and print same. The script for the button involves omitting the record so it previews alone from the other records and calculates correct page numbering etc. When i always run the script the first time in this portal layout, it previews all records which is not what i want but when i go back after the first script run and try it again and again, it works correctly. What is causing the script to list all records in preview mode the first time? Here is my script? Any help is much appreciated. Go to Related Record [From Table etc.etc…

Hi, Can anyone tell me how i can sort the contents of a Portal by a field in a related table? For example, I have master table and layout with a portal showing data relating to the LINE ITEMS table. The LINE ITEMS table has a primary key, ProductID Foreign Key, Quantity, etc. and a separate PRODUCTS table from which i import the contents of of the primary key ProductID into the foreign key ProductID in the LINE ITEMS table. Thus the LINE ITEMS table is populated every time i run the import script with say 100 records (for 100 products) placing the ProductID in the aforementioned foreign key field. I have chosen not to show the ProductID in the porta…

It's my first time to actually try this. I have an art database with three tables Artwork, Inventory (supplies) and Inventory Used. In the Artwork layout, I'm trying to show two portals: One with all the Inventory items with a search box and the other will have a list of inventory items used to create the art. I'm having a problem searching the portal using a global constant ("1") compared to a pattern count of the search string. I have all three tables related with two extra instances of the Inventory table used to list all of the items and filter them (creating a total of 4 relationships). I'm trying to take the search string and use it in a pattern…

In my database I have a number of relationships built up and a few portals on different forms to display related records (display only, not to add them, if this is important.) But I've started finding a disturbing problem. Say there are 20 records to view in the portal but the portal only has 10 rows. I click on the scroll bar to view more records. Instead of stopping when the last record is reached it keeps going. Sometimes, depending where I am clicking in the scroll bar, it shows repeating blank rows. At other times it simply duplicates the last record over and over again. If I enter one of the rows, the cell or row contents revert to a different "actual" record repres…

Hi, I have a question about calculating portal row count while also trying to adhere to the data separation model. My understanding of TSM is probably shakey, but when calculations are for interface purposes, one should try to keep them out of the data files and in the interface file. Is that correct? I have a situation where I have a contacts layout in an interface file that is based on a TO of the contacts table (in a separate data file). On this layout I have a portal which displays related "letters" that have been written to the contact. Above the portal I'd like to display the count of letters written to the contact. However, I'd like to avoid ha…

I have a Project layout/table with a Project Notes portal to add notes to the project. I am trying to make a button/script that will: 1. Create a new related Note record in the portal 2. Populate a couple of fields in that related record 3. Open a new window (a detail view of the Note record) 4. Commit the record in the original file (so when I start typing in the Detail window it doesn't say "this record is already being modified..."). I think I've figured out everything but committing the record. I think it is committing the record in the popup window, not the original one. I've attached a capture of my script if anyone can help. Thanks much,

Morning, I'm trying to create a database that manages products for sale. The basic setup is very simple. Each product has a unique part number, a manufacturer, a little description, a price and a photo. I would like to be able to search the product database based on the manufacturer and / or the part number. Here's the thing, when I create my layout with a list view, it all works fine. I do not like the list-view look however (the horizontal lines that divide the different parts (header, body, footer) and I also don't like the scroll bar on the side of the window. So, I decided to try to use a portal instead, this way the scroll bar is well within my graphics (…

I'm having trouble entering a new related record in a portal in a new database I have created. I cannot tab to it, or even click on it. I just created a database to consolidate several others that I have used for years. One set is a typical Invoices/Addresses/Products/Lineitems four table database which is working fine. I have exported the Products and LineItems tables to try to create this integrating database. I am now creating a table which records the payments, called Checks. It references the LineItems with CheckNum, so if CheckNum 3401 paid for 2 widgets and 4 gadgets, they show up in a portal in Checks and I get six items for a total of $XX. I put a portal i…

Hello: Am working with two related files, and prefer to add new records to the second file via a portal in the first. Today, I changed the number of rows to display in the portal from 6 to 10. Afterward, I was not able to tab to the next portal row (to create a new record in the related file), as I was able to do before. Now when I press tab, it goes to the next field (outside the portal). Using the mouse, I can place the cursor on the next row, enter the data, and obtain the desired result (i.e., a new record in the second file). But I would prefer to have that tab-to-the-next-row-within-the-portal feature back. Have not been able to puzzle this one out throug…

Is it possible to combine 2 portals into 1. For example. Say you have 4 tables. Tables 1 and 2 have records with identical keys. Is it possible to use table 3 to merge those portals so when you look at a portal(of table 3) in table 4, all the records in tables 1 and 2 are shown? I was just playing around and wondered if this was possible. If there is a better way, I would love to hear it.

I am trying to create a database to keep track of answers to test questions for many students organized into classes. The tests have different numbers of questions, ranging from about 5 to 20, so I need to be able to add tests as I go along, or change the number of questions. I would like a layout on which I would see a list of students in a class and check boxes for each question on a particular test. The checkboxes are because I only need to keep track of whether a particular student got a particular question right or wrong, so they will be set to a value list with a choice of 1. This way I can analyze student scores and test questions based on different classes, gr…

I'm a teacher who has been setting up FM databases for about 10 years, but I've had zero formal training, so I may have just missed something basic. I work with 4 other teachers and we comprise a team. Each quarter, our students complete a project that counts as 1 grade but is made up of 5 parts, graded by the five subject teachers. I set up a simple database with the students' names, class and fields for the five scores and a field to sum them up. Since our students are divided into 5 classes, I set up an interface table with a global field with the choices for the classes (A, B, C, D, E) and related it to the table with the students. My colleagues click on a class …

In my customer entry layout I have a portal with a filter so I can enter C and get all companies starting with a C. If I then go to the List layout all customers starting with a C are shown there as well. But if I perform a search in the list layout and return to the entry layout, the search performed in list view is not shown in the portal, the C customers are still shown. Is this just how it is and all searches should be done in the entry layout or is there something I can do so that no matter where the search is done, that search is shown in the portal as well. Thanks for your help, Milo

For some time I’ve been using repeating fields to hold short-hand keys to data from another table which is then displayed in full on the record via a portal. The repeating field has been the match field for the full data on the other table. But I want to hide the repeating field from my end users, who need to see only the full data displayed in the portal. To achieve this I’ve been using the trick I learnt in this forum of covering the field with another portal which doesn’t display to other users when there is no matching field . (http://fmforums.com/forum/showtopic.php?tid/177010/post/229456/#229456) Now, having also learnt that repeating fields are n…

Is there a way to make the portal have a horizontal scroll instead of a vertical? Thanks

I have four tables, company, contact, parking lot, and sweeping event. In my layout there are three portals I have a portal showing the contacts within the company(portal#1) I have a portal showing the parking lots that the contact manages(portal#2) I have a portal showing the sweeping events for each parking lot (portal#3) When i click on portal#1 I have a script that takes me to portal #2 and gives me a list of parking lots portal #1 and #2 work but, I cannot get the related records from portal#2 to show up in portal#3 Is this possible to have more than two portals related in succession? thanks in advance,

Hi all, I have to compare the price by diffent vendor and check box the buy. Maybe you take some time to see my attachment you with understand. Thank for help! Comparison.zip

I would like to filter a date range within a portal using two fields with a drop down calander. Any one like to make some suggestions?

Is there a way to achieve this? I have a main table (Ticket) which contains many "pages" child records (related table) each of which can have any number of "services". So it's a parent-child-grandchild relationship. I'd ideally like to have the pages display in a one-row portal (which can be set to show a different page by changing the value of a related field) and show a second portal inside listing the related services. I'm thinking this may not be possible, since the grandchild "services" portal would be related to the parent "Ticket" and not its child "pages". However, there's usually a way to convincingly fake these things if you know enough. I know that I …

Is there a way to print portals on a report horizontally through a script or calculation? I have tried to use Line Item reporting but it still lists the field data vertically. I am trying to get the data listed horizontally and comma separated to give a nicer presentation as well as conserve on space/paper. Any ideas appreciated!!

I’m a newbie and I am having problems with portal / record navigation. I have a portal (list) which contains a list of employee’s names. I have a set of nav buttons (first, previous, next, and last) which I want to use to navigate the list portal. I use the selected portal row in the list portal to GTRR in another portal on the same layout which displays an employee record (employee). I first had the nav buttons moving between records, which was fine until the employee names were sorted and the record number no longer coincided with the name’s position on the portal. So I then scripted the nav movements using the portal row number / GTRR and all worke…

I have a portal that users want to see items in the added record order (sorted by ID field), newest item on top. No problem... But then later re-Sort it by a color field to bunch like colored items to together. I can't seem to figure out a way to dynamically allow users to toggle the portal's sort between the ID field and Color field Anyone have a clever trick? Is there a way I'm not seeing? Many thanks.... Dave

I keep track of personnel hours in a lineItem table, all the dates and all the hours. The input of those dates and hours is in an 'Hours' table, in a portal, related to the lineItem table, allow creation of records. Every day a user has to make a new record, fill in the date and the hours. I show those records in the portal based on an ID value. The every day input seems to be too much work, so they want an 'automatic' record generator at the beginning of every month. No problem with that, it is working. They also want to see, in a portal, for every given employee, the records based on 14 days, starting September 1. With a total of hours for e…

I'm hoping someone can tell me why in the world I can't seem to get this to work.. It seems a no brainer, but the loop won't continue beyond the first portal record. Many Thanks... Dave Filemaker 9 Go to Related Record[show only related records; From table: "Nim_OrderQ"; Using layout:" Order BOMS" (NIM_OrderQ)] Go to Portal Row [First] Loop Show Custom Dialog["Test"; SNInventory::ItemCode] Go to Portal Row [Next; Exit after last] End Loop

I have created two tables joined by a join table. My goal is to have a filtered portal on the layout of the first table which displays a filtered list in a portal. I'd like to be able to choose one or more of the records that show in the portal and save them to the record i'm working in. Concrete this means I have a patient who undergoes surgery to a specific region of the body. I'd like a filtered portal to show the types surgery dependent on the selected region. My problem is that the portalfield remains empty. I have read and tried almost all the example files on this forum and can't get it to work. Would somebody please be so kind and patient with to …

Hi all, I need to copy my portal by selection item to other portal layout. At my main file I create a new record with portal item, and now I need to copy the record and selection portal Item to my Main 2 layout. Can this done? Thank for help! Portal_copy.zip

I am trying to print a summary of my invoice. It contains products purchased by customers in a portal. The portal displays perfectly in layout mode but if I print the layout the portal area is completely blank on paper, it also does this if I export to pdf. Additionally if I go from layout mode to Preview mode the portal disappears. I can't figure what I've done wrong in my setup, any help will be appreciated! Thanks

I am struggling with something I think should be easy. I want to display in a portal related records who's parent record has a particular status. No records are displayed. See example.

This is probably simple for old hands, but the problem is this - 1 table with 3 fields: Member (repeating text field), Department (text field), and Item (calculation). Item = if ( Member ≠ ""; Member ; Department ). Each Department includes multiple members. (separate records) Each Member belongs to a variety of departments. I want ONE portal to show: Members if Item = Department (taking values from a relationship) and ... Departments if Item = member (taking values from the CURRENT record) I have no trouble making Members show in the portal when Item = Department with a self-join relationship ... but can't figure out how ALSO to make the D…

Hi. I'm sure the answer to this this is SO simple but as a newbie I'm struggling. In summary, it's about how I can select from a portal to enter a value in a new record. I have a time/billing database. One table is 'Jobs' (ie projects) and another is Time (where I record time spent on the project). When I spend time on a job I create a new record in time, using the right job number. The tables are of course linked. I have a drop down list that allows me to choose the job number when I make an entry in Time. At first, this worked fine but as the number of jobs increases I have to scroll thru an increasingly long list of jobs. It seems there is no way to sort the …

Okay you probably popped in here thinking this question was going to be easy...trust me I searched for an hour on here before I posted. Couldn't find an answer. Here's the deal, I don't want to use the empty portal row. I want more control. I had been using a scripted "new row" button that went to the child layout, created a record, came back to the original layout, and went to a designated "New Row" portal but when I do this the record is committed. I'd like to take advantage of the layout feature where it prompts to save the record or makes you click a button to commit the record. If I go to the other layout I have to save the record before I return. I do…

Hi, I have the following problem. I have created two tables, one is "clients", one is "projects" - fairly simple. now, I have had the projects table before and now created "clients" after. I have linked the two through "client Id' and if I create a "project ID" field in clients, it shows one of the old project ID numbers. Now I created a portal to show all the projects that one client has. this portal, however only shows projects/ project ID's that are created after setting up the portal and not the ones that have been created a long time ago... a projects ID field however shows these older ID numbers. this makes me think that I have set up the right relationship but…

Hi, I'm Jorge from Argentina, and I have a little question. I have a portal, and when I write 2 or more lines into the same row, it hides all the lines but the first one... Is there any way to avoid hidding? I mean, like Microsoft Office Word's tables, in which as you write, the row's height increase? Here I attach 2 pics to clarify my problem. Thanks a lot. You're amazing. B)

Help, I have to retrofit an old application that has an invoice layout. In it, I have the master information, that I can load into variables no problem. But when I go to the portal, and try and set the variable data, it keeps using the first records data, even though I use a "select" option with the "Go to Portal Row [select; No dialog; $CurrentPortalRowNum + 1]. $CurrentPortalRowNum is set at the beginning of the loop. I know I'm on the correct portal row because in the debugger, the select highlights it properly. Further, using the data viewer, the $CurrentPortalRowNum is incrementing as required. I use the Go to Portal with a calculated number because the "…

Hello, is there a script out there that would delete more than one portal row at a time? i.e. if someone checks the box "delete" for a particular row(s) it would delete all of those portal rows at once, instead of it having being done one at a time as it is now.

This would solve a problem I'm having with a layout the customer wants to see. I have a "ticket" layout which shows a number of child records (pages) for each ticket record. There are about 3 portals with exactly the same table occurrence relationship each on a different tab of a tab object. My customers use fmp 8 so no object naming. I am trying to find a more effective way to have portals show the correct page without the risk of one showing page 3 whilst the other is still showing page 1. I have scriped nav buttons which essentially go to a field on each tab and then move to the portal row number which works, but looks "clunky" especially on slower computers. …

Hi, I want to have a screen where a user sees two lists of clients, one list is called "include" and the other "exclude". Each client record has a field called include, which is set to 1 or 0. The parent record contains a two global number fields, equalling 1 and 0. These drive the portal relationship. (I know you can do with just one global field and have equal or not equal... but I did it this way for clarity). Clicking a button on either portal switches the value of the include field. I want to have the record jump from one portal to the other as soon as the button is clicked. Currently I can't do this without manually clicking on the background of the paren…

I have 3 fields that contain Name, phone, fax; each field has 6 iterations. Field 1 is a drop down list to allow selection of name. I am trying to get fields 2 & 3 to follow the drop down list for the correct phone and fax no to the invoice. I have just about tried everything to get it to work. Any ideas? TIA

Is it the way in fp9 to create every second row in portal to be in different color using conditional formating? Don�t like to use Alternate background fill because portal is filtered and have different number of rows from record to record. Thanks Zagino

I am building a restaurant's reservation system as a VTC 'term project' for our family restaurant. I published 2 posts on this topic in 'relationships' and I will add this one in 'portals' and one in 'layouts'. Basically, I used John Mark Osborne's Calendar tutorial in order to build our 'DAYS' table. Then I created a 'TABLES' table (of the restaurant), a CLIENTS table and a RESERVATIONS table. I was able to create a quick reservation 'list' layout on a daily basis, and also add a calculation field to JMO's monthly calendar portals to show the total reservs count for any given day. Where I fail, is when I try to create a daily 'floor plan', where I would see the…

I've got a contacts table and a viewer table. How can I display 2 different records from the contacts table onto the viewer. ie one address for billing and another address for shipping? I've searched and apparently nesting portals won't work. Aside from having exact duplicate contacts tables or copying the field info back and forth what are my options? Thanks.

I'm a newbie trying to duplicate a MS Access database. I have a Company layout with the usual fields and at the bottom a row of four tabs (Contact History, Contact Names, Ticklers, Quotes) related to the current Company. I have two portals on the Quotes tab, Quote Header and Quote Detail. One Header field relates to a Company field (both company name) and the Header field Number relates to the Detail field Number. Problem is that all the Detail records for the Company show up in the Detail portal. I want to show only Detail records for the current/active Header record. I don't know how to make that happen -- any help would be greatly appreciated. Loren

I am trying to write a script whereby clicking on a portal row displays selects the correct portal row and displays only the for the corresponding record in another layout. Have to admit I'm beaten on this one at the moment. I've been thinking on these lines: Copy [select; Related.Table::Field( Get ( PortalRowNumber ))] Go to Layout Enter Find Mode Corresponding Field in related table The Get(PortalRowNumber) displays a dialog which shows the correct portal row is selected, but nothing seems to be copied or pasted. Any ideas please? FMP9 on MacOS X 10.5

Hello I know nested portals don't work, but 'nested portal' best describes what I want to do. (please move this post somewhere more appropriate if necessary) I've got database which tracks Primary Materials [color:yellow](table 1), Composite Groups made of Primary Materials [color:orange](table 2), and the finished product made up from Composite Groups [color:green](table 3). I'd like to see on one page exactly what a finished product is made up from. Hierarchically like this: [color:green]Product [color:orange]-Group1 [color:yellow]--Material1 --Material2 --Material5 [color:orange]-Group2 [color:yellow]--Material3 --Material5 Some Prim…

I have a client tracking database in filemaker that keeps track of my clients. I have a tab that has a portal that keeps track of their criminal charges. Each row has case number and description. I would like to use filemaker to print my file labels for my client. The label will show what charges the client has. Is there a way to use the data stored in the portal to create a summary field that can be used on the label? For example: Client: John Smith Case Number and Description fields in portal: 07-M-123 DUI 07-M-124 No Insurance 07-M-125 Obstructing an Officer Based on the above portal, I would like my file label to show: DUI, No…

Previously I have set up portals, about 8 rows each with scrolling, and they had grids. I forgot how to create a portal with those grids, and the help file doesn't yield much help. I know it's easy, but I plumb forgot.

I have an events database that is the end users use to track invitees, rsvps and run reports. This is set-up to be a temporary holding tank for current events and then all the information is to be transferred to our legacy system. I have a table for all the invitees, a table for all the RSVPs and a table for all the events. I use a portal to show all the "active" events a person is currently invited to. As part of the regular clean-up of removing events from this file I need to be able to find the people in my invitee file who do not have any current rsvps. What I need is to be able to find the people who are in the invitee table who no longer have a related rs…

Three tables: PERSON - one individual LETTER - one letter SENTLETTER - one letter sent to one individual If I am looking at a PERSON record, and I have a portal of all of the letters that should be sent to that person, can I have in that same portal the related "Date Sent" field from SENTLETTER so that it only comes up on those letters that have a related SENTLETTER record for that one PERSON record? I can't seem to make this relationship without making a global in LETTER and populating it through a script with the current PERSON Unique Serial. This should be able to be done, but I'm not sure how. Any help on this would be greatly appreciated. …

Vendor~LocationFiltered|VendorID| is my selection portal. The user selects one of the listed related locations which sets the global z_gSelectedRowID to the locations ID. Which in turn, displays that location within the LocationSelected portal on the same layout. Vendor~Location|VendorID| is the base table relationship. My question is this, I want to display the first Location record of the Vendor to Location relationship within the LocationSelected portal when the user navigates between records. This would correctly lists the first location for the vendor, but also allows the user to select another location with the selction portal with it's respective relat…

Hi all My problem is getting the correct description field populated for a record once a another record is created in the portal. I have a portal that creates records in another DB. The description can be rather lenghty at time so the description for the parts are stored in a separated DB and retrieve through second portal using a script. The problem arises when the user start to enter data in the second record, this creates another record in the portal so when the users retrives the description from the second portal, the information in the first description field in the first record is over written or the description is placed in the last record leaving the second rec…

Hello, I have a join portal where the majority of the fields are not in the table that the portal is searching from. That is the portal is connected to table join, and there is a field from the join table for company id; however, every other field in the portal is from the company portal. I would like the portal to sort by a field in the company table. How can I do this? When I choose the sort option, the only choices I have are from the join table. Thanks a lot for the help.

I have two FM9 DB's that are using FM9's server. DB "A" is used to store account information and has a portal which pulls data from DB "B". "B" has 110,000 records. "A" shows data in the portal for only 500 to 2500 related records from "B". I would like to add 26 small buttons in "A" so that the user can go directly to the portal data that starts with the selected letter. This saves a lot of time as opposed to scrolling. I would like all the related records to show in the portal and then they could click on the "M" key and go directly to the row in which the "NAME" field begins with the first letter "M". Any help would be appreciated. Thanks.

I am a VB.net developer against Access and SQL Server. I am using FM 9.0 Advanced (30 day trial). One of my friend asked me to design a small system that needs to work on both MAC and PC. To start with Customer/Contact side, i have designed the tables and added the relations between Customer to Contact as 1 to many. I have managed to create a layout to customer and contact on its own. Now i need that same functionality on one screen? How do i go about adding a new customer and adding many contacts to that customer? Any help would be highly appreciated for a newbie for FM. Mitesh

What is a SIMPLE way to get a found count of records in a portal? Thanks for your help!

I have two tables: (Insured, Policy) I have a portal on the Insured Table that Holds info for the whole record. The relationship between Insured Table and the Policy Table is one to Many. On each policy page I have a small recap portal of the one on the insured page (Basically all this is portal (same used on the insured table but with the field entry turn off) . This all works great. What I need is a way to make the recap portal on the policy page be able to be sorted differently on each policy page. Is this possible? Thank you, Joseph

Hi - hoping someone can help here. I've created a number of Access Databases in the past, and now I'm trying to move off Windows onto Mac OS - so I'm trying to recreate my Access databases in Filemaker Pro 9. So I'm starting with a simple relational database along the lines of Author --> Book. I've set up the tables and relationships, and I want a Data Entry / Display form. I've created a form Layout based on the Author Table, with a Portal to show related records fomr the Book Table. But the Portal will not populate with records. If I enter a new record in the portal it creates the correct new record in the table with the correct index keys, but will not…

I have a script to add court charges to a portal, but I must first click into a field in the new portal record, then the script adds the info. It works great but how can I get the script to select the portal by itself? There are a total of three portals on the page. Thanks.

i have 2 tables: eps and price. they are related together by date field. how can i have a portal in eps form that has 15 most recent related record from price table in itself? i do it by deactivating "vertical scrollbar" but when exporting to excel it export all related records.

I have a portal with such fields as PartNbr, Quantity, etc… What script would take me to the row that contains a specific PartNbr. For expl when I enter FV362 in a custom dialog box I want FM to go to the row that contains FV362 in PartNbr field. The Go To Portal Row script takes me to a row number. The Go To Field takes me to the right field in the portal but it sits in the 1st row.

How do I set up a portal to print multiple-page invoices if the line items exceed the 1-page length? In the case of 1 line item, we would only want a 1-page invoice; in the case of multiple line items that require more than one page, we would need a 2, 3, 4, or 5-page invoice.

Hi, FMP fans! How do I enable a portal so that I can create new records from that portal? I've done this on a db I created about a year ago, and now I can't figure out how to do it a 2nd time. The worst! -Conner Fenton is my hero

This is my scenario: please, please help! i have database with two tables looking something like this. table 1 record - field1 - field 2 1 - 22 - 5,600 2 - 30 - 7,600 3 = 56 - 3,200 4 = 60 - 1,800 5 = 90 - 10,000 6 = 100 - 35,000 table 2 field = value f1 = some text f2 = 54 f3 = you noticed that f3 in table 2 is blank. what i want is to fill this field via calculation doing this: first sort table 2 (ascending value of fiels1) then; look for the record in table 1 which is equal or the first greater than to f2 of table 2 (54). in the case above it is 56 (record 3, table 1) and put the value of field 2 of that specific re…

Anyone notice that potals size differently in 9 than 8.5? In 8.5, a portal in layout mode can only be vertically resized by an increment equal to the number of portal rows (like repeating fields). In 9, you can resize a portal by a single pixel. Perhaps as a result of the Auto-Resize feature?

I have a solution that has portals that work fine on the solution I built on my desktop. But when I put it on the server (All 9 Advanced) the portals do not populate. This is a Sepiration Model solution if that makes any difference. Is there something you need to do with portals unique to the server? Milo

I am setting up a new database for tracking lecture evaluations. Each month, 5 lectures are scored on each evaluation form that is turned in by that month's group of students. (The eval form lists the 5 lectures and there's a score assigned for each one.) I created a table for evals and a table for lectures. They are related by month. Evals has a fields LECTURE1, LECTURE2, etc. Lectures has the month, speaker and topic. I need to display each speaker's scores for their particular topic. I created a Calc field in Lectures called SCORE that uses Case function to display the score from the corresponding lecture. I then created a portal in Lectures to display t…

Hello all, I’m trying to relate two database tables, “Movies” and “Movie Clips.” I’ve created a portal in “Movies” that lets me look at “Movie Clips” that are related to that movie. It works great. But I’ve also created a portal in “Movie Clips” that’s supposed to let me look at “Movies” – so that I can note if a clip is drawing on footage from two different movies. Ideally, I’d be able to say that a clip is spliced footage from Movie A, Movie B, and Movie C. But, I’m having problems. I’ve got the portal set up so that it lists the Movie ID # and Movie Title in the portal in the Movie Clips table. I can log one movie into the portal, say, Movie A (Movie ID…

I'm working on a database that I already have setup using a filtered portal. I think viewing the data would be better if I could filter again. Basically I'm trying to filter down the number of tracks in a portal first by having the user select a year, and then a group. I have the year part figured out but it gets a little complicated for me to understand the logic in how to filter again. First off is it possible? If not, then I'm just hitting the wind. Secondly, would I use some sort of the same logic as I did for filtering years? I've attached a picture of the portion of the database that I'm talking about. jon

Hello, I have a database that handles a slew of "running totals" (for argument's sake, call it 'calories consumed'). Let's assume, in this database I have 8 people listed, and I have all their calories for each meal during a week (21 in total). If I want to have a portal that shows each of the 8 people, with the total calories consumed (i.e., the total from the most recent record), *sorted* in descending order of total calories - how would I be able to do that? When I set up a typical portal, it seems to pull the data from the first record in the database; not the most recent (which contains the information I need). I'm using FM 5.5 -- it seems like th…

I am familiar with the the old FM5.0 trick (FMKnowledgeBase # 2971) to show summarized data as a single row in a portal by identifying the first record of a summarized group in a relationship. The problem is that it requires a script to set a field that identifies the first record of each group. Does anyone know of a more "elegant" way of doing this-one that does not rely on a script? TIA

I have been working on this for a while. Is there a way to populate portals in the way that Auto Complete (type as you go works) in a field. There is field on main layout that user types in text, and as user types portal will populate. ie: in a contact db: user types Mic and Portal would populate... Microcast Microgen Micron Microsoft I am trying to get out of the find and the return....Thanks in Advance!

Hi, I'm trying to create a portal to display a list of jobs... I thought this would be easy since I've already created some more complicated portals in my solution. The layout I'm using is set to the Employees table. It has a few fields in it (Employee ID, Employee Name, etc.) I want the portal to display a list of all records from the Jobs table (Job ID, Job Name, Customer, etc.) This should be an easy one... how do I set this relationship up? Cheers!

I have a portal that can be filtered. Outside of this portal on the same layout I have three fields: Record Number, Found Set, and Total Records. So far I can calculate the last two numbers but can not work out how to calculate the first. Basically when a user clicks on a portal row I want the record number field to instantly display which record number in the found set is currently selected. I do not want to do this by attaching a script to the portal row because there are already other buttons in the portal row (namely GTRR) attached to certain icons. Does anyone know of a simple way to achieve this?

I'm stuck here... I have a portal of quotes and need to copy / paste the quote number into another table that holds the lines. I can get it (via script) to go to the quote number field, then go into quote lines table and create a new line and paste the quote number. That way they show up in the portal (linked via relationship). I've read in here that using the clipboard isn't a good practice so I've been trying to change my ways and implement the variables... How do I paste a variable into a new record? Easy question right? TIA! G$

Hi folks, Hope you might be able to help out. I'm setting up a large database, for which one of my goals is to automate the process of producing a quote for customers. I have 3 tables - one for customers, one for appliances (that we sell), and one for quotes. As I'm still testing this out, I have created 3 customer records (John, James, Peter) and 3 appliance records (Oven, Washing Machine, Tumble Dryer). I want to create one record for each quote I produce. The customer name will be at the top, and underneath will be a list of appliances that he/she has ordered. The customer part is fine - the relationships automatically fill in their contact d…

This has got to be easy. I want to display the content of a field from the first SORTED portal row in the parent file. I have created a calculation field (in parent file) to display the field but the calculation ignores the sort and displays the first portal row entered. How can I get the calculation to look at the first portal row according to the sort? Thanks!

I bought John Mark Osborne's training videos and am now going through the "Expert" CD. I just saw him do something that I'm sure he thought no one would take notice of but here it is. He created a portal (no big deal) but when he went into browse mode and selected the portal it turned GRAY! Mine Turn BLACK! I've searced high and low for a setting to change this but can't. Any Help? Thanks, Mel

I need to display a related feild in a layout with a more specific query than just math feilds. Here's the scoop: It's a database of patients and professionals. Each patient has a relationship with several professionals for consultation, but each patient also has a unique relationship with just one professional, their "attending physician". I can easily set up a portal for the related professionals, but I want to single out the attending physician and display it elsewhere on the layout, by itself. I believe I have set up the tables in the proper way to do this, I have a tabl for patients, and professionals, and also a patient/professional relationships table, w…

I created three tables. I put a popup value list related to the third table. Sometimes it works. Sometimes it doesn't. Sometimes it shows actual data. Sometimes it shows weird data. Sometimes at the end of the portal row, no new, blank row is added below. It is late and I am going bonkers over this!! (perhaps time for bed) What I want it to do is: #1)Display the Vendor Number and Name for the user to select from. #2) Put the vendor name in the field. Am I asking too much? As is, the popup doesn't work at all. Why? Beats me! It worked a few minutes ago; not elegantly but it did work. I checked to make sure the fields were not 'infringi…

I have a portal that has 2 text fields in it that can be rather large. One is comments and the other is reason…. I don’t want to make the portal gigantic, but when the user is in the portal is there a way to make that field zoom to show all its contents? I seem to recall a post about this a while ago, but have searched and searched to find nothing. Any assistance would be greatly appreciated.

To put it simply: There are 2 tables: #1 Payments Table Date Amount ... etc FK_VendorID #2 Vendor Table Name Street ... etc PK_VENDORID There is a portal based on Payments. One of the fields is FK_VendorID. In the portal it is a popup based on the Vendor ID & Vendor Name. Problem: When there are no vendors in the vendor table is the best way to direct a user to add a vendor something like "if RecordNumber(Vendors)=0 then customdialog "There are no vendors. Please add a new one" ; GOTO "VendorLayout"; Return to Portal layout. Or is there better logic I ca…

Can anyone explain this: I create a button; put text on it and place it on the top row of a portal. In layout mode it looks ok. In browse mode, the text disappears? huh?

I am rewriting this so that someone may understand what it is I am trying to do. I am a bowling tournament stats person. I have been asked to store tornaments for at least 150 bowlers. What I am trying to achieve is, when I create a new tournament, I would like all active bowlers only)to show up in the portal to speed up game entry. I would like thier first and last names, as well as the scratch, poa and games to show up in the portal. I think that would be faster that creating a new record in the results form, then selecting the bowler then entering the games. Does that make more sense. Mika Northern_Ontario_Master_Bowlers.zip

I have a layout with a portal of records. Some of the portals have multiple records. What I want to do is when a user clicks on a portal row go to another layout and display the image associated to the portal row that was clicked. I am not good a portals and relationships. I attached a file that I have created as a sample. I was only able to keep one image in there are the upload requirements are so small on this site. Any help would be appreciated. Garry LiquidWaste_HELP5.zip

How can I filter the record set in a portal? I am trying to list only those portal records that meet certain criteria. When I attempt to do a Find request in my script, ALL portal rows are returned.

I am having trouble figuring out how to allow a users to add a random number of pictures, audio, video, or misc files. I don’t know how many of these files there will be. Because of this I think that a solution on just putting a bunch of container fields does not work. For each set of media files there will be a text field. There will be a number of these media and text filed groups on each page. Ill give an example as to how it would look to clarify. (Audio file) (Picture) (Picture 2) (video file) Step 1. ……………………………………………………… (Picture 1) (Picture 2) (video file) Step 2. ……………………………………………………… (audio) (picture) Step 3. ……………………………………………………… …

Hi All, I would like to create a quoting system that is similar to the Quotewerks system available for PC which we currently use - www.quotewerks.com. I have created a database with two tables. One contains details about the customer etc, and the other contains the products related to that quote. They are linked via a QuoteID field. I have created a layout with a portal and all is great however I would like to be able to do the following in the portal: 1. Insert a new "row" in the middle of the existing portal list (like I would in a spreadsheet) 2. Copy and paste rows (copy a row, insert a blank row and then paste the copied row into it) 3. Be a…

I am having difficulty getting my pop-up menu data to display how I want in a portal. I have one table with tasks, and for each task I have a pop-up menu where I can select the department(s) responsible for the task completion. I have another related table for requirements. For each requirement, I am relating the tasks we perform to meet the requirement. I have a report layout of the requirements table that uses portals to also display the task data, so that for any requirement you can (theoretically) see all the departments that do work to support it. My issue is two part: 1. The portal only seems to display one of the selected departments in the pop-up men…

I have two db's that talk to each other. One of them stores all of the information about our mentors and the other stores all of information about our students. Each student is assigned a "cohort" year (the year they entered the program) and each student receives a specific mentor for the cohort year. In the student db a unique identifying ID for the mentor is entered to link the mentor and student. In the mentor db I've created a portal to list all of the students with that mentor's ID. Since mentors work more than one year (so more than one cohort) the mentor portal will pull up all years/cohorts that have the mentor's ID. I want to be able to limit th…

Hello, I'm having difficulty getting a pop-up menu to display how I want it to in a portal. I have one table with defined tasks and each task has a pop-up menu to select the responsible department(s) for the task [can be more than one]. In another, related table, I have requirements. I am relating the tasks to the requirements and have a portal to display the departments responsible. However, the portal is only showing the first selection in a pop-up menu with multiple selections. Also, when multiple tasks with the same responsible departments are related to the requirements table I get repeats in the portal (department 1 listed multiple times in the p…

I have created a portal displaying songs from a songlineitem table. How do I go about showing only the songs of a certain style and have the ability to also show all the songs via a conditional field. I've been able to do this with a repeating field, but I want to stay away from that because of the limits to report with a repeating field.

Hello! I am having a problem with filtering a portal. Here are my table relationships: case -- contact_linker -- contacts -- actual_contacts(client, attorney, witness, etc.) Those are my four tables in order... I have a portal on the "case" layout that looks into "contact_linker" and displays all the related contacts for that case... it works fine. But, I also have another portal on the "case" layout that looks into another T.O. of "contact_linker" in an attempt to show only 'opposing contacts'... The only difference in the relationships is an extra field called "Opposing_Counsel"... User's can click the checkbox for opposing counsel in the "contact_…

Help me please! I am desperate. My goal: I want a list of organisations and how they relate to each other (subsidiary/parent/customer/supplier etc) I have an Organisation Table, I have a link table to record who links to who and what type of link it is. My problem comes when I try and display this in a layout. I can easily show the links in a portal, but they are always from the point of view of the organisation I am editing. So links that come from another organisation show the wrong side of the link. e.g. my link table is setup as.. isrelatedto isrelatedfrom type so I setup a link from org a isrelatedto = org b isr…

Hello, I have a portal that currently shows all related records (as it should). Sometimes, however, I'd like it to only display certain records. Every record in my related file has a field called "active" - this displays whether the player is active or not (with a "Yes" or "No"). I would like to create a button that - when pressing it - will only display those players listed as "active" in the portal. I can then have another button that will reverse this (i.e., do the default - show all). What would be the easiest way for me to set up this "find?" -- I can then throw it in a script, for the button... I'm using FM 5.5. Thanks! Chris