Portals

Anyone know what to do...I have a pop up list with client id numbers in an invoice which displays a portal of line items I have entered a dummy record but when I go New Record and select the same client ID number the portal fills with the data from the previous entry - what am I doing wrong?

I have a layout set up with two portal windows formated the way I would like the records displayed. Both using a self-relationship, date=:date. At the top of the layout I have the date field displayed so that in find mode I can query a date and have all related records appear in the portals. This works fine the trouble I am having is when I want to print. If there are 10 records associated with 3/15/05, all ten records are displayed in the portals but when I print filemaker wants to print 10 pages, one for each record. I get 10 copies of the layout showing all 10 records in the portals. If I am in list view I can scroll down and see the 10 images of my layout, when in f…

Anyone have a good solution for displaying a portal row in highlight to reflect the current record? Say for example, I have a portal displaying a set of records from the CURRENT table. Not really a self-join but a portal that shows matching records from the current able based on a global. Say, a global set to "New York" and joined to a State field in the current table of contact info. The portal would then show all records with people in New York state. If set a button in the portal to show the related record, I can hop to that record and quickly isolate the current found set to match the portal contents. Then, if I flip through the found set, I'd like to be abl…

Hi I got an identical portal placed on two layouts. When I go to the next layout through a button, I want the cursor flashing in the QTY field on the last line of the portal. I manage to activate the cursor on the first line. But I got no idea on how to activate the QTY field in the last line. I am sure there is a way to do that. Any suggestions would be great!

I am writing a royalty program for a small record company in filmmaker pro 7. I am having a problem printing portals. I have two tables that have different royalty information for the same recording artist. Each table has several different records for each artist depending on how many different types of royalties they get. I have a third table that has a layout for a royalty statement for each artist that has a portal to table number one and a portal to table number two. Each portal line lists a royalty due. Since I don

I have eight competitors in the portal with four of the competitors from two different schools. I wanted to make sure that two from same school are separated by one in the top and other in the bottom of the bracket so they don

Can I have a field that add portal records? I hope I am asking the this right. On the portal,say five names from related record. I need a field that add portal records by showing #, so that I can do the find surch for all record that has five record.

File 1: Record number -- auto serialized Portal w/ item field, type field, qty field File 2: Record number Item Type Qty Relationship record number =:: record number; allow creation of related records works great -- but when I try to duplicate a record in File 1, no portal data is duplicated in new records in File 2. Is there a way to have a duplicate record (with new record number) that includes the portal data from the previous record?

i need to monitor people in a self study classroom as they checked in and out there name would be added to a portal what pc they were asigned to and the time they checked in . i think i could use a drop down list based on the number of pc's in the room. when there record was retreived from the search will be able to asign a pc# then it would time stamp and add to portal bottom of record screen when they checked out could click button on there row in portal to time stamp and remove from portal kind of like the lending libary i need to generate reports how many times and how long each person was in the room this should be simple i am lost on the scripting for the portal i d…

I am new to FileMaker but am familiar with database structures (I am a Crystal Reports consultant). I have what seems to be a simple need: I want to be able to show two levels of one-to-many relationships on the same screen. I have a database for interior decorators. I have a Job table, a Room table and a Room Detail table. I want to create a Job screen that will show multiple rooms with multiple detail items for each room. At first I thought you could put a portal within a portal, but that doesn't work. Is there a way to group the top level and then insert a portal? I'm used to grouping using Crystal Reports but I can't seem to be able to figure it out in…

I have some portals that only show some of the details from the actual table. When a user would like to edit those records, there is a button within the portal they may click. Pleasantly, this button disappears when there is no record to show. I would like buttons to add a new record, and to associate an existing record, in a case where there is no related record to show... it would be great to mirror the edit buttons behavior, and hide when the user shouldn't try to use them. Any ideas how to accomplish this?

Using the Time Billing free solution that originally came with FMP 5.5 and upgraded to v7. Activity, Customer & Project fields in portal are now configured as validated entries by value lists with "Other" capabilities. The problem: I have 74 master records, I want to create a 75th record and so on. When I create the new record and fill in the Employee name & number and the beginning of week date, the cursor jumps to the date field in the portal, (as it should), but all the fields in the portal are filled with data from a prior record. The filled date does not come from the prior record but from a much prior record. I've checked relationships, field …

Hi All, My dbase has invoice, invoice line item and item tables. (And others...) I have a portal in 'invoice' which is selectable from a drop down box. I would like to make this list only contain items that are available - thru searching with the date the item is due to go out and the date the item is due back, to ensure that only available items appear in the portal list. (these parameters have previously been entered) I believe this is not possible. Is this true? I can't think of any other way to achieve this. Any suggestions?? Thanks Terry

