Portals

I've been having problems with repeating fields (up to 100) displaying in an area only 3 rows deep - although I have selected a vertical scroll bar to be displayed, it doesn't. So I can't add more than three rows...I'm sure this should not be happening. Any thoughts gratefully received. Thanks Gerard

Hello Maybe I'm missing something obvious, but I haven't been able to figure it out yet. Is it possible to get the values of a field in every portal record into a single field in the parent record? I mean, if I have 3 people with their phone numbers (child records) in a portal of a certain group (the parent record), can I create a calculation field for the group so that the result is "Phone (rec1) & Phone (rec2) & Phone (rec3)"? Thanks for any help you might give me and excuse me if the question is too obvious or has already been answered Best regards Hendrix

Table CC has a portal from table CCL (L=line item table) that pulls info using pulldown lists from Table P and Table S. Then Table L has a portal from table LL (L=line item table) duplicating (most of) portal from Table CC Workflow of above is create record in CC once that is established you move onto Table L and Create that record from where you create a report or invoice of combined info. ALL ABOVE WORKS FINE so I would think that my relationships are ok! Needed to add another field in CCL table to set rate for each record (this field is a percentage value list). This rate has to be used in conjunction with a Fee field in Table L to find the commis…

I think I am after the impossible but here goes anyway. I must create one table to handle two different types of records. This is not ideal, I know but I need them to display in the same protal by order of date. I can report on them seperately through scripts though. One type of record has a cooresponding form view and there will be a "goto related record" button in the portal. The other type of record has no form view as the entire records data is easily displayed in the portal. I do not want the "goto related record" button to appear in the portal records that do not have a cooresponding form view. I can make the button a calculation field - result is container, …

I'd like to offer my users a search page, lookin kinda like this: I want the search to look in many, many different places throughout my database. The only advantage I have is that all the tables to search are related. The search results should always be the same "top" records from the relations graph. The easiest way I could think of to do this is to have one layout with every field -- but I have subrecords and sub-subrecords so I would need something akin to a portal within a portal to see it from one layout. Any suggestions how to go about doing this? Super-simple, silly sample file attached... in this file, I want a layout with two search fields…

Hello, I'm creating a solution where users enter in orders and choose the customer associated with the order from a seperate customer table. I'm working through the book "Using Filemaker 7" which is both helpful and confusing at the same time. Here's what I am trying to do. Thanks for bearing with me here! I am using popup windows a bunch - What I have now is a popup window that brings up a filtered portal by a global text field. You type in the first few letters of a customer's name and that filters the portal. I want to have a button on each row in that portal that the user can press to paste in the customer code from the customer table to the order …

I am so new I don't even know if I know how to ask this question correctly, but hopefully you guys can help. I have a table for Print Specs. I have a table for Fulfillment Specs. I am creating a variety of packages (Fulfillment) using a combination of pieces (Print) Each package is a totally unique combination and quantity of pieces. I created a table table to hold the quantity of each piece as it relates to the package. I have a layout showing Fulfillment Spec Records. With a portal showing the related Quantity Piece Records. I need to take the "quantity" field of every portal row in the record to create a "total" field in the Fulfillment tabl…

I would like to manualy sort records in a portal by draging the record to the row I want it to be. After that the portal has to sort itself in the new situation. (like aranging lines in a FMP script) The last part (sort) I can figure out myself how to do it. The draging (& release) part I do not know. The closest solution I know is a template file called 'clicksort' for an older version of FMP.

I have a protal -- really simple one... and it is sorted by last entry on top... But now here comes the probelem -- When I go to print a report which has the portal field on it... the reports prints the first entry not the last. How do you get a portal to print the last entry not the first on a report? Joseph

Is there any way to show the values from one portal in a multi-column format? So, for instance you could have the portal as 4 columns of 5 values each? I think I know the answer to this one but thought it was worth a shot. thanks!

Ok, I have a portal of only 4 rows. I want to show all the portal records based on and empty field. If portal field has been entered, than it should not show. I am workin with 5.5 so it is not as simple as 7's adding another relationships based on the filter critera. Any ideas? Many thanks in advance!

Hey guys/gals, I want to have a button called "Test Code 133" that once I press it, it will trigger a script to populate the portal (in one row) on the same layout with the relevant related information for the actual Test 133. Can someone please help me get started with this script!? Thanks in advance! J

Is there a way to limit the results returned by a portal. For example, I have a bunch of entries associated with a contest that all show up in a portal. What if I just wanted to see the entries from everyone from Texas in the portal? Thanks, Jeff

