Portals

I have a self-joined file with a portal on one of the layouts. I want to see only one record of the 'parent' with all related records in the portal. For example, if the the portal is for addresses in a particular state, I want only one screen for that state and all the matching records to be in the portal. At the moment, if I had say 100 records for a state, I have 100 records all with the same portal in them. Sorry if this question is a little dumb. FileMaker Version: 6 Platform: Windows XP

Hi - I am trying to keep a running total at the bottom of a record that contains portal data... I want to exclude any portal row that is not a valid job number. Every calculation I try seems to ignore this fact and gives me the total of every portal record, whether it's valid or not. :? Thanks.

Hi all Have a solution where i use the menu magic techinque to display and hide a menu. I added a delete record button to the portal and wrote attached a script to delete the record the user wants. The script works until you get to the delete record request. Nothing happen. I even attach the button to another script that call the delete record script. This works until it comes to the delete record request step and then nothing happens. There must be something i am missing because everything i tried works until the script comes to that step' I attached a simple abbreviated copy of the program Thanks Lionel weld.zip

I have a database with 3 text fields: area, goal, objective. Area is a value list, and there are about 10 choices. Goal is often repeated exactly on several records. Objective will be unique to each record. I'm trying to set up a way so that "area" is selected, the corresponding goals will show in a portal. I've got it working, but because a goal can be repeated several times with a different objective, I get duplicates showing in the portal. Is there a way so that only one instance of the goal is visible in the portal? I've tried creating value lists based on goal, but the list is really too long to scroll through.

I have a portal that I have made 5 rows. It finds the correct record but repeats it 2 more times on line 2 and 3. This one has got me. Ivan

Hello, I have a portal with data from another db. One of the fields is a text field that will have one of three text values (Completed, In Progress, or Pending). What calculation would allow me to determine if all the related fields in the portal contained the "Completed" entry? Sorry if this is such a simple question. I am a beginner though, so I need help with things like this.

I am going crazy. I'm sure that there are many posts relating to this subject but I cant find them. Someone please help me. I have two tables (FMP7) One is manufacturers and one is products. I want to choose the manufacturer and then only get the items related to that manufacturer when I am in a table I have named QUOTES. I have related the manufacturers and products table with a field called MANUFACTURERS_ID. I have defined a value list which should only relate the product to the manufacturers table and it only returns <no values defined> from the products drop down list (in the portal, in the quotes table) This is killing me. Please help. And put it in the easie…

As the image below shows I have two databases: classes and packages. A package contains all the classes in the portal list. I need to flatten the file for a website, so I need one field in the packages db (selected in the image) that lists all the classes that come from the portal. I'd like to do this with a calculation instead of script, but I've been stuck on this problem for several hours. Anyone have a suggestion?

I have a field defined as; Portal Row Number Calc Global, from Report_Categories, = Get(Portal Row Number). The field is displayed on the Report_Categories Layout along with a portal to a realted table. The value of Portal Row Number remains at zero when I click into any of the portal rows. I am totally at a loss as to why I can't see the portal row values. Thank you in advance for any help.

I have a FM7 database with 4 tables: AGENCIES, BRANDS, CAMPAIGNS and CODES. The relationships are the following: AGENCIES can have multiple BRANDS. BRANDS can have multiple CAMPAIGNS. CAMPAIGNS can have multiple CODES. I have a single layout named Agency and it has 3 portals: Brands, Campaigns and Codes laid out vertically. How can I synchronize/filter these three portals based on the portal and portal row I click on? For example if I click on row 2 of Brands I only want to see only the Campaigns related to that particular brand in the campaign portal. Then when I click on a Campaign portal row I only want to see the codes associated with that campaign in the Cod…

I have a db of sites and the detail layout has 4 portals on it. They show the right information and the relationships are correct as far as i can tell. However, I have enabled the vertical scroll bar in all of the portals, but when I scroll it doesn portalscrollproblem.zip

Hello everybody, I have a problem. I can't add something in the portal(i have a many to many relationship). If i try to do so i get an error which says This field can't be changed!!! Anybody a suggestion to help me? Thankx, Sima

Absolute beginner with FM7 for 2 days now. I have a portal created and displaying records that contain addresses. Outside the portal I can use sliding text to close up the empty lines in the address fields. How do I do this when the fields are inside the portal? Jim Version: v7.x Platform: Windows XP

I have a situation where I need to print a lunch menu. Each item has a description of varying length, so I need to 'slide' additional descriptions up so there's not big gaps in the list. Sliding doesn't seem to work with portal contents. If I make the text box (and first row of the portal) large, the size doesn't decrease for shorter descriptions. I thought maybe I could use "<<fieldname>>" on the page and slide them which does work, but I don't know how to set this to show fields from multiple records... e.g. <<fieldname_record1>>, <<fieldname_record2>>.... I'm not sure if there's such a thing or someone knows how to slide the con…