I have the Portal List on the left side of my layout and the related Data is shown to the Right To make life easier for my users I would like to keep the selected Portal row highlighted. How can this be achieved? Thanks in advance.

Hi, When scrolling to the last record in a portal it stops at the last record. If I continue to scroll it repeats the last record adding new lines in the portal ad infinitum. Is this a bug, or am I doing something incorrectly (besides continue to scroll)?

I have a portal with a list view. I have a second portal next to it in which I would like to display more details about the selected line in the first portal. Any idea how I would do this? It would need to show only the related info from the currently selected row in the first portal and update as the rows are clicked. Thanks.

Hi there, I'm trying for days now on this one.... I have different tables defined in my db and what I want to do ist simply display the value of a statistic field on the layout of another table. All I always get ist an empty field. Relations are properly defined and everthing ist working just fine. I just can't get data displayed from one table on the layout of another... any suggstions ? Dirk

I am new to Filemaker Pro and am attempting to design a genealogy database for my own use. In theory, each individual in the database is assigned their own record displaying birth, death and marriage details etc. Should the individual have children, I would then like a list of the children's names to be displayed with the user being able to select or click on a child in the list which would then display this individual's record. Would it be better to use a portal or some kind of list/menu field for this. If using a portal, am I able to assign the 'go to record' script to each row (individual) in the portal or only the portal as a whole? Thanks for your help. …