I'm a fairly intermediate filemaker user but for some reason I cannot figure this "simple" problem out: I have 2 Files: (Week) (Days) The "Week" file has two fields "StartDate" & "EndDate" --- the "Days" file has two fields "Date" and "Amount". The "Week" file creates records in the "Days" file for however many days are in between "StartDate" & "EndDate" and assigns the "Date" field in the "Days" file to the corresponding date. (I can explain why I do it this way, but it's a long one) Anyways I'm trying to create a calcuation field in the "Week" file that takes the "Sum" the "Amount" field of 3 days (Friday, Saturday, Sunday) from the "Days" fi…

Hello, I'm in need of a little help again. Given fields: max # of Pieces per bundle # of total pieces Calculated fields: # of bundles needed # of peices in last bundle (always less or equal to than max # of pieces per bundle) These two given value fields are unique according to each record. Once I have the calculated fields, is it possible then, to generate (in a related database perhaps?) one tag per bundle, such that if the # of bundles needed is 4, 4 tags will be generated, and if either of the two given fields are changed, such that the number of bundles needed changes, have the other related database update the number of tray tags which a…

in my listings by name layout, i want the category field to reflect all the different category values associated with a particular memberID. i thought i would want to use a portal for that, but it doesn't seem to work the way i set it up. can someone help me out? thanks so much db GLCCtestdatabase.zip

hi all, am trying to do something that should be really simple. ive got a database for a small publication, to keep track of all our clients and what editorial/advertising they have had with us. i have got 3 related tables: company info (addresses etc) people issue content (each record is an article or advertisement) i have a layout called booking form, which displays current/future ad bookings. on this layout, i also need to display a particular record from the people table. the people table has a field called 'billing contact', which is basically a checkbox. the user specifies which person in the organisation is the contact for booking ads, and i want …

I am using a portal in my layout and have checked the box to include a vertical scroll bar. I have successfully used this in other layouts, but in this database, none of my portals show the scroll bar. 1. Any ideas why? 2. Does anyone know how to keyboard navigate between rows/records within a portal? Any help would be greatly appreciated~ dales

Ok I have a portal with 23 rows I want to be able to select any of the 23 Rows and goto the record which is showing on that row. SO what I think I need is a way to copy only the row I clicked on so I can paste it into a search is this correct? If so how do I do it?

I want to be able to perform a find and then assign a name to that find in a portal so that I can research for that name again later and get those same records - in other words, I need a script to Set the portal Field row for all of the records in the found set - Then this exact field text is stored in each of those records and I can then search by that text again later to pull up the same records. If anyone has any ideas that would be great - I guess I just don't know how to set the field across a set of FOund records. Thanks! Sarah

I have a table for my Contacts - in this table, there is a portal which shows Communication History - with two fields: COmmunication and Date. THe relationship I have created between the tables is Contact Name. I have many other portals throughout my database that work, yet for some reason, the same communication line is showing up in ALL records - so I see the same text in each portal! What's up with this? note: I only add new records into the portal - then this creates the new record in the Communication History table - shouldn't it automatically enter the Contact;s name if I am entering into that specific Contact's portal? Help me please!!! THanks, s…

I have a layout that shows details of a client. In this layout, I have a portal that lists the invoices received by the client. I would like to have a button in each portal row that takes the user to the relevant invoice on the invoice layout. Any ideas?

I am a rank FMP 7 newbie so please help point me to the correct forum I have two tables conferences and invitations. These are related via conferences.pk_confID ->invitations.fk_confID need( would like) to create a layout ( call it view invites by conference) that will display all invitations to a particular conference. How do I... 1 create a portal(?) to display all conferences with in the layout 2 allow the user to select a particular conference from the portal 3 automatically update the layout to display invitation from the selected conference. Perhaps I should post this under the protal forum but Im not really sure that a portal is the…

i am having trouble getting my head wrapped around this issue. This is what I am trying to do: I have a user table, a project table, a tasks table, a activity table and a log table. Users have a set of projects they are assigned to (i am using a linking table to assign users and projects). Each project has a set of tasks (another linking table). I want in my activity table to select the user, the date and then in a portal allow them to keep a log where they pick one of their assigned projects and then one of that projects assigned tasks, then enter time and comments. I have a related value list that works (showing only that users projects) on the activity …