Hello again, I wonder if it is possible to have something like recursive portals in FMP 7. I will try to explain what I have in mind. Going back to my patients/episodes of care/visits model for a medical practice. Lets say we have a table called patients with all the patients details. Each patient can have several different episodes of care ("episodes" table) and for each episode of care each patient could be seen one or more times ("visits" table"). Each patient has a unique pt_id via which episodes are related to the main table. Each episode has its own uniqe ep_id and each visit is related to the episodes using that (of course, in turn, each visit has it…

Hello all ! I have problem with converted files from v. 6 to v. 7. It seems to me that Get ((portalRowNumber) function is not working properly. It always get me "0". Anyone can confirm that this is a bug ??

Hello, I have 2 different databases. One that I use for official orders and the other for quotations. I was able to create a script to import the content of a quote to an actual order using serial numbers but when it comes to portal informations, I only get the first line of the quote portal into my order. How do I get my order to import the info of the portals other lines? Help would be greatly appreciated. Thanks FileMaker Version: 6 Platform: Windows XP

2 files Contacts and Companies in the company file I have a portal showing the contacts within companies and I have a field which is an unstored calculation of: contacts::CONTACTID & "

Is there a way to skip rows in a portal? I want to use a portal with 25 rows to show appointments for a particular day, but want appointments to show up appropriately spaced throughout the day rather than simply in consecutive rows. Can this be done? Any help would be much appreciated.

Hi guys I need your expert advice again... I am trying to build a patient database for my practice. The database consists of a main patients' table with the basic data a related episodes table with all the episodes of care for each patient (consultations, operations and followups) and 4 studies tables for blood tests, imaging studies etc Is it possible, if there are more than one portals on a layout, to select a specific portal and go to a specific row using a calculation or a script? I have 5 portals on a layout, all of which are displaying tha various srudies for the specific patient. Each portal is taking its data from a different table, all of…

Hi everybody, I have made a portal..but i have problem working with it. if i include a field in the first row it wouldn't be apear in the browse mode! I want to do the following: I want to make a portal and put a field on it with the name of journalist in the paper file. Beside it i want to have a button(thus in the same row)which goes to the related record in journalist file. I have problem using portals..also visibility problem..because if a put the same field on the second row then i'm able to browse it!!! How should i define the relations properly? Can you help me please? Thankx, Sima

Whilst it is true that the objects that are contained within a portal are not there on the layout until the data in the join fields match, but - and this is my problem - the user can still click into the portal itself even when it is "invisible". Is there any way of preventing the user from inadvertantly clicking in the area of the screen where the portal will appear (when the join fields match)?

Is there a way to create a new related record in a portal which will only show that new record. My problem is that there are hundreds of related records and over the web it takes ages to show up within the portal and then even longer to edit. My solution is therefore to display the single related record in the portal but I need to create a new one each time. Any suggestions??? PLEASE - I AM IN URGENT NEED!!!

Hey guys, I'd like to do 2 things that can be accomplished with the same function, I'd first like to put a field on a layout that shows the total number of portal records, also I'd like to prevent a record in one table from being deleted if it has related records in another. Is there a function that will return the number of portal rows or the number of related records?

I am trying to display records from a portal where I only have limited vertical space (ie. not much height but plenty of width). I thought I could create 3 identical portals and place them side by side so they would look like columns. In the Portal Setup window I select the initial row of the 2nd and 3rd portal to 9 and 17 respectively as I am displaying 8 rows in each portal. This works fine to display records and I can easily add new related records using a script/button but I am trying to navigate using 'previous' and 'next' buttons and cannot get from one portal to another this way. I have tried Go To Portal Row (next/previous) but this didn't work. I…

Hi guys, I've just imported some 2000 records and I could bake a cake let alone get a coffee in the time it takes to sort the records in the portal. Seriously, it takes a full 5 minutes to sort. In fact I just changed one field so it's automatically re-sorted and in the time I've written this and gone to the loo (tmi i know) it still hasn't finished the sort. Indexing is turned on. I imported 230 records before and had the exact same problem with length of time to sort. Any ideas? Edited to add: If i perform a normal sort it works fine. But as soon as I go to the next record it triggers an automatic sort and takes a long time. (I don't have any sc…

Hi, all - I'm brand new to FileMaker (I'm a MS Access user on Windows) . I have two tables in a contact management database, one containing people, one containing contact actions. They are joined by a third table that allows me to link more than one person with more than one action and vice versa. My people table has a layout with a portal that allows me to see which actions have been taken for each person. Is there any way to be able to add actions directly into that portal? I don't see how to make it happen. Thanks!

I have a portal with 5 combinations. I would like to extract the fifth to a field. Also, I would like the field to automatically perfom this script. Not having much luck with script "go to portal" select fifth row then copy and paste. It is picking up all the rows. Any help would be helpful. Thanks in Advance. norm

This may sound really dumb, but I can't get Filemaker Pro to make a portal. In layout view, I click on the portal box, draw it, and the portal setup box comes up. Everything in the "Show related records from:" box is shaded out except "Define Database" and everything else in the portal setup box is greyed out too. I'd like to use "Current table," but it's greyed out. If I try to define a database, every box in the portals setup box is still greyed out. Does anyone have an suggestions? I know this is something dumb... but I would really appreciate any help.

Greetings to all, This is my first post to this board. I am having troubles with some simple calculations in a portal field. In my portal I have 4 dynamic value lists that work in a hierarchy. Once the first is selected the next drop down populates, and so on. Once a certain set of criteria is set then a "Fee" field is to be caluclated. The problem is that the "Fee" field is showing up with the correct calculation in the portal but not in the respective table until I "click" in that field. And, another "Sub-Total" field which gets the sum of all of the "Fee" fields doesn't update until I change to "Layout" mode and back again. I've tried the "commit rec…

Sorry if this has been addressed before, I couldn't find it in any previous posts. I am using the Portal Visibility Trick and I am stuck on a problem: The portal is set to become visible when a certain value is selected from a field's menu. However when that value is selected, the portal does not appear. But if I click on the background of the layout, then it does appear. If I go to fill in another field on the layout however it does not make it appear. Only clicking on the background makes it come up. Or if I change modes or layouts and come back, that will also make it appear. I can't figure it out! Other than this, it seems to be working right--i…

I have 3 db's. The first has a 'Priority' field where numbers 1 to 10 can be inserted. The second db has a calculated result which is just the value of the first db's priority field. The third db has a portal with a relationship with the second db with a sort by 'Priority' so it will list jobs with Priority 1 at the top of the portal, then 2, then 3 etc. The problem is when I alter the priority in the first db although it is changing the priority number in the portal it is not refreshing the list in order of 1,2,3 etc. unless I close the db or go to a different layout and go back again. Thanks

I have always used the following technique to jump to the related file from a portal record. In the Portal is a hidden field that is the serial number of the portal record. Serial Numbers are automatically assigned. There is a button in each portal line so that it selects the portal row and does the following Script: Enter Browse Mode Copy Serial Number Perform External Script in the Related File The script in the Related file is as follows Go To Layout that has the serial number in the layout Enter Find Mode(No Options Checked) Paste Serial Number Perform Find(No Options Checked) In all of my development I have used this technique in a…

I currently have a portal that is sorted by last modified/creation date/time which is fine for most cases as the most accessed files get high ranking etc. But I want to set it up so that the order stays the same unless the user specifics one to go to top? What is the simplest way to sort a portal Thanks

I have a portal which reveals only 20 of 100's of records. When I move from this layout to another AND back, the portal always starts with the first sorted match. I would like to scroll through the portal, select a record, say #500, go to another layout and then upon return have those 20 records still be in view. Good Day, All

In the invoicing system I'm working on I'd like to have a portal on a customer record that shows what products they buy. There should be one line for every product code they've purchased, and a sum of the number of units bought, and total cost. Is this even possible in a portal? The only way I know how to do it now is with Summary fields in preview mode?

Hi guys, I have a portal that is supposed to display surveys that a Contact (individual) has taken. I dont track individual surveys the users have taken instead I track the answers for the questions on the surveys. The User Answers table has a questionId, an answerId, a surveyId, a contactId, and a date taken field. Now what i want to display in the portal are records with distinct surveyId and date taken pairs. In SQL this is easily accomplished, but I am having trouble getting it done in FileMaker. Thanks in advance for the help.

In a calculation field that simply concatenates text from several fields is it possible to maintain the text format from each of the fields. That is, some fields have some italicised and some bold text in them but the calculation field only returns plain text. I can not get this to work in a single file but the follow up question is whether the solution will work when the calculation field is in a portal to another file. Regards, Ian

I've thrown this out there before but got WAY sidetracked with a million other projects. Now I'm ready to revisit it and I'm not that much smarter this go around! Currently we use Excel spreadsheets - one file for each of the 10 employees. These spreadsheets have one line for each 30-minute increment - Sunday to Saturday. Each week a new spreadsheet is created via a Macro for the following week for each employee. As a temporary solution, I have a "holding" database that imports these spreadsheets each week, cleans up blank records, validates job numbers and spits out all sorts of reports. Then all records get dumped into a "history" db and that's that. …

Anyone know if it is possible to make a portal appear and disappear based on a relationship? What I would like to do is have 2 portals one on top of the other, but only one active and visible at a time, based on a global field that has the 2 related choices. I know one workaround would be to have virtually identical layouts, one with each portal, and when the user toggles, they don't even know they have changed layouts, but I would rather not do that. Any thoughts / ideas are greatly appreciated...

See attached I want to be able to highlight specific people in specific companies. The problem is if a person belongs to more than 1 company it falls to bits. Anyone got any ideas on how I can make this work? Basically if the number in gSortFirst is the number of the contact for the specific company which should be at the top (sorted) and highlighted? Thanks highl.zip

Hello, I'm making a database using portals. My Problem is 'I can't see anything in a portal' sometimes! But, this is not a problem of connecting or finding DB data. When I create a constant letter field (which you can make by clicking the button which face has 'A') and move into the area of portal(the portal container) Then , I can't see this 'Constant field' in the Browse mode Of course when I move the 'constant field' out of the portal container I can see it clearly. But when I try to put this field into another portal in the same layout , I can see it in Browse mode. I tried rearranging many times by moving back and forth, but obviously this i…

I have a portal with 5 entry, for example, how can I get all the ID's for all 5 entries in to one field. Can anyone help? Thanks

Hi ! I am a newbie about filemaker,. I have 1 database (drawings.fp5) with drawingnr 100-110. And i have 1 database (Releases.fp5) related with drawingnr. This database contain multiple 100, 101, ... drawings. In drawings.fp5 i have a portal showing releases 01,02, and so on. When user press new release in drawing.fp5 i want filemaker to autoenter release 03 in portal. I can

Hi all, Hope you can help me out on this one. I have a portal set up based on 2 databases: Parts Replaced New Jobs This is setup for PC repairs. As a part inside a PC is replaced, a new record is added to the parts replaced database - Serial number of PC, Part replaced, Date replaced - this works out the new warranty on that part (Part replaced + 12 months) Now, when a new job is added onto the New Jobs database, the serial number of the PC is entered into the DB. The portal is designed to show all parts that have been replaced that are still in warranty, obviouslt getting this information from the parts replaced DB. I setup a field in Parts …

Aaahhh! I've just spend days creating this relational database that has an portal on an "invoice" table showing what employees (and their hours and rates), as pulled from a timesheet table, comprise this invoice. What I need to do now is print invoices that show this employee/hours/rate/subtotal portal. It works fine unless I have more employees on a job than will display on one page. In that case, only the records that fit in the portal display. I found a tech note on filemakers site (104457) that talks about multiple page portal printing, but it's really really cumbersome, scary, and old (six years old). I've also read something about printing from portals i…

I just got Filemaker and this is the first time I'm trying the portal capability. I have a table Dogs, with one entry for each dog. I have one table for Vet Visits and one table for Shot Records. The linkage between these tables is Dog Name. On the Dogs layout, I created a portal to Vet Visits to show date of visit and reason of visit. I created another portal on the Dogs layout to Shot records to show shot and next due date (calculated in the Shot record). On the Dogs layout, no data is displayed from either of those 2 tables. Seemed pretty simple to setup, but there must be something simple I am missing. I'm stumped. If someone wants I can send …

Okay what I basically want to do is be able to assign 1 row in a portal a different colour and make it stay at the top of all the other portal entries? Does anyone know how this is possible? Thanks

Ok this is my problem I have a database with a portal for topics in which a actual schools class will cover. So lets say the main database is "descriptionOfClass" and the database in which the portal comes from is "topics" (there are only 8 at most topics in this portal) I want the person to be able to create a new class which means they will have to add topics to the "topics" database(the portal) as well as add the information to the "descriptionOfClass" database hopefully on the same page and form. Also when they go to edit this information i want the topics to indiviually or in one box be able to be outputed in a text box, many text boxes, or whatever it will be abl…

I want to go to the last row in a portal and copy a field to the layout where the portal resides. I have a quote file that stores quotes by date. I want to display the latest quote on the master inventory layout where the quote portal resides. This will give at a glance the latest quoted price for this part no., even thou it is in the portal. The portal is sorted by date, therefore the latest quote will always be in the last row of the portal.

Hello to all portal masters! I have a portal in FILE-A that displays the related records from FILE-B. The portal shows the field "Tenant_Name". I also have a "Receipt_Num" field in FILE-A. "What I can't figure out is how to make a script that auto-creates New Records in FILE-C depending on the number of Customer Names shown in the portal, and with the same "Receipt_Num". For example, The current value of "Receipt_Num" is 0808 and the portal shows the following names: Mark Jackson Joe Smith Henry Thomas The script should make 3 new records in FILE C, one for Mark Jackson, one for Joe Smith and one for Henry Thomas with all having the same Receipt Num 0808.…

ok, so here I go: 1. Is it possible to have a portal with several rows display its information on different reports... I will give you an example. Say I have a portal with 3 rows of information 3 different people. I would like to be able to insert each row of information on a diferent page. Sort of like a mail merge in word... I have a letter and I would like to insert row 1 of my portal in this letter...and then do it with row 2 and 3... All seperate sheets. Is this possible? Brahim

I have a portal which display contacts within companies. Ideally what I want is to lock the portal so that the current related contact records are editable but new rows are not able to be added with out click a script. Is there to do this? If not and I have to lock the entire portal in which I assume I would need to duplicate the layout and have one with a portal with fields that allow entry and one that doesn't? Any help would be great thanks

Has anyone else run across this oddness? If so, do you know what's actually happening? The case: I have a master table and a slave table, with a defining relationship of Master:Field1 <--> Slave:constant (where constant = 1). This is set to allow creation of related records in slave, so if field1 is 1, all records in slave are related to the master record. Each table also has a key, set to auto-enter serial, but this doesn't play into the relationship. Now the odd bit: If the relationship is currently valid (i.e., master:field1 = 1), I get an error when I try to create a related record via the portal by filling in a slave:text field in the portal.…

Hi all: I had thought this would be very simple, but once I realized I'd never done it before, I just ran into a mental wall. Instead of beating my head against that wall, I've moved on to the next problem and am posting the question here: I just want each row in a portal to show an item number, starting from 1 and going to how ever many rows are currently being shown in the portal. This is a formatting issue requested by the client, like this: 1. (Item description, Item price) 2. (Item description, Item price) 3. (Item description, Item price) etc., but if there's only 3 items showing in a six-row portal, I want the numbers to stop at 3. It's…

Hello~ I am the newbie of newbies. I am making a database with three tables(which is in two files) I am making kind of photo album. Tables: Data contains data of images Data-Image :a table contains relationship between data and image Image : contains images Relationship between three tables are Data Id <-> Data-Image_D (one : many) Image Id <-> Data-Image_I (one : many) Data and Data-Image is in the same file and Image is in another file table <Data> and <Image> has own serial numbers(which is IDs) and <Data-Image> table has connecting data between <Data> and <Image> i…

I have a fairly simple portal that displays the title date and time of a related record, I simply want the user to be able to sort the records by either field dynamically. (I would rather avoid multiple layouts) Is there a way to accomplish this? Thanks! D

To accomplish this in FMP 6, I created a calculation in each database with the value 1. (User can't edit without much effort and all records match.) Table 1: global_join = 1 Table 2: global_join = 1 I then set up a relationship between the tables using the "global_join"s and used that relationship for the portal. In FMP 7 this relationship set up isn't working. In 7 I have an instance of "Customers" called Global Join connected to an instance of "Party" using the "global_join"s in each table. The part that is confusing me is the portal shows one record but that record isn't the first record like one would expect. It only shows the SECOND record. …

I thought FM7 said that when you browse through a portal and then click out that it wouldn't jump back up to the top, it was supposed to leave the portal where you scrolled it to. Am I doing something wrong here? The one's I've tried it on so far aren't sorted portals or sorted relationships... FileMaker Version: 7 Platform: Windows XP

I

How do you narrow a find within a portal? I've related a student table to a class table and the middle table is enrollment. So enrollment contains all the classes each student is taking. Very simple. So, I have a portal in the student table which views all their classes. But, when I try to find just some of those classes (just one quarter's classes), I still get them all. Any clues?

I have a layout that allows users to enter in reports - the layout is based on the table "report" and has a portal to the table "issues" which holds all the line items. So the user fills out the report header information once and then fills out all the line items in the portal. One of the fields for each line item is discipline (mechanical, electrical, etc.) and one issue can have multiple disciplines. I have it set up with two more tables. The first table, "discipline", just has the eight disciplines, an ID number and a graphic for each one. The other table, "discipline join," contains a foreign key for each issue (IssueID) and a foreign key for each discipline …

I guess my question is related to the precedent message, but here I go: Is it possible to make (via a calculation field) a list of related portal rows for a given record ? I tried : "First item : " & RelationName::Field.0 & "Second item : " & RelationName::Field.1, etc but it is not accepted by FMP 6...

I have a layout with a portal that displays 10 items. I want to add a field called rank with a number 1-10 and the portal will display 1-10. This is no problem to setup as you simply add it to the relation sort of the portal... The problem is if someone changes a new entry to "1" I would like the current 1 to become 2 and 2 to 3 etc...and like wise if number 10 is changed to 2 then 9 becomes 10 etc. Has anyone got any examples of something like this??? (The only thing I have seen which is similiar-ish (but not what I really want) is one which allows you to swap 2 portal rows). Thanks

A portal inside a portal. I tried this with no success. Does anyone know a workaround to achieve the same result? An example of what I might be trying to achieve could be; A compny record with a portal of staff members and then list of telephone numbers for each staff member.

Hello. I have a self join portal in a "staff" database that lists all records in the DB that I've created as a sort of constant "side bar" on my browse layouts. They're listed in what appears to be a random order, can I get these to show up in ABC order? Thanks!

Hi portal wizards, I have two databases connected to eachother: "related projects" and "all projects" with a relationship called "projectid", matching the field "projectid" from "related projects" with the field "projectid" from "all projects". In the database "related projects" I have created a portal that (in case of a match) displays the related records in the following related fields: code artist title BONJA-001 james bond the secret filemaker tricks BONJA-002 james bond the secret revealed I am searching for hours now for a way to copy all data (or per row) displayed in the portal into another field making it possible to do other things w…

I am making a database that budgets for a fiscal year. I open to a DEPARTMENT layout and I have set up to show only purchases in that department. I have additional field in the "purchases" table that indicates which fiscal year that purchase was made. (2004-05, 2005-06, etc) How can I tell FM7 to only show the CURRENT fiscal year in that portal. I know it can be done, there are too many cool little tools in here. If not current, can I have a spot to pick which fiscal year? I also have a table of all the companies we work with and it has the same set-up... view what was purchased in a given fiscal year. I am using these portals to calculate how much has…

I have two files people and contact. Both files are related. On people I have a contact portal with the fields id , name and number. The related fields on both files are ID. I have these 3 fields on the portal and on the field number I have a button that copies the ID that

when i set up a portal to multiple records, i tried to set the whole portal as a button that when you click on it will perform GoToPortalRow{Select; Next}. However, as soon as I save changes and go into Browse mode, when i click on it nothing happens. I tried changing the parameters to be GoToPortalRow{Next} and even GoToPortalRow{Select; Last} nothing ever changes...all it does is highlight the field. also, i have it mouse over to become a hand, so i'm sure i'm not just clicking on the field part and not the button

I have 2 files. File A and B. File A has a portal row with related fields in fields B. I'm trying to set it up so that I can go from a field in a record in file B and want to go to that portal row in file A. I use a script button in the portal row to get from file A to File B where something happens and i'm trying to get back to the same spot where I executed the script (same portal row). I'm able to get back to the correct record in file A but want to be dropped off in the portal row field that I clicked on to execute the original script. I have not been able to get the status(current portal row)to work. I was trying to use a field as pointer where the current row# woul…

This is for development in IWP. I have a report using a portal (because of the 5 record limit for list view) that needs to be printed out. However you are only able to print as much as the portal displays on screen. Is there a way to dynamically increase/decrease the portal rows so they match the number of records in the table? Thanks Emma

ok, this is my third forum, because this problem has been throwing me everywhere. I'm creating a computer inventory. The design specification is one rown, one computer. The person also wants to view all jobs done on the computer by the IT department. I set up a portal to show the related fields for jobs done, however there are two problems. 1) The portal forces me to list jobs in rows, rather than separate columns. Is there anyway to customize the portal to add new columns instead of rows? Or would it be more convenient to just create 4 or 5 portals and have whoever maintains the database add these on? Also, in table view, the portal only shows the first r…

How do I get the portal to stop repeating the contents of the first row (into the second row) without having the contents extend a bit outside of the row boundary?

Hi all: I'm working on a calendar layout which uses a separate portal for the day of the week. At the bottom is an area for details of the current item. I'm capturing the portal row of the selected item via a global, so that the item will remain highlighted via go to portal row. However, regardless of which portal the item is in (which portal was clicked in to trigger the script) the highlighting always occurs in the first portal. Is there any way to indicate which portal I am referring to when I call Go To Portal Row? thanks in advance -Stanley

So I'm coming back to FM after about a 10-year hiatus...so using portals is new for me and I'm still trying to get my brain around it. I am developing a CRM for my school, and I'm having difficulty in producing the report cards and transcripts the way I'd like. Here's the deal. I have a file that holds registration and grade information (Registration). It relates to other files that hold specifics (StudentInfo, Courses, Classes, Faculty, etc.). Course stores info about courses like the name, resources, credit offered, and credit domain (like Math or English). The Classes file stores info about which semester and class period a class is offered, and relates to th…

how can i have a many related portal (p3) in the portal (p2) that is the many related portal in the layout (t1).(how can i use a portal same as a layout, and define a portal in it) (p3)..n<->1..(p2)..n<->1..(t1) i want show 3 tables that each pair table was related compelete information in a layout. how can i do that? --

Hi, I'm was wondering if it was possible to make a specfic field in the portal row to display the entire contents of it when I click on it or select it. It will only display the contents partially due to the boundaries of the field itself. I can make the field display all if I allow the field to be edited in which I do not. Thanks for helping me find a solution. Yung Yung

I have 3 files setup: Courses, GLE, Components Courses fields: Course Title GLE fields: GLEName, GLEID, (pop-up menu - lists all courses) Components fields: CompName, CompID, (pop-up menu - lists all GLEs) Each Course has several GLEs, each GLE has several Components so each Component is linked to a GLE and each GLE is linked to a Course I need the following printout for each course: CourseName1 GLEName1 CompName1 CompName2 GLEName2 CompName1 CompName2 Course Name2 etc, etc How do I do this?:? BIG KUDOS whomever figures this out!! I need it by Friday if po…

I have a portal that is showing me the related records that I have requested from specific table/s. Each portal row shows me three things, a User_Name, Object_ID, and Object_Description. I need to be able to create a new record in a different table based on the Object_ID or the portal row that is selected. I've tried a few things with the Get(PortalRowNumber) function. Like using the row number to fill in the contents field that show the Object_ID of the row selected, but either i don't know how to get that to happen or it doesn't work. I am not sure if I'm even going down the right path with that Get function. Any help would be greatly appr…

Hi All, I hope someone is able to shed some light. I have two portals which show records from different files. The first portal shows items that have been quoted for an installation and the other shows 'over run' items which were neccessary in order to complete the job. I want to be able to collate these items from both portals and incorporate them into a new quote which will then be more accurate for future quotes for similar installations. I hope this is clear enough. TIA Paul

I have an unusual portal based on a constant relationship (a calc field containing a "one" across all records in both databases). I went this way because my related database has no record ID, and I always want all records to show in the portal. The portal is listing names given to custom lists generated from an inventory database. I would like to see the portal sort by these names. However, in relationship definition, I can't choose a sort field. I select, click "OK", and it doesn't "take." I presume this is due to the contstant relationship. A clumsy work-around I've thought of is to have a big text field in a one-record database (I am trying to be careful…

I have a solutions where I created a portal to show duplicate records, records that have the same name. We use this to determine different version of master recording. It allows us to see what is a duplicate vs. just another version. My problem is I have the portal sorting by song title and it constantly resorts. I have a button/script in the portal that takes you to the related record so you can see more of the data about that song. When you click on the button the portal resorts. Then you click on it again, it resorts then you can click on the button and it takes you to the related records...then it resorts again. This also happens when you try to scroll the p…

Here is the situation: 3 tables: "Main", "Policies" and "Welcome" Relationships: Main::MainID -> Policies::Rel_MainID Welcome::Policy_Status -> Policies::Policy_Status What I already have is on the "Welcome" Table I have a portal that is related to the policy_Status field...I mad a radio button for my choices...This portal brings up all names with the choice selected. This works great...I give credit to everybody who helped me... Now, I would like to make another portal on the same table ("Welcome") Now every time I do this what I need does not happen. I would like a portal that is not related to the first portal at all.. I would li…

I have a portal containing fields from self-join (for IWP purposes). To sort a portal am I right in thinking that you can only do this from the relationship builder - in which case you can only sort the portal by fields contained in that portal? Or is there some to other way i can sort it? thanks Emma

Does anyone have an example or quick explanation for the Initial row setting in FM7 portal setup. I can't think of a reason why you would want to permanently filter the initial rows of portal. I can see if you can set this variable on the fly via a design function it would be helpfull in some cases to reduce the portal size. Just curious Rod

Portal within a portal? I haven't been able to do this one yet. Am I beating my head against a wall trying to figure this one out?

I am at the end of my wits. I have three related tables in my main database. On three separate layouts are portals relating to one of these tables. Two of them work fine. The third one, which seems completely identical, does not show any of the fields in Browse mode. Even the button that links to the related record does not show up, although it is on top of the portal. I don't know how best to describe this. The fields are not locked. Either somehow the portal is locked or there is something wrong with the relationship, although I checked and checked, and everything seems identical to the other portals, When I use one of the existing working portals I see the button and…

Hello I need some help with a portal.. hopefully somebody will be able to help For simplicity, imagine I have 2 tables - customers and transactions. In the customer table for example, customer A has bought 6 products - 3 Apples, 2 Pears and 1 Banana. Obviously with a normal portal, it will simply all the products as separate line items in a portal in the customer screen. However, is it possible to have a summarised portal as well

I think it's only since the update 7.0v2 that I've found one of my portals to complain, when I go to a blank portal row and try to input data for a new related record: "This operation cannot be performed because one or more required related records are not avilable and cannot be created." Yet, on *every* occasion, a second try succeeds. So, my data entry in each portal row now involves the extra step of clearing this dialogue and re-entering the data for the initial field in the new row. To be fair, I should note that this relation perhaps "should not" work for creating new records. Yet it always did work, and even now it still does, after one complaint. (The p…

I've got two files, customer and accounts, with a relationship between CustID in each file. The portal in Customer shows all related accounts based on this relationship, and displays only the relevant accounts for that customer. I made a button for the account field to display that specific account for more detail, but regardless of which row in the portal I click, it shows the first record of all that customer's accounts. I want to go directly to the specific record in the portal row that I click. Can this be accomplished?

Hi I am having problems with a calculation field in a portal. All my calc is doing is getting a name from a related table, which relates to an ID number in the portal. When I update the ID number, the name does not change, however when I switch back and forth to a previous record and back it has updated it. Is there a way of updating calculations in portals?? I phoned UK tech support (some of whom are helpful sometimes) and they dont know what I'm talking about!! BTW this works fine when not in a portal. Thanks Adam.

Hi everyone, Sorry for posting another question so soon. I have a big solution that I have been working on for over a year, and am now (I think) tidying up the loose ends. My problem is: I have a portal in a (Standards) Master File showing data from a link file between the master File and a related file (Policies) which has "Standard Number" as its match field. I need to be able to allow the end user to change the Standard Number (the match field) in the master file without loosing the relationship to the various policies linked to that standard ... which, of course, disappear from the portal as soon as the Standard Number is changed in the Master file. …

Hello, Hopefully this is a simple question that many of you have already solved. THE SITUATION: I have a many-to-many relationship between my Companies file and a Cities file. I have it set up correctly (as far as I know) with a 3rd join table between the two (CitiesServed). THE PROBLEM: I want to be able to do a find for all the companies that serve in more than ONE specific city -- something like "find all companies that serve BOTH city1 AND city2". I've noticed when performing a find in my companies table I can only enter ONE city into my portal (to the CitiesServed table) and if I create a new find request and enter the second city it just finds al…

I had posted this problem before but I am still having problems. I have a set of products with associated options taken from a master list and put into a lookup table. I am trying to create a line item page where I select the product from a dropdown, and just those options associated with Product A come up in a portal. From there I want to be able to specify, for example, 4 of Option 1, 0 of Option 5, and 1 of option 12 for Product A. I was thinking that it would be done in a portal, but I'm wondering if the lookup table isn't somehow prohibiting me from doing it. Any help would be greatly appreciated. No books or examples I have found seem to cover what …

Hello- I have a portal with alternating colors (blue and green) for every other row. Is there a way to make the field backgrounds transparent so that the field boxes do not interfere with the portal row colors? Please let me know. Thanks in advance...

Someone please help! I

This problem doesn't happen all the time. Im running a multi-site DB and this problem didn't develop till I brought up the other site. The portal shows the active clients and related info. Clicking on the record # takes you to another file where the record resides. The relationship is based on a calc field called status in which it either states "Active" or "InActive" on the record end, and on the interface its a field that has "Active" in it. When an employee is finished with said record, it takes them out of that file to my interface file (main menu). When it gives me the message "computer so and so is modifiying record" it says that for every record thats in the p…

In Ver. 6 I could make a 1 or 2 pixel heigh row in a portal that I would use for bar graphs (filling the rows with a container of color). When I went to do this in 7 I can only get each row down to about 5 pixels. Am I missing something? I have tried getting rid of the lines around the portal and also adjusting an empty portal with no fields. Charles

Hello everyone... I am not sure the best way todo this....so if what i describe does not sound like the coorect way please someone tell me... What I would like to do: I have a table named "Policies" is has about 50 fields...it is getting pretty cramped...So I would Like to make (or define) a field to become radio buttons named Program_1 and Program _2. When you select Program_1 the portal with the correct fields will show up...when you select Program _2 those correct fields will show up.. Now here is the tricky part...I would like the portals to be overlaping one another...this was it will take up less space...also when the user selects the correc…