Hi I have a database of companies details (name, address, etc...). Each company record has their profession name listed (i.e. Builders, plumbers, etc...). What I would like to do is be able to email any new companies showing a list (Company name only) of the existing companies within their profession on the email (i.e. Hi Mr Blogs, please be aware that we are currently offering our service to the following compaines within your profession: Blah Ltd, HoHum PLC, etc..). Incidentally, the list should only show companies within that profession who have had a "Yes/No" radio button checked "Yes". The email is plain text so no formatting required (although any tips pr…

I have a layout based on my work orders table. On it is a portal to the work order items table. I use this layout in a script to add new related work order item records and it works fine, except when the number of portal records reaches the total portal rows displayed. Then nothing happens. The step Go to Portal Row (Last) no longer goes to the blank portal row at the bottom. Adding a Go to Portal Row (Next) doesn't help either, the focus remains on the last completed portal row and won't move down to the blank row. As soon as I add displayed rows it starts to work again. Can Delete is on and, of course, Allow Creation is on for the relationship. I have other portal…

Goal: I need to cross-reference two different portal sets of data. This will take manual intervention and decision making. This example is based upon Pickup table (Main), LineItems (Portal1) and Returns (Portal2) but I'm keeping it generic because it will be used in other wonky situations that require manual decisions. User will be presented with something similar to the demo I've attached. Their job is to view the first item in Portal2 and find it's match in Portal1. Only each staff person will know which Portal1 item to select - there are many factors (date purchased, sales reps handle things differently, etc). They will use the radio to filter Portal1 down to…

Hello, I have a number of uses for putting two portals on one layout. One simple example is for a recipe database. A recipe has many ingredients. On the recipe layout, I would like to show the first ten ingredients in the left portal and the second ten ingredients in the right portal. There is no particular order to the ingredients. For example, if there were eight ingredients they would only show in the left portal, but if there were 15 ingredients then ten would be in the left and five in the right Is there a way to do this without a script? I currently have two portals with ten rows each from two table occurances (both the same table) called ingredients…

I have a database with 2 tables..one is all infO of my clients and the other table is Case notes" The second table contains 4 fields..lastname, firstname, date and case note. What is the best way to call up a client record and also bring in their case notes? [email protected]

I have two tables. Table 1 and Table 2. Table 1 has a text field in it where the color of the text is determined by a calculation. In most cases its black. In Table 2 there is a portal to Table 1 that shows this text field. In the portal in Table 2 I need to change the text color to white. How do I do this? I've selected the field, went to format and change text color. No change. Any help you can give is much appreciated.

Hi there. I

HI, My FMP file contain 3 tables: I have a Table named "Project" ,one named "Parts" and another named "Elements" A relationship have been established between "project" and "parts" usind a "Project ID" match field. Then, between "Parts" and "Elements" a 2 creteria relation have been created: "project ID" AND "Parts #" . That all work Fine. So Now, I created 2 portals in "Parts" to show records related from "Elements". Obviously, "Project ID" and "Parts #" must match. But , I want, some of the records related to a "parts", to appear, let say: "sort", in 2 Specific Portal, base on one field that a named "Category". So, if a I have 2 "Elements" for…

I am trying to segregate items into one of two portals based on a calculation as you see in the example. I had a way of doing this in Filemaker 6 using separate files, but I'm having a hard time conceptualizing this in Filemaker 7. Any help would be greatly appreciated.

In fm 7. Say I have 2 portals on a layout. Is there a way to specify which portal to use, to go to a certain portal row? I can do this with 1 portal but if I have 2 portals I need to specify which one. Thanks for any help, Doug

In fm 7. I have on one layout with fields to edit records as well as a portal showing related records, and this is in a single table. When I select a related record from the portal, the record comes up to edit. But I don't want the portal to jump back to the top. So if I select record 20 from the portal I want the portal to stay on record 20. I thought by turning in layout mode, "show field frames when record is active" off would do the trick but it don't seem to. Any ideas? Thanks, Doug

Well, this is sort of a printing issue, but it has more to do with portals. I'm going to be printing a short portal on a form, should be no more than 10 rows. In each row I need it to print the current # and the total number of records. For instance, the form is printing a child's information and I need it to print "Child x of xx" for each one. I'm sure this is possible, but I haven't done enough with pritning related records through portals to know how. I know it's frowned upon printing through portals because it's not the least bit reliable, but I'm being forced to make and EXACT copy of a printed form, so I can't have seperate pages for different print…

Hi, I'm working on a library project, and at the moment, a portal is showing all the loans by a certain person. However, I don't want it to show loans which have been returned. I have a checkbox graphic that indicates whether the book has been returned or not ( 1 = Not returned, 2 = Returned). How would this be possible? I have attached the file in it's current state if anyone needs to have a look. Any help would be appreciated.

I am still a little inexperienced here and know that a summary report can be a solution -- I believe though that such a report will not create a permant record of an invoice. Accordingly, I am trying to avoid using a summary report to create an invoice -- can this be accomplished in a portal? File one with five records: Job Number: AA Record number 1 Item Type: A Qty: 3 Job Number: AA Record number 2 Item Type: B Qty: 4 Job Number: AA Record number 3 Item Type: B Qty: 5 Job Number: AA Record number 4 Item Type: C Qty: 6 Job Number: BB Record number 5 Item Type: A Qty: 7 File Two: For Invoicing Re…

I have created a new layout (one of about 30 in this file) and added a portal. When I add field (from the child record) to the portal and click on Browse, the portal hides the fields! Clicking on "send to back" does nothing. What did I do wrong?

how to filtering portal entry with 2 fields, for example User-----Application-----access type ------------------------------------- Jon-----Purchasing-------Read Only Harry---Shipping---------Full Acces if i entry Jon with Purchasing again, i want to show error duplicate message. Can you help me..? thank you

In a Client System i have a Field: ClientType which can be set to "Potential", "Active", or "Inactive" From my main entry system, i like to use X join portals to show all the available records for any given system. In this client system i would like the portal to show any given set: All Potential, All Active, or All Inactive (no problem so far)... or SHOW ALL. That's where i hit my snag. Theorhetically i can think of a solution using three extra fields, but it seems messy and it uses calc fields as join fields which sometimes give me issues (I get the "relationship won't work" message alot when calc joins are involved...). Any solution ideas? or if i didn'…

Hello, I'm new to Filemaker... I am trying to perform a Find and have the results shown as a list of rows. Then, when I click on a row, additional fields are displayed below the list in sort of a "preview" area. Kind of like an email program where you have the list of messages, click one, and preview it underneath. I created a portal, which I think is what I need to do. But the portal only shows one record, one row. I don't see any settings for the portal to get it to list more than one item. Ideas, thoughts, suggestions? I'm new to portals in filemaker, so please assume you're talking to a dummy if you send help. :-) Thanks!

I am developing a Database for a group of novice Filemaker users. The database has - a table of contracts - a related table of territories for those contracts - a related table of Inventory for those contracts My challenge is about building a simple user interface for SORTING a layout that displays a variety of related fields. My main layout is a columnar list of contracts. For each contract record in this list there is a portal which contains the related territory field (sometimes a contract has only one territory, sometimes several territories). Also for each contract there is a portal which contains related fields from the inventory table. As we…

Hello, It's a problem in the web page. I use the web publishing wtih FM7. In my form I have some textbox, they are set to be just an X or empty. I have 8 textbox who represant a protection: glasses, boots, gloves, mask, ... In the table of protection it have actually 11 records. I have script when I mark a textbox with the X that do appear a icon (jpg) on the page. If you put X in the textbox of Gloves the picture of gloves appear. Everything works well in FM. My problem is in the web page. My picture not appear all or it's the wrong picture appear. Sometime I have X red in a sqare like when the picture is'nt found. I can change the picture jpg and I see t…