I have a portal set up called "Activity History." I have set up a script that allows the current Activity to be transfered into the History portal each time there is a new "Activity" (Status, Location, etc, etc..) - Is there anyway to set up my portal so that the most recent activity is in the first portal row? i.e., each time you add a new portal row, each row moves down one to accommodate the new line. I even tried sorting it by date - but for some reason it still doesn't sort - any ideas? Thanks in advance - Sarah

I'm building a solution that includes (among others) the following tables: 1. Vendor_Info (companies that we do business with) 2. Contacts (individuals that work at the companies we do business with) 3. Campaign_Info (advertising campaigns, which we run co-operatively with Vendors in the first table) 4. Agreements (co-operative agreements with Vendors to run in a given advertising campaign) Each contact is associated with a given company, and there may be a number of contacts for any single company, each with their own job function (budget responsibility, budget and materials, materials creation, sales rep, etc). The database user will speak with the speci…

I'm doing a small mailer for a project in a Datbase Publishing Applications Course. One of the programs being taught among PSM, RagTime, and Plugins for InDesign, is FileMaker Pro. I've created 3 tables. One that is a database of customers. The other is a database of wines. Lastly a table to tie these two together that lists the customer id and the wine id of the wine they've purchased. My layout currently utilizes this last table, but uses portals to retreive information from the other tables related to the wines purchased table. Still with me? Currently, the mailer displays the prices of all the past wines they've purchased. Because I would like to limit …

How can I automate portal row number when I add records through portal?

Hi, I am a bit new, but I have been so frustrated with this problem. I want to be able to Make a Calculation Field that would result in combining the rows in a portal (in a related table). Here is what I mean. Lets say Table one has Contacts... Table two has their phone #s. I want a field (Hopefully a Calculation) in the Conctacts table that would bring up lets say all the "Related" Phone #s in table 2. So the result would be something like this: (215) 123-4567 (215) 987-6543 (215) 111-2222 and so on.. I was able to do this through a VERY VERY Length process. I would create some Value List based lets say on the Phone # i…

I have created a database for church to track songs sung by the congregation each week. I create the worship service order in this database. The songs sung each week are entered into a "lineitem" table. I want to view in a portal and a report, songs sung grouped by the least, frequent and the most sung. Please note that there is no fixed number of how many times a song sung equals the least, frequent or the most, since the songs will accumulate over the years. I am using Filemaker 7. Do you have any suggestions I might go about this?

The idea is simple. I just don't know how to make it work. The database has 3 main fields: ID Number, First Name, Last Name It is for inputing a name to get the related ID Number. It is for children to use so I want it to operate as simply as possible. The first page I have them Type their First Name. It does a simple find. The second page I want to display a list of all last names that match the first name. Then they could choose - click on - put an X by - something -- the last name and it would continue to the related record and display the ID Number. I created a portal to display the last names, but I do not know how to allow selection of a record fro…

I have a very Simple Portal -- The Portal shows "Amount Due" & "Date Due" I came up with a calc field on the page where the portal sits.. Very simple: When "Date_Due" is < 30 days show a "1"... Now this field is a calc field... so when I go to make a portal on another page that shows all of the "1" nothing happens... How do I get a portal to index off of a calc field that cannot be indexed? Recap: All I want to do is to make a portal show all of the cases where due date is less than 30 days? Help... Joseph

This question was probably asked before, tried to search for it, but couldn't find. We are using Filemaker 6. There is a portal that filters data according to a "Status" field. It shows all records in status "Working". The problem is that if one of the users opens a layout with a portal, and another user moves record into "Working" status, the record doesn't appear on the first user's portal. Hovewer when record's status is changed from "Working" to anything else, it does reflect on the portal of the first user. Any help will be appreciated. Thank you

Post deleted by SJOE

Hi, Can anyone tell me how you create a portal containing only unique items from a table. I used the FM Help as a start - I now have a table occurence with a field correctly displaying either "Unique" or "Duplicate", but cannot make the jump to isolate those records with "Unique" in the field. I'm trying to display the unique records in a portal, and created a self-join with a text field containing the value "Unique", but can't get the portal to work. Any ideas ? Thanks, Roger.

First - Sorry for the cross post - I realized I posted this in the wrong forum. I'm a newbie to FM development and am hung up on what to do here. I have a few tables (please see attached PDF for my relationships graph) that are related that I want to reference in a portal. I want to associate Items to an Auction. The auctions table is related to an AuctionItems table. Items are related via the AuctionItems table. On a layout, I have details of an auction, and want to be able to add predefined items (from the items table) via a portal. I would like the fields Item Number and Item Desc to show in the portal. I **should** have my portal and relationships …

Hi ! First of all im not so sure if Im doing it the correct way but I need some help if possible. I have 3 Tables, Contacts, Projects & Packages Now, Ive created my custom contact database , projects and packages, In each contact form , at the bottom i want a list of packages ive sent to them. On the packages database ive made a relationship to the projects table, so when im adding a new package to send i can choose from a pulldown menu the list of projects ive entered. Ive also created a list view to see a list of packages , Im just testing a scenario where like say each project gets sent to like 200 companies (there are like a 1000 on the…

I've attached a file I'm wanting to have the name field copy itself to a ShedNameFile field at top of layout, and that works like I want it to,but my problem is I also want it to go to Rent Due field to the value list.. all by clicking the Name field. Is this possible? I cant figure it out. Thanks for the help StorageSheds.zip

I have set up several portals with relational files and I just realized that every thing worked fine until I add some new records in the main db file. Does this sound familiar to anyone? What did I do wrong?:

I've read a number of posts, articles and examples on how to create a portal filter to reduce the records displayed in a portal, based on creating a global field and an extra table occurrence. Do you think I can work out how to apply this to my solution . . . I've attached my file, where I want to filter the portal (on the project window) to allow users to filter the results to just show the tasks for the current project, not all the tasks for the related contact. Note: I want to be able to create a task from within the contact window, which is not related to a Project. Otherwise I would define the relationship directly between the project and the task. …

Not sure if I'm describing this well but here goes. I would like my portal to adjust in length (number of rows) dependent on the number of entries that are displayed in it (in other words, hide the unused rows when not filled out). Is this possible? Thanks!

Is there anyway to stop a portal entry from adding in the extra line. I want to add "Plus Vat" to each of my line entries. The trouble is, I get an extra "plus vat" displayed!

Hi, I am a n00b to filemaker. I need a portal to show all the records in a related file(5 records total). Instead of showing all records as a list, it only shows one record, and the other records show up in other records of the layout. Basically for each record of the layout there is one record in the portal and I want all records one the portal in one layout. Please help if you can.

I was wondering if you can create a portal within a portal? Right now i have a portal within a portal and the top line shows the full second portal and the rest of the lines only show the top line of the second portal. hopefully you guys understand what im trying to say thanks for the help, Anthony

Have I reached a limitation for using portals in preview mode ? The issue seems to be that, when using a portal, the depth of the portal area can not be reduced in preview mode based on the sliding/printing options. I have presented the same data in two layouts, as 'main - portal' layout and 'items - list' In the 'main - portal' screen, the depth of the text seems to be consistant, and set to the maximum depth of the text for 'ItemDescrition' and is not reduced in preview mode In the 'items - list' screen, the depth of the text can be any depth (currently max 4 lines), and is reduced when there are less lines of text in the 'ItemDescrition' in preview…

I've got a question similar to the portal filter post already underway. I too would like to filter my portal results using a global and a second TO. The problem is, I want the filter to be a calculation. Specifics: I have a scholarships database. In one layout I would like two portals - the first shows all the scholarship information for each student, that's easy. The second will have the same information BUT will only show the scholarships for the current school year (Fall 2005 - summer 2006). I need also to be able to grab just those scholarships from this year and then insert then into another layout used for printing purposes. Can I filter this way with …

I have three files - Supplier, Parts and Machine Details. I created a relationship between Parts and Machine Details with a machine ID. The problem is that I have a portal in Machine Details showing parts used on a machine. The suppliers name appears in some records but not others. Please can anyone suggest why this happens.I have checked the size of the fields so that there is enough space for the name to appear but this doesn't help. Many thanks in advance. Lesley

Hi, I suspect I should know this but I've gone brain dead! Attached is the relationships for my layout which is based on Employee. The Portal is based on time entry line items. The job title automatically entered from the job bag. What I want to do is ensure that users cannot overwrite the Job Title when they are adding entries from here. I don't seem to be able to stop them. Thanks EmployeeTime2.pdf

Hi All, Can a portal/relationship be based on a calc field?? gt_QualityTest ----> ct_thisRecordQualityTest So that when my global field (gt_QualityTest) is worth "PASS" it would only display records that "PASS" the calculated record level quality test. thanks Dan

I have a table 53 records in it. I would like to show those records as a list in another table. Is it possible to do this through a portal?

Hi everyone, I work for a real estate company and am trying to get a buyer matching system working. I have all the property records in one database and them i am working on a new 'prospects' Database. I am trying to display the matching properties records in a portal in the prospects database I have 2 match fields... property_type and property_area that i want to be able to search by I have a calculation field to concatenate the fields then i use that as a relationship. Then a similar calc field in the property database so the fields match up. (i got that part working from another post here..'using multiple match fields, is this possible?') Well it works…

Hey guys, i am using a portal for data entry. each line item that is added gets validated as you leave the field be a script. at the end of the script i have go to layout origianl layout so that my users end up where they stated. the problem is that they end up at the wrong layout. it ends up at a layout that directly shows the contents of the portal instead of the original layout which displays the portal. i have also tried passing get(layoutname) into the validation script as it runs. it also passes the name of the layout that directly shows the line items instead of the invoice layout that shows line items in a portal. any ideas? to make matters worse this…

I'm currently working on a FM7 solution and just something strange happened...In almost every file I got several portals showing whatever and somehow when you create a new record, in two of all these files 1 certain portal appears already with 1 or more filled rows instead of empty as it should! I use to copy the whole database from time to time and work on the most current version. This strange reaction did not appear in any of my drafts until yesterday - but I don't want to go back to an older version, as a kind of workaround for this problem...I can't neither see a reason nor a way to "fix" it...can anybody explain?

Hi there all! I have a db (one file), a value list (from field, so the field may contain duplicate values) and need to have the unique values for that field in a portal for further operations (i.e. finding). Example: values in field: a, a, b, c, d, c, a ... portal should show: a, b, c, d only! Any suggestions for building the relationship(s) or solving that general problem? Thanks in advance !! Norbert

I have two departments that report to me that I must track in my scheduling database. My schedule is viewed in a Portal. Occasionally I need to view only the jobs in one specific department. I have a script which identifies each department with a hidden text field. I am trying to perform a find (via script) so that I can view a specific department within the portal and I am still getting all records. It sounds simple, I think im missing something thats right in front of me

Will a portal relationship not work if its linked to second occurance of a table? If so, is there a way around it?

What's the best way to compare the values in a portal? Specifically I want to know things like: is the numerical "amount" of a given portal record higher or lower than the previous "amount" (w/records sorted in portal by date).

Hi, I had an idea that in FM7, Portals would no longer be 'refreshed' so that we would no longer have to go through hoops to force Portal Rows to maintain their positions in the Portal. I'm currently altering a Layout and implementing a 'Go To Record' script from a Portal and the Portal is refreshing back to zero each time, which is pretty annoying. Is there some way of implementing this 'feature'? I note that even clicking outside a Portal causes it to 'zero' back to the top? (I know how to work around the problem, so no need to spend time answering that aspect). Thanks, Grant

I have a database that I have developed for a small transport company. One of my portals shows runs that are pending waiting to be dispatched. I use a calc called IsEmpty=(Dispatch).It shows all runs that are pending no mater what date the run is assigned to. What I need is to only show runs for the current date not tommorow or next week just for todays date, Hope I haven't confused anyone. How can I do this? Thanks in advance.

I have a file with basic student information (name, address, city, state, zip, etc.). I

Have 5 Tables: People,Product,License,Catalog and Cataloglineitems To create a Catalog, info is pulled from pull downs from People and Product. One pulldown from People (for Client selection). One pulldown in portal from Product (to add product to portal) One pulldown in portal from People (to add person to portal) the rest come from Cataloglineitem table. Catalog is now created on to the License. Then in License I need to get the exact info created in Catalog + or - a couple of fields to create a license. User first chooses Customer from pulldown coming from People. All of the above working fine...no problemo! NOW...I would like the user …

I have a portal set up in a first file to create records in a second file with a relationship where: "When deleting a record in this file, also delete related records" is left unchecked. I have also scripted where a third file will receive the data of the second file in portal with data appearing like that of the portal of the first file. However, if I use a script to clear or cut the fields of the portal, the related records of the second and third file get its corresponding data "cleared" or "cut" too. I would like to use the portal of the first file over and over (without relying on creating a new record in the first file, if possible). One idea …

I have a contacts database that mainly consists of a pair of tables: Contacts and Contact_Notes. The Contact_Notes database has (3) fields: a Timestamp field, a Contact_ID filed (which is the key field that relates the aforementioned tables), and a Notes_Content field. The idea is that any time a user has communication with someone in the database, they click a button on the main Contacts layout that activates a script that is supposed to create a related contact note record, enter the timestamp, and jump to the Notes_Content field of that record, ready for the user to type their note. The timestamp and Notes_Content fields are displayed through a portal on the main Cont…

Can we copy the value of a summary field that we have in our portal to a different field? If yes, can anyone tell me on how to do it? I've tried to copy the value to another field using a calculation function, lookup and or get field function but unfortunately, none of them works. Also, is it possible to edit/override the value inside a summary field? Thanks all, I appreciate any kind of your help! Rgds, Ren

I have a layout that has thirteen other tables portal over information into the layout. Quick example. Thirteen tables indicating shipping violations. One layout, combines all the information based on the date who shipped. I am trying to figure out a way to get the information for only a month and then generate a report showing how many violations each lab had. Is there a way to calculate a result based on the portals? Thanks in advance, Brandon

I have been experimenting with highlighting portal rows according to certain conditions Mostly it works well but I have one problem in portals where a user can create records in related tables. For example I have a table Routings which holds the ID name and notes for an airfare routing. The routing is specified in a number of related tables. Vias, Segments, Direct flights, and Stopovers What I am trying to do in these portals is to validate data as the user enters it. So that if he has entered data in a portal row but it is invalid then the field or row is highlighted acording to the error. I set up a calculated check field to validate the data... if i…

Hi Everyone. Newbie here. I'm having a difficult time understanding filtering records from a portal. I'm using a many-many relationship with a join table between the two related tables. Here's the easiest analogy I can come up with to describe my situation. I have a school. In that school, I have student records and I have class records. Students can be enrolled in multiple classes and classes can have multiple students. I've created a join table to handle this many-many relationship. Now, when I enroll a student in a class, I create a join table record linking the student with the class. I can go to a class layout and, in a portal, see all the students enro…

I need to create a fairly complex database system with a variety of related tables, and am having some issues with the main contact management part of the database. Here

how can i duplicate the records that is inside a portal? for example, i have 4 tables. the first one is transactions, with fields: recID(autoenter serial), name, date, amount. 2nd one is transItems, with fields: recID(autoenter serial), transID, item, qty. 3rd is duplicates, with fields same as transactions. and 4th is dupItems, with fields: recID(autoenter serial), dupID, item, qty. transactions::recID is linked to transItems::transID transactions::recID is linked to duplicates::recID duplicates::recID is linked to dupItems::dupID now in the main layout, im showing the fields for transactions (recID, name, date, amount) with a portal showing the relat…

I can enter data into the first field of the first row of my portal but I cannot enter data into the first field of the subsequent rows (although I can enter data into other fields in the subsequent rows.) I have also tried this in a script and the behaviour is the same. Any idea what causes this?

I really want to use something like the dynamic portal by Ugo. Except is there any way to create the value list selection from user input (now these have hard coded field for each item ie. Gender, Hair, Eyes, Member, BirthYear, BirthMonth...)? I have tried a file with a table, but then I need individual fields with field names. Help!

I have attached a basic file to try and illustrate what I am aiming for. I have a table "ZONES" containing zones of citiy and aiport codes as specified by each airline... a zone may consist of anything from one to unlimited number of these three letter groups. Fields are zone code (unique) airline (two letter code of the airline for this zone record) name (free text0 TLC'c (the three letter codes within the zone) Notes (free text) g_id for creating the relationship to view zones. g_airline for the view by airline relationship It is setup so that clicking on a zone line in the portal displays the record on the right In the file I hav…

Anyone know of a way to display the current found set of records in a portal? For example, my layout looks at the table "students". When I search for students in grade 8, i get a found set of say 10 records. I'd love to also show that found set in a portal, on the SAME layout. I'm developing this solution for the web, so a new window won't work. TIA, Heather

I just started to use Filemaker 7 coming from access, and directly ran into the problem of not being able to dreate a new record in a portal. The helpfunction says just to type the information in the last line of the portal, but typing is not accepted in the next empty space. choosing "new record" just creates a new record in the main database... I've spent hours looking through the program and this forum, but to no avail yet....please help me to be a good convert!

I've got a portal on my accounts page with orders in it, and I've got a button on each row to duplicate the record on that row. Right now the script for that button looks like: Go To Field[field_in_portal] Duplicate Record/Request Now sometimes it works right and the order is duplicated, but if a field in the portal still has the focus, it duplicates the account record instead of the order. In case I made no sense here's a picture of my portal: The little "D" button is supposed to duplicate the row it's on. Thanks for any suggestions.

In the portal to "sales line item" in my Client database I can view all the sales records for that Client. I can see the total sales figure as well. Any idea how I can break the total sales into Year to Date Sales, Last Year Sales, Two Years Ago etc... I haven't been able to figure out the calculation or if it shouldbe within the Portal or not. Thanks, JK

I'm working on a multi-file db with several portals in different files. To avoid duplicate entries I use a calculation field set to unique as validation. This seems to work pretty well in every single portal except these ones related to a file with all the clients' data. In this case, afer pushing the revert-button the validation error-message provides, the portal seems not to refresh again and the sort-order is turned upside down... The protal is originally sorted by last names. If you try enter the same record twice you'll get the error message but afterwards the portal appears sortet in the order of creation. All portals have the same setup, also all relationshi…

It there a way to show that ugly scroll bar only when needed in a portal? Will

I have a question about using match fields in portals. After searching the forums here I can't see than anyone has talked about this before but I could have missed something. Its really a simple problem but I just can't see any way to accomplish this so any help would be greatly appreicated. I'm somewhat new to FM but am fairly comfortable with its complexities, so bring it on! I have 3 tables in different files, one called Items, the other called Orders, and another called Customers. In the Customers file I have a a portal showing all of the orders for that customer. In the portal I have several fields showing the items and those items are actually fields from the o…

I have a basic customer database. Each customer has specific related departments and products available for order. Within each department there are related products. Also each product can appear in more than one department. I have created a layout that has the customer information and a portal for the related products to that customer. The problem is when I try and perform a calculation of products ordered minus products shipped, any calculation I enter shows up for all the products in the portal. How do I limit the quanity ordered, shipped, and calcualted difference to only relate to one product in the line items portal on the layout? Thank you in advance for the assista…

here is a doozy... I am creating an system that allows me to pay royalties to writers on specific albums. So I am creating Royalty statments. Each statment will have multiple writers on it. Tables are: ALBUM WRITER STATEMENT LINE ITEM I have set up the relationships as follows. Each ALBUM has multiple writers. Each ALBUM has multiple STATEMENTS. Each STATEMENT has multiple LINE ITEMS. I have a Popup menu on the STATEMENT layout that allows me to choose what ALBUM I am doing a statement for... there is also a portal to show related LINE ITEMS. What I am trying to do is have a pop up menu in the LINE ITEM portal row that will display a list of…

So I have a system of tracking the progression of orders. After so many steps it is considered completed. I currently have a portal showing that progression of all the different orders. The question: Is there a way so that when the final step is marked off as completed, that order will no longer show up in the portal?

I have two databases providing data to a "line item" file. I have a portal in one file which enters data via a dropdown list. Is there anyway of checking that the "line item" record is unique. I have tried creating a combined calculation field in the "line item" (name_id & event_id) and setting the validation as unique but that doesn't seem to work. I have tried using a count and self join relationship, to enter "unique" or "duplicate" into another field, but not only does the combined field only contain data from the first field entered, it doesn't change when I edit the record. If I remove the data from the combined field and reenter either name_id or event…

I have some portals that show only the existing records from a particular table. Then in another portal it shows existing records (different table/different portal/different layout), however it also shows a blank row for a new record below the existing records. If I click a check box in that row it makes yet another record... This is not ok - how do I stop this?

I just created a portal - with the "Show Vertical Scroll Bar" box checked - but can't see the scroll bar - although I can "feel around" for it with the mouse and if I grab it - it does work. I tried deleting it and re-creating it - same problem - any thoughts on why I can't see it? Thanks, Mark

I have a report that requires a lot of the detail in the child file and the header information from the parent file. I have setup a Global field in the child file to link to the key in the parent file. I have two issues: 1. I cannot change the value of the global when it is placed in the header. 2. Randomly (it seems), the global is set to one value but the information in the header is from a different linked record (e.g. the child file Global value = 1, but the information returned in the header is from record where ID = 8). Very baffling...any help is much appreciated.

hi all, any idea why a multi-criteria relationship in a portal wouldnt work? it has 3 criteria. a similar relationship using 2 of the 3 works perfectly. i have double checked, and there are correct values in all 3 fields on both sides for it to bring up at least 3 related records but it's not showing them. if i try to enter data in the portal (as i have got it set to allow creation of related records) it says 'the operation could not be performed because one or more of the relationships between these tables are invalid. it doesnt explain why though! i am really stumped, because it is basically identical to the relationship with 2 criteria, and the additional one i…

Hey guys, I have a portal in my Invoice for Product Transactions (Invoice Line Items). No problem there. What I need to do is separate out two types of Products - Physical Products and Shipping Costs - and make two separate portals to display each of these respectively. It wasn't making sense that shipping upgrades be displayed in the same list as the normal products, but for accounting's sake, these all must be considered transactions. So far, I've created two new relationships - ProductTransactions and ShippingTransactions. ProductTransactions is linked by UniqueInvoiceNumber, the same as the original all-inclusive Transactions, except that there's also a…

How much overhead is involved in creating new instances of tables in the relationship graph and using them in portals? The reason I'm asking is that I have a month display in which I want to use 31 separate portals. In the relationship graph I made 31 serperate instances of a particular table which are accessed by a table with a date and 30 unstored calcs that increment that date (eg. date1 = date + 1, date2 = date + 2). How does filemaker store the 31 instances of what is basically the same data in the graph? There wouldn't be 31 seperate copies of the same data stored in the file right?

Is there any way to show multiple records horizontally in a portal, instead of vertically? I have two tables: one of music SCORES, and one of the individual PAGES in each score. Each score has a different number of pages, 2-10. I have thumbnail images of each page in a container field in the PAGES table. This is related to the SCORES table through the unique score number, which both tables share. The PAGES thumbnail container field is displayed in a portal in the SCORES table. Thus, each record in the SCORES table displays only the corresponding pages in the score. However, these are displayed vertically. It would be much more elegant to display the mulit…

I have layouts with a portal on the left and related fields on the right for viewing creating editing and deleting records within the table There are 3 table occurences involved Zones A, B and C... all are based on the same table i'e Zones The layout is based on Zones B with a global field relationship to Zones A (Zones::g_ID = Zones B::g_id) . This shows all records in the table in a portal based on Zones A. Fields used in the layout but not within the portal are from Zones C which is related by the unique value ID field (Zones B::g_ID= Zones C::ID ) This allows me to click on any record in the portal and populate the fields in the layout... so far…

I have text entries in a portal how would i add the number of entries together for only one record

Hello,say i have a list of numbers in a portal how would i add them together

I'd like to get a text summary of the contents of a field from related records in another table. FM does this all the time internally when you ask it to create a dynamic value list from related records. But I can't figure out how to set up a calculation or summary that outputs a text list of one field from another table, with entries separated by line returns. All the summary functions have numerical output. I could use a portal if all I wanted to do was to view the results, but I'd like to able to manipulate the results using text functions.

Is there any way to use a value list to populate a row in a portal? Consider this scenario of a simple sales tracking database .... Database A contains a list called item numbers. Database B contains a layout with a portal of Table C, call this layout order entry Database C contains a list of individual orders. In db B I have a layout displaying all of a customers orders, using a portal to display those rows. I would like to have a value list (menu style) of all the item numbers and use that value list to help automate adding an order to db C. It would be great if the value list could be contained in the portal itself, simply just be one of the fields. …

i posted earlier on this list asking if i should be using a portal w/a realated file in my situation, or if i should just be using repeating fields in my master file to list all the donations we receive. i will want to summaries of this info and somone posted back to me saying portals were the way to go, but now i'm not so sure. here's the situation: i have a master file of individuals w/contact info and lost of other details about them. i wanted a nifty little box w/a scrollbar to list their donations as they come in over the years but the box only needs to show a few rows and then you can scroll down the view the rest as they come in. so it seemed a por…

i'm new to working with relationships and portals in FileMaker. I am creating a portal to display donations received towards our capital campaign in my master file. i have a related file with all the donation info and in it is a field that lists the level of campaign they are participating in. It is formated as a pop-up value list in the related file but not in the Master file. what do i need to do to make that happen? in addition, the fields in the related file are all repeating fields. is that the correct thing to do when using a portal? thanks for your help!!

Hi I have a portal of table 1 in table 2 that have a 2 fields critaria relationship. That work fine. Now, i just want that portal to make appear only the records that are in "Category A"(which is a field that have a Custom values-list) So, filtered-out, all others records that are in others categories. How can I make a portal filtered some records ? keep in mind that i whant to still use the basic relationship for others layout / view. thx guy

on my layout I have a portal to input up to 10 records, which works perfectly on my local machine. When it is over IWP however, the portal only allows me to input 1 record at a time. If I hit the submit button and then go back and edit it again I can put in one more. Is there any way to be able to type in all 10 records without submitting them one by one? Thanks

a couple of things... 1. I have a portal which displays line items in my jobsheet/invoice layout in this layout I would like to show a total for the listed line items - how do I do this? I have tried to do a summary but it doesn't offer the line items total - am I missing something? 2. If I want to delete a line I would like to just delete the quantity field and for this to automatically delete all the info attached to this quantity - how do I set up this? thanks in advance