Just a quickie... I am using a portal to display a single field of related data as a visual cue only. Actually, I'm using a portal to show/hide a set of buttons for performing an operation - it only shows up when I set a flag. The problem is, if the user clicks near the buttons but not on them, the portal that they are sitting in gets selected, and this big area of the screen turns black. Is there a way I can keep portals from being selected like that when a user clicks on them?

Is there a way to have a field value auto-set from the value of a field in a particular portal row? I want to do something like this: Field a = ::field x 1st portal row Field b = ::field x 2nd portal row Field c = :field x 3rd portal row. I need to 'hardwire' this somehow - it re-calculates daily with 000's of records so a script approach using 'set field' or similar is not practical.

I am in the process of building a 'cash register' database. The enclosed files will help explain much better. I initially created the database to be all inclusive in one file. As the line items were entered, the subtotal, tax and total were all calculated on the fly. Everything worked great. (first layout in enclosed file) Now, We would now like to separate the data from the layouts..in two separate files. Now, in order for the subtotal, tax and total to calculate, the user must first click outside the portal. then it calculates. (second layout in enclosed file) I presume, that all of the information entered does not actually get sent to the linked…

Hi there, The portal I'm using is for use at the user end of our database. People enter timesheet information creating new rows for each job they do. - very simple! The problem I'm having is that we need to include a page worth of free-text description boxes that pertain to each entry into the portal, which ideally should be entered from within the same database. If i have my portal on one layout, is there anyway of having a button that can switch to another layout which has the free text boxes layed out, and these boxes relate to one specific row on the portal. I've started trying to create a script which copies the unique job ID number that is cr…

I am a teacher in the process of creating a database for staff use. The database contains a number of portals. In one portal, I have included a print button which shows in every portal row. I had hoped that the print button would use the field data in that portal row and use it in a letter to be printed out. Alas, it is not working as it appears that only data from the first portal row is being used. Simply, how do I ensure that, if I click the print button in the 4th portal row, the field data in that row gets used in the letter, and not the field data in the first portal row? Many thanks! Frank

Is there a way to create a portal that shows data from two seperate tables. This is what I'm trying to do. I have a table titled builder with a portal. There are two other tables. One is titled Collection. The other is titled DataFiles. Users transfer records from the Datafiles (which is a database of all posible records) into Collection (which is actually what they have). What I need is a way to bring data from Datafiles and Collection into the portal in Builder, and have an icon that tells the user that this record is not in thier Collection. I hope this doesn't confuse you. Any help you can give is much appreciated.

Still learning the basics: File One Job Number Item completion date completiondatecalc IsEmpty(completion date) = 0 result is text File two jobnumber completioncalc constant "1" portal: item I would like the portal to only return those records of file one matched by job number where there is a completion date. When I try to establish a relationship, completiondatecalc::completioncalc constant, I get an error message saying that using "completiondatecalc" will not work since it is not indexable .... What am I missing here?

I have a layout that has portals to two different tables. Right now, it seems to print OK. I've read that this should be avoided but I don't see how with my present set-up and needs. Is there any reason to expect problems with this in the future if it is working now? Neither of the portals has more than one line. Thank you.

To have a portal sorted in diferent ways I have the sort order of the relationship based on a calc field, which takes its value from a global field. By changing the value in the global field I change the sort order of the portal. The problem is that I have a mix of text and number fields on which I need to sort. If the calc field is formatted to be a text result, the number fields are sorted as if they are text - for example in ascending order I get 1, 105, 2, etc. If the calc field is formatted to be a number result, the number fields sort correctly but the text fields don't. Is there a way round this?

I am working on an invoice layout. I have an invoice line items portal on the invoice layout. We have too many products to have the product ID field in the portal be a drop down list. So I created a script that would pop up a window showing all of the products. The user clicks into the product id field of the product they are adding to the invoice and then clicks a button. The button I had going back to the portal and go to last portal row and pasting the product id value into it. It isn't consistently going to the last portal row. It sometimes will overwrite the first product entered into the portal. How can I get this to work consistently. Do I need to set a glo…

Hi I hope someone can help a Newbie with what is probably quite a simple problem

I was under the impression that relationships could work beyond one level in portals and such in FM7, but, alas, i am not getting the desired results. DB's: Vendor, Category where Vendors can have an unlimited number of Categories assigned to them. I have a "Primary Category" field that sets the vendors specified category to "primary" otherwise, it is considered a secondary category. Relationships: "vendor.category" - Vendor::VendorID = Category::VendorID - sorts based first on Primary/Secondary and then by category name. "vendor.sj.all" - Vendor::Developer x Vendor::Developer - Creates the "show all" relationship On my Vendor Entry / Edi…

Hi I am trying to create a daily timesheet to help tract time and costs. I thought I could use the weekly time billing template that comes with the programme and adapt it but have hit calculation problems. I then tried to create from scatch but can't make the portal relationship work. I want the timesheet to work as file attached (Time Sheet Lorna.fp5). The related file (Time Sheet Lorna Items.fp5) that my emloyee sees just has the basic information that appears in the portal. I also need to link in the related file (Time Sheet Lorna Billing.fp5) which only I see which has fields that allow me to search by job number and work out time to bill on each job. …

hi there, i am very new to portals, and not a trained developer by a long shot, so please bear with me... i work for a small independent newspaper. we have a large contacts database, in which i have added a table to track content in the paper (editorial and advertising). i want to link these up, so it's possible to see what articles were sent by a particular company, or what advertising they have done. i have two tables: contacts (the parent i think?) and content (the child?). because i need to be able to store the article information separately from the advertising, i have created two different relationships. the contacts database auto-enters a un…

I have a portal that contains information about various projects. I set it up to sort the records by project number. I'd like to give users the ability to change the sort criteria. For example, they may want to sort the records by status, or by date. This seems like something that should be pretty straight forward to execute, but for some reason, I can't seem to find a way to do this. I understand that I'm usually brain dead on Monday mornings so if this is a simple solution please cut me some slack. Thanks sifter.

I have a portal in a table that is related to another table labeled employees. The employees table contains all pertinant information for that employee. The portal shows the employees for a given apartment complex. The information is first name and last name and status. I want to be able to click an Icon within the portal and be taken to that employees information page. (The Related Table) 1. If that is possible how do I do it? 2. Can I make the portal show only employees that are "Active" Any help is appreciated.

I have two databases joined one to many - "customers" and "equipment" The form shows "customers" information with a portal showing related "equipment". Customers each get unique serial number generated sequentially as they are added. As I add records to equipment in the portal, I want to also generate sequential equipment serial numbers 1,2,3 so that I can join the two serial numbers to get unique customer-equipment number that will be used to tie other joined databases. Example: Customer "1" has equipment items 1,2,3,4,5 that will be identified as 1-1,1-2,1-3,1-4,1-5. Customer "2" has equipment items 1,2,3,4,5 that will be identified as 2-1,2-2,2-3,2-…

I have a database that prints out a two page invoice. There is a portal on the layout that spans two pages because the orders have so many items. It works fine for the most part, but if you change the printer then the printable range changes and I have to go in an modiy the layout. Is there a way to link to portals? Can I put on on the first page and then have he second one pick up with the remaining records? Or can you think of another way to get a portal to span two pages?

I run a Sick Children's Fund where I have a parent table listing the clients (children) and their details including location. In a related table (related by Serial Number)I record disbursements to each client. Each client usually has many individual disbursements over a several month period. I am using a portal to record each line of disbursement which creates several records (called Amount) for each client. I use a summary field for the total amount given each client. I need to create a report grouped by location and sub summarized by the amount spend in each location. I can group the location but the best I can get the report to do is list each record of e…

I have a script which copies text from a portal row and pastes it for viewing into a different layout. I have a button that then navigates back to the original layout. There may be 20 different rows in the portal. How do I write the script to navigate back to the same portal row I just pasted the text from?

Hello, I want to change the initial row # in a portal from a script. I looked around for this and couldn't see that anyone ever came up with an answer? Thanks!

Hi, In order to stop bad user entry into my database, I need to stop more than 40 orders in total being placed. A customer can have 5 orders, 5 "active" orders that are not set to cancel. But basically the user enters the orders via a portal relating to the orders table. I need a way that when they click the Weightneeded which is a popmenu of weights, a way to check that there haven't been 40 orders. So far i have tried adding a script to the field but i just get loads of problems like the dialog wouldn't show and it wouldn't count correctly, here is the script i was trying to use: If(OrderCounterSum >=40) beep show dialog("Error" etc) ElseIf goto…

Ok guys and gals, this should be fun. I have File A which contains job records, one job per record. File B has late letters that I have sent for jobs that haven't been paid. I need a portal in File A that reminds me to send a second follow-up letter, after 30 days have elapsed and the silly people still haven't paid. I delete the letter from file B when they have paid so there aren't any letters there that don't need to be. I'll create a third file "C" for the second letter sent, but that's another story. Right now I just need a portal that shows me all the job letters that are 30 days old so I know to send a follow-up letter. I have a Menu layout in the job file "…

I am still working in version 6 of Filemaker. I have a layout where I am working with a limited amount of space so I need to display the same portal in 2 columns, 5 rows displayed in each. I need the second column to start displaying data at row 6 thru row 10 . I know that in version 7 this is an option but I am not ready to upgrade this application yet. Dose anyone have any ideas how to do this?

Is there any way of keeping the portal row from being highlighted when clicking in a portal row. Other than changing the portal layout. thanks

Hello, I'm new with FM. I must debug a web page. We had an application running on FM4 someone import pages in FM7. With FM7 we try the FM web server and I have a model (layout) who works correctly in FM7 but the problem is when I try this model in a web page, some icon not appear or not the good icon appear. I think it using 3 tables. The major table can have some "X" for some fields and when it have a "X" it must appear an icon from an other table. Example: When the field Glove have "X" the icon Glove must appear. Do you have an idea why some icon doesn't appear and sometimes it's not the good icon appear? Thanks for your help.

On one of the FM forusms, I had seen references to a portals book. It may have been privately published. Does anyone know anything about it? Thanks.

I am using @@ to number rows in my portal. However, FM always puts in the next row number even if the row is blank. Is there any fix for this. I have tried using {If(isempty(SerialField); ""; Get(PortalRowNumber))} This wont work either. Ivan

I have a portal of 11 lines on my sales form tied to my invoice line item table. Great. I've set up a subtotal of all line items on the portal. The calculation for this subtotal field on my Sales form is: Sum(OrderLI::LineTotal). Great. Works fine for the first five line items then it craps out giving me a ? in the subtotal field. What's up??

I have 3 tables: ProductSales;ProductLineItems;ProductInventory. ProductSales is related to ProductLineItems via Invoice#. ProductLineItems is related to ProductInventory via ProductID. I have an order entry layout based on the Product Sales table. It has a portal based on the productLIneItems table which allows users to enter in purchased product. I have another portal on the layout that is based on the ProductInventory table. In this portal I wanted to show OnHandQuantity for the product that a user is entering. It works for the first product entered into the LineItems portal but it doesn't change when you go to a different product on another line. What am …

hi, I have a problem with a portal showing unwanted records, basically a user can cancel an order, but when cancelled the portal row needs to omited somehow from the portal, basica structure of db, tbl_customers, tbl_orders and tbl_turkeys. the reason that i don't want them deleted is due to the business wanting to keep a record of all orders placed. Maybe an export to a file would work? dunno played around with it for ages and still no success. The user cancels the order by pressing a button, this is to stop uncancelling orders and for validation. any help would be great! MnR

I have a portal which contains multiple related records that I want to merge to a letter. Example: Record 1 has three associated portal reocrds. The fields are MealType, Date, and Cost Estimate (i.e., lunch, 2/21/05, $8.75). I want to insert/merge all three related records into part of a letter. I am able to merge the first related record into the letter but I'm unsure how to merge the rest. Any advice?

I have several portals on a layout and I am trying to go to a specific portal based on certain criteria. If i just use Go To Portal Row, I will get the first portal on the layout. What do I do if i want the second portal, etc. ? Thanks for your help.

I currently have a 5.5 file that tracks customers and what they bought. It has worked for a while but my business has outgrown the functionality I built into it. I recently picked up a copy of version 7 and would like to build it the right way this time. Here's what I have currently. In the file I have 3 Tables. One for the customers, One for the orders, and one for the detail of each order. My reasoning for doing this is because of repeat business. I'd like to be able to easily see all of that persons orders. Ultimately, I'd like to display all of this information on one layout. I set it up to display 2 different portals. The main layout is the customer in…

Hi, I have a portal in my solution with a number of calculation fields. 2 of these calc fields show $0.00 on the last row which is not a record. The fields: Desc Bid Price= "Desc Cost + Desc MU Amt" & Total Desc Bid Pre= "Desc Bid Price * Quantity" show $0.00 on the last row. The fields: Total Desc Cost = "Desc Cost * Quantity" & Total MU = "(Desc M U Entry / 100) * Total Desc Cost" show nothing. All fields have same number format: format as decimal, fixed number of 2, $ notation, use thousands separator. How can I get rid of the ghost $0.00 and what makes them appear on some calcs and not on …

Guess I posted to the wrong area...so here goes again. I have placed a portal on my sales layout from my products list. I can get it to select a record from a pop-up menu to display a record from products...great, however, on the next line when I choose another record the first line is replaced to match the second line. Plus the third row will not show the menu to select another Product ID?? Any ideas? Thanks.

Hi Guys, thanks for all the help so far, am getting along in leaps and bounds ! I would like to use a portal to display a conditinal value list, is the possible? I have a table which contains names and type of person, eg artist, producer etc, and from this through a third table have created a conditional value list which shows a list of only artists. For reasons of IWP I wish to have this list displayed in a portal for people to select and enter data from, is this possible? Thanks in advance Steve

In FM6, I used to use the disappearing portal trick described on page 414 of "Special Edition: Using Filemaker Pro 5". Basically you use a portal to make buttons and fields diappear or reappear based on a relationship. I can't seem to make this same bahvior work on FM7. I'm trying to make a "show all contacts" button disappear when the user is viewing the complete set of records, but when the user is viewing a smaller found set, the "show all contacts" button would reappear. Any idea what I may be doing wrong? Or is there a change in behavior in FM7?

Newbie here trying to set-up what I think should be a simple portal. I want a button that will allow me to add the current date in one field and then on the adjacent line it will allow me to enter as many lines of free text as I want. Each time I press the button the most recent date and note will be added to the top of the list. I can draw this out (see illustration below) but can't seem to define the fields, relationships and write the scripts to get it all to work. It seems to me I'm making it harder than it actually is. Any help is greatly appreciated.

I have database where each record is a client. I want to display all the clients in a list within a portal on a browse layout. Is this possible, and how would i set up the relation to work?

It is certainly a beginner problem (that's what I am): I need to extract the amount of different records(textpatterns) from a field and publish it as a chart (i bought a small programme therefore from http://www.briandunning.com/store/invoice.php) I tried several solutions from this site but so far successless; My own approach: case.... and thereafter sum(field) failed because of circular problems. What would be the fastest result on a fair amount of different text strings within a field???

File one: Record number field Process field Category field File two: Record number field Category field Portal containing Process field. If File one, Record number=::File two, record number for the portal and the Process field within the portal then this Process field returns all Process entries of File one for a particular Record number, regardless of category. What relationship(s) are needed to get the portal to only return only the Process entries of File one by only one particular category for a particular Record number without the category field being present on either the general layout or the portal of File two?

Is there any way to turn off portal highlighting for specific portals? I have a few one to one relationships that use large sized (as in a 400x400 pixel rectangle containing 10 fields) portals to display information, if the user misses the intended field with a mouse click they are greeted with a large black rectangle. Not the end of the world, but it is ugly and I know it will cause confudion for some of my users.

I'd like to create a splash screen to open my database. It would have two buttons to navigate to other files -- that's easy. I'd also like to have a portal displaying all records from one of those files. I seemingly need a relationship between the spash screen file and the target file but am not sure how to create one that will let me view all the records by a particular field since there is no inherent relationship and the spash screen will always be just one record. It must be easy but I am missing it in the moment.

Ok, I'm stuck with a portal related problem. I have a portal thats displaying textual IDs from another table. There are up to ten related records being returned for each record in my database. I need to get all information out of each related record summed together into a single field in the database. For example, in a record in the database I have IDs from four related records in seperate portal rows 0027s1, 0027s2, 0027s3, and 0027s4. I would like this to become one single field that [0027s1 0027s2 0027s3 0027s4]. I have no problem summing togther numeric and date information, but am having no luck figuring out how to do this with text. Is this possible…

I have a master password, a teacher password and a pupil password (blank). Each has it's own group. Two seperate portals appear but the data is not visible under both the teacher and pupil groups. Why do these two portals only display data under the master password?

Hello all, The portals in my database to not scroll properly. The portal is only three rows tall. When a fourth or fifth item is listed in the portal and I try to use the scroll bar to view them, I only see garbled information for the rows that are scrolling into the portal. If I click on the scroll button some more, the entire portal fills with the same garbled data. Do any of you know how I might fix this? The attached image shows the forth item in the portal repeating after I clicked on the scroll bar again. Thank you! John

In the OrderEntry table I have portals to two other tables. When I enter a product number it fills in the product information from these two tables. I would like to be able to "lock" the product number once I have clicked or tabbed out of the field so that the only way to change the entry is to delete the portal row (and thus the related records in a line items type table). This is due to using this field in a look-up in another table which, of course, won't change due to being looked up so I need it to be deleted if the product info changes. The looked up value there is required for a calculation and needs to stay dynamic. I hope this is clear. I tried unchecking the all…

Hey guys, I've just started using filemaker, I'm coming from a web database programming background. I understand relationships and all that stuff, but I am still coming to terms with how FM deals with them. I have a simple setup so far. Im keeping track of a set of lawsuits. I have a suits table and a parties table. I have a join table linking them, with a field for the suit id and the party id. I also have a field in the join table telling whether the party is a plaintiff or a defendant. On the layout for the suits table I added a portal to pull a list of the parties involved. I added the field in the join table for partytype, but in all of the rows it on…

Forgive me if this is too basic a question but this is my first multi-window multi-table-per-file FM7 DB and there's something I just can't seem to get to work (something that was an easy 1-step action in a one-table-per-file environment). Let's say I have two windows, A and B. Window A contains a portal. When I click a button in a portal row, it should bring up the respective record in B. My problem is that there is no "GTRR in EXISTING window X" command (AFAIK) and if I use SELECT WINDOW first, GTRR won't work anymore. The only way that I see at the moment would be to use a script that selects window B, saves it's size and position in globals, closes window B, rese…

My portal has several fields on it. Several of these are filled in by choosing from a value list. The value list makes it own data from the field itself by way of allowing other as data is entered. The value lists come from fields in tables other than the one the portal is viewing. All of these work except one. As I use the value list, it will accept the data. But then when I try to add another item to the list, it wants to change the value that is already there. I can't get more entries, and it will change the entry to be the latest one entered, in all the records. At first I thought it might have to do with the position in the portal, so I moved anoth…

I am developing a project management database in FMP7 that has several hundred projects being tracked. After a good deal of interface design sessions we settled on a primary layout whereby a portal on one side of the layout lists all of the projects and the remainder of the layout contains the detailed fields for the project selected from the list. This is accomplished with a Table Occurrence of the main Project Table related back to the main Project Table where an auto-entered serial field with a constant value of "1" is the key relationship field so that all projects are listed at all times in the portal. A related record script button overlaying each listed name…

hi, As people suggested repeats used to store data is not a good idea, now my setup has changed from having repeats to a 1 to many table relationship between customers and orders. Basically a customer can place 5 "active" orders, now once they are cancelled they need to be still kept in the database. So i need a way to only show the active orders and filter out the canceled orders. MnR

Hi all! Wondering if you can help this poor girl out before the day is through... I have two tables, InvoiceSummary and InvoiceDetails. The data entry portion works great - have a portal set up that allows users to enter line items in the InvoiceDetails page for the related record in the InvoiceSummary table. However, I do not know how to print out all records in a portal. For instance, one invoice has 26 line items. How do i print a invoice that has all the headers from the Summary table (Name, Address, Phone, etc.) and then be able to print all related records from the Details table (Qty, Amt, Etc.) When I used a portal, all I can see is the first 5 o…

I don't know if this is possible - but how can I make it so that the contents of a portal are visible _all the time_, even when the user is moving the portal view by dragging the scrollbox in the scrollbar? The contents are visible when scrolling, but only if you use the up/down arrows in the portal's scrollbar. If you drag the box, the display locks until you stop moving. This makes finding items in a long list somewhat slow.

I don't know if it's possible to accomplish the following or not: Say you have a data table - each record in the table has three fields: Brand (Apple, Dell, DEC, Samsung, etc.) Type (Computer, Monitor, Mouse, Keyboard, etc.) Color (Beige, Black, Grey, etc.) You want to view these records via a portal - but you wish to be able to filter the portal contents on the fly. You define 3 global fields: g.Brand, g.Type, and g.Color. You set up the global fields with value lists, each matching possible entries in your data records. Now - if you enter 'Apple' in the g.Brand field, the portal should show only those records that are Apple brand. If you t…

I'm not sure exactly where this needs to get posted. I am trying to create an invoice that allows you to keep adding items to it. There will be a button taking you to a screen where you choose what is to be added to the next line of the invoice. The invoice will be automaticaly updated with the new item. This will be for creating printing invoices. Here is an example. I create a new invoice and select add quote. I am then taken to a screen where I enter 1000 prints on 80# cover stock etc.... I am then returned to the invoice and it is automaticaly updated. Then I click the add item button again and am taken through the same process. Does this make sense? I …

According to FM, they fixed the issue with portals not refreshing data when pulling data from distant tables. My problem is it is still doing it, despite following all of FMs instructions with the 7.3 update. I have data that is dependent on a key that is set in one file (with the portal) and then pulls data from another. The cost displayed in the portal only refreses if I enter a quantity (thus forcing the calc) or if I go to define database and go back, then every cost is refreshsed. Is anyone else encountering this and any ideas for a fix? Thanks.

I have a DB with a varying number of records per client. (I.e. client A have 5 records, client B have 1 record, client C have 12 records, client D have 0 records and client E have 3 record) One part of the DB shold in a portal reflect what clients (at that time) have records, and how many. Something like this: Portal ------- A 5 B 1 C 12 E 3 ------- This portal will serve as an index, for a CD backup of client material. Is this possible? I have a feeling I have seen something similar before, but can not remember how/where?? Regards!

Is there a way to delete the SCEOND LAST portal row?

Hey, I'm just wondering why when I use a go to related record button, in a portal, it returns a the related record but within all available records. Is there a way to isolate the related record to be itself in the found set? I want the user to only be able to see the record that is selected from the portal, not to be able to flip through all records. Thanks...

Hi all, Is there a way to display the first 10 portal rows, and then by clicking an up or down button change the group of portal rows displayed. For example, you have the first ten dispalyed, then cick a down button to show the next ten. I am trying to eliminate the visual clutter arising out of the need for multiple scroll bars on a layout with multiple portals. Thank you, Don