Portals

Hi! I have a Problem.. I have a portal with 20 rows, in each row one check box... When I click on some check box, active the check box that has focus.. and.. when open file all check boxes are actives.. Could some one help me?? Excuse my English... :-)

first...thanks to liveoak back a few posts ago. i worked your sorting technique into my solution and it works wonderfully, and it added some neat flexibility into it i never even thought about before! ok, on with the new question i have a parent file with my data in it, and a "queue" file that has the portal pulling live jobs out of the parent file. the queue file will exsist running on several different computers, each computer with its own copy. occasionally, i need each copy of the queues to run an "update" script based on some changing values in the parent file. i created a button labeled "refresh" and stuck it in a little one row portal which i make appear or dis…

I am a novice so please bear with me. We have a file called "Contacts" and a file called "Quote Log". In the "Contacts" file is a field called, "Quote No.". This field "Quote No." has entries such as 9900, 8901, 7500. I have created a relation in the "Quote Log" file to the "Contacts" file and used the quote no field as a link. I am trying to pull the information from the source field in contacts to the file "Quote log". When the information in the quote no field in the contact file is denoted as mentioned above, re: multiple quote numbers, the info does not feed to the relational field,source, in the quote log file. However, if there is only one quote no. in the f…

I have two data tables that are each storing relation information into a third table. The two data tables have ID and also an additional field with information of the type of data the table is storing. Well, via a portal, the user gets to store some other data and what I want to do, is store in the relation table, the ID, and this other table identification field along with the other information that the relation table is designed to store. The problem is that I am only able to store one of the two fields and not both. I need both because the combination of the two fields is the unique key. I created a relation in the data table to the relation table for the ID, and it s…

Is their an easy way to insert a new record in a portal inbetween existing records? I have a layout with a portal that shows 22 rows and the users want to be able to insert a blank row in the middle of existing records in the portal. The portal is currently unsorted, so the records show in creation order. What I want to do is like the insert row command in a Microsoft Excel WorkBook. Any ideas?

I have a jobs database with a portal of a line items database. Each line will have a code ID, description, price and quantity field, that's not problem. What I would also like to have is a bill of materials for each line item that I can put toegther when creating each line item. It seems like this may be able to be done by using a portal of materials inside the line items portal, but it doesn't seem to work. Is this the right approach? Can a portal be placed inside another portal? Thanks for the help! Dave

2 db's, Contacts.fp5 and Interests.fp5 - related 1-M by Contact ID. I want find all contacts that have both sailing AND skiing as there interests. If i do multiple find requests from either db, I get sailing OR skiing. Is there a way I can use boolean in a portal field in a find request? Cheers Hal.

I am a relatively novice user, have never posted a question but have a question whcih I could not find an answer to using the search I have a portal that matches last names from a source database when I type in a last name in new database. I have created a button that executes a script that inputs the relevant information from the source into various fields in the new database. My question is how can I easily update the source database when some of these fields are modified (e.g. the address, email or phone number changes)? One way is to have a button in my portal that deletes the record in the source database. The advantage of this is that when I am done entering all m…

I have a solution with a "grid" made up of 6 portals (one each for grades K through 5) Each row holds the score for a particular test. This works great. (The grid is in a Reports file; the portals show data from a Tests file.) The next request from my end user...she wants to have it calculate the difference between scores of the same test from year to year. For example, rather than do the math in her head, she wants the solution to display the difference between Test A in 2nd grade with Test A in 1st grade. Thanks for any help. Susan

I have a question regarding adding a new portal record. There are 2 possible solutions, neither of which I can figure out. I have a portal in a customer database that is showing records from a contacts database. I want to be able to create new contacts from the customer database. So far this is the easy part. I have a couple of issues that I'm trying to overcome. The first field in my portal is a calculation field from the contacts database that is merging the first and last names to show the full name. In the portal, you can't create a new record by clicking in this field, because it isn't an editable field. I can create a new record by going to the next field, but th…

BACKGROUND

Apologies if this seems a very simple problem, but I'm with a small charity (see my homepage if you like), we have 2 staff and I have nobody else to ask. I'm using Filemaker Pro 5.5 and have one file with "donors" (customers) and a related file - viewed through a portal - of "donations" (transactions). I've created a layout in the donor file with a thank-you letter, so I can click a button to print it when we receive a donation. I have included a merge field with amount, from the donations database. But how can I make it read the amount of the LATEST donation, not the first - which is what I get each time I try it? Also, I don't seem able to do numeric formatting (…

I am using FM version 4.1. In my database applic. I use a field as container and I import 1 to 3 images (pictures) in a repetition field. I has reached a file size of 2 gygabites and more than 6000 records. There are no way to increasing this size? Which are the limits on the size of a file? The FM returns a topic sayng "this file has reached the maximum size for a file or the hard disc is full..." But the HD has 10 gygabites and there are 5 gygab. free. Any body can help me? thans a lot of. Manuel G. Valdecasas

How do I determine the portal row number when a users clicks on one. So I can store it for later use in my scripts.

This is the message I often get in the network application: "This record is currently being modified by "name". The record isn't being modified by another user and according to what I found in the forum it has something to do with portals. What is exactly happening? How do you solve this problem? The answer (=1) I found in the forum isn't quiet clear to me. Thankyou for reading and eventually answering my question.

The problem continue...when I click some check box not respose corretly. the check box is defined in a current file is not member of relationships. Could you help me?? Thankyou very much.

I have a sales lineage file which creates records from an INVOICES database containing info such as INVOICE NUMBER, SALESPERSONS NAME, INVOICE DATE, QTY, PRODUCT CODE, DESCRIPTION, PRICE, QTY*PRICE, WEEK NUMBER, YEAR and caculation fields that create searchs such as Salespersons week calculation is: salespersons name & "-" & "week number" & "-" & year number which gives me a field that might say for example matthew lightbourn-42-2001 In my staff database I select the staff person's name and type in the date to search for and in this database there is an equal calculation as the one above which gives me a matching answer to base a relationship on so …

Hi, How can I make a portal have multiple columns instead of rows? Well, here's the scenario- There's one main databse with the informationof companies, identified by 'Identifier' fields. Then, there are 4 small databases one each for the different operations(ex., restaurants, golf courses, etc) run by each company, which also have 'Identifier of Operating Company' fields. I am trying to import the contact data for the operations into the main database. I would like the data to appear as: Operation 1 Operation 2 Operation 3 Address 1 Address 1 Address 1 Address 2 Add…

I think I understand most of what Filemaker offers (on a basic level) apart from PORTALS. Can anyone point me in the direction of a tutorial or other relevant source of information that would teach me how to use them and in what circumstances. Thanks

BACKGROUND I have a variety of records with notes on them. Each new record for Bob, Cindy or Tom can be for a previous project or a new project. I currently have them as a portal with scroll bars for when the information is to long and it works fine for viewing on screen. But I would like to print out the list of combined notes for a project on one sheet.

I need to put a portal in the header portion of a lay-out (viewed as list). It works well, but although it has a scroll bar, you can't make it scroll. I also wanted to put a button to each line in the portal, but that also doesn't work.. Any suggestions? Thanks.

Dahh...Thanks a bunch, Old

I have another filemaker database that I want to be seen in another database to view without always having to go to that database to reference. So my question is: Does anyone know of a way , on a PC, that you can just capture a whole file and stick it in a portal without having to reference every field in different portals?: Thank you very much!

First time here, looks like a better resource than the last forum I was a part of, especially since it's down right now. Hope you guys can help me out on this one. We have a series of databases all linking from one to another passing information every which way, and a master database that sums up the information in a very nice and neat way. The Master has 2 portals gathering information from two different databases. Now here's the problem. We want this stuff to be accessable to 350 people living in towns across the entire western side of our state. So many of the databases have websites set up to allow users to look at their files, sign up for workshops, that kind of…

Hi, Could anyone point me into a direction on the following matter: I have a customer database with a record per company. On each of these records I have a portal with a list of attention names for each company. The portal is pointing to a second database with a record per attention name. My question is: I want to make a letter so some of these companies and only some of the attention names are getting it. E.g. on one record, one company, but only two out of five attention names. How do I make a mail merge of selected data from my company db and my attention db. Do I need a third db for the mail/letter and how do I perform the actual merge, or...? I guess this is a n…

Hey kids. I'm having the same problem that Wald had in the "drifting portal rows" thread. My problem is that I need to print information from two portals in one report: I have a file called Docket. The Financial Summary report in Docket has one portal that lists all of the invoices and their amounts for a project, from the file Invoice. It also has a second portal that lists all of the purchase orders and their amounts for that project, from the file PO. I only need it to show the first six invoices and the first six PO's I know that there has to be a way to show this information through calculations, relationships and serial numbers, but I can't seem to wrap my brain …

I have a database of sporting events, with fields Sport and EventDate. I have a calendar made of 37 portals (matching CalendarDate1 to EventDate, CalendarDate2 to EventDate...CalendarDate37 to EventDate) displaying all events for each calendar date. I would like to be able to let the user toggle "basketball," "football," "all," etc. so that the calendar displays only the matching events. If I have a global field, gSportToggle, by which the user picks which sport to display, and each record has a calculation IndividualSportDate=Case(Sport=gSportToggle or gSportToggle="All", EventDate, "") then I could match calendar dates to IndividualSportDate. However, IndividualSpor…

hi...new to the group i have a problem that has been puzzling me for awhile... i'm writing a new solution which has a portal being used as a queue. i want to sort the portal by different fields by clicking on a header above the listed items very similar to a finder window or windows window. i define this sort order of course in the "define relationship" dialog, but that means i have to change the actual relationship to sort differently, which of course means making lots of layouts with the new portal, lots of duplicating and rewriting scripts. i'm allergic to all of that duplication and changing! also, i want different users sharing the same related file to all hav…

I have successfully laid out a statement using a portal to list all of the client's outstanding invoices. The portal row contains: Invoice date, Invoice Number, Job description and Invoice amount. My problem is the following: How do I break out the amounts in the portal and total them into separate areas (on the statement)for 30 Days 60 Days 90 Days 120+Days Obviously given the fact that I have successfully bloodied myself I now realize this formula(?) Is beyond my reach. I am hoping I can receive some help. Thanks.

hi...new to the group i have a problem that has been puzzling me for awhile... i'm writing a new solution which has a portal being used as a queue. i want to sort the portal by different fields by clicking on a header above the listed items very similar to a finder window or windows window. i define this sort order of course in the "define relationship" dialog, but that means i have to change the actual relationship to sort differently, which of course means making lots of layouts with the new portal, lots of duplicating and rewriting scripts. i'm allergic to all of that duplication and changing! also, i want different users sharing the same related file to all hav…

Hey Guys, I'm a newbie at this FM stuff, so bear with me. I have a feeling that the way to go about this is to create a portal, but am not too sure. I have one database which is dedicated to certain assets. It contains two fields called Asset_Number, Asset_Name that I am concerned with. What I want to do is display a list of both Asset_Number, Asset_Name in a portal on the main page, and I do not want to use a list layout because I am going to want to display more data from a different database at a later point. My end result of this portal will be larger than simply just Asset_Name and Asset_Number, but I want to start with fields from the same file before moving o…

I have a portal. The portal has many rows. Everything works fine until I try to print or preview. When I print or preview, certain portal rows drift down so that I can only see half of the text in the portal row, or none of it at all (it drifts below the visible box). I checked that the field is not sitting outside of the portal row area. Has anyone seen this? HELP -wald

I'm not sure if this falls under portals or relationships, so I'll see what you folks have to say. Here's my situation ... The relevant files in my database are structured as follows: --2 files, "companies" and "products", in a M2M relationship --1 join file for the M2M, "line_items" --"products" file is a hierarchical listing (hierarchy done through self-joins) What I want is a nice way of entering, and showing already-entered, data into the "line_items" file FROM the "companies" file. The entry choices (in the form of a hierarchical list) are individual records in the "products" file. My preliminary idea was as follows: --The entry is performed using a por…

I want to do a self join portal in a file that uses a matching field that is related from another file. I tried to make a calculation field using the relationship to generate a field, the result on which to base the self join match, but FM warns me that that wont work because the result cannot be indexed, because it comes from a relationship. How can I do this?

I have two databases. One is an invoice database and the other is a "production" database. They are related by a common job number. I would like to have the "invoice number" from the invoice database automatically appear in the "invoice number" field in my production database. It seems that a portal would be the most appropriate way to do this but I can't make it work (I have never made a portal before). I would appreciate feedback on if this is the appropriate way to do this and would "really" love a step-by-step. As I mentioned, a relationship has already been established. Thanks.

I have been operating a FMP 4 database for several years (updating from earlier, flat-file versions, etc.) to run a translating business. But I don't know much about designing databases. My system keeps good track of Jobs (when they come in, go out, how much to charge, which translator/s did the work, how much each bills me, etc.) as well as, through relationships, using and accessing client details, translator info, etc. Each job also displays the corresponding invoice number once it has been invoiced. The Invoices file keeps good track of invoices and works wonders generating reports of one sort or another, but this is where the problem lies. Th…

I just did my first version upgrade and imported my records. After viewing my portal, the displayed record order did not match my sort order. Sort order in defined portal relationship was correct, but not carried out. What happened? Any suggestions on avoiding this on update/import? [ November 05, 2001: Message edited by: kens ]

I have a number of records appearing in a portal. I need to have the computer tell me how many records are in that portal. How can I do that? Thank you!

Here's my situation: I have 2 files, Main.fp5 and contacts.fp5. Main.fp5 is a "jump-point" file to all other files. In the contacts layout in Main.fp5 I would like to create a portal that displays all contacts for our company. Clicking on on a contact would open the contacts.fp5 file. I cannot figure out what kind of relationship to setup here. Obviously I need some sort of key field that is part of every new contact file so that the contact will display in the portal. I set up a key field in both files called it "cutomer_origin". I set the relationship to match these fileds and was able to see all contacts in the Main.fp5 portal. However, I could not select of …

I have a solution tracking student test scores. There is a Tests file which contains a record for every test a student takes and a Reports file which displays whatever info through portals. I have a grid created comprised of 6 portals (K, 1st, 2nd, 3rd...) keyed on a student id. When a student has taken every test in a given year it works great. As expected when a student does not have a record for say the 3rd test in the list, all the data below that test move up one row in the portal, which doesn't display the grid accurately. I have two solutions which I know would work... Solution 1: Create a record for every test for every student, even if that student will never t…

I' Like to show records in a portal that match a relationship, but only if they also are marked as active in a field called STATUS in the related file. Is there any way to do this?

I have a portal that displays doctor's names and address that I choose from a value list. The portal is in the Client File. The doctor's names and addresses are in the Medical Provider File. The portal and the value list get the information from the Line Items File. This all works great. My problem is that I need to have a field outside of the portal where I can choose one of the doctors as the Treating Doctor and that field will contain the doctors name and address spaced apart appropriately so that I can use that field for a government form on another layout. I also need another field outside the portal which will display the doctor's name and address in a form fo…

Do a Find for the specific Inventory Code, then your summaries will be based on those records with that Inventory Code. ~Dennis

I just don't get it, sorry... Two databases -- Main and Affiliates I want to create a portal in the Affiliates DB so that I can type in a "Domain Name" and have it fill in the "Account Status" field and the "Start Date" field from the Main DB. Then, down the road I will create a calculation field in the portal that will figure a commission for the Affiliate (based on the Account Status and the Start Date). Is this reasonable?

I'm fairly new to working with portals...this may be one of those "duh!" questions... My solution keeps track of standards scores for K-6 students across their elem school career. I have a Students file and a Standards file. Both are related to the Reports file. I have my relationships set and my portals created, and everything works great when I import data from the spreadsheet where it is currently stored. However, in the future I want to be able to enter the data directly into the Solution. I have the relationships set to allow creation of new records. I want to be able to enter a Teacher-Standard-SchoolYear and get a list of that teacher's students with blank or no …

Hi everyone, I was wondering if someone may be able to help me with a small problem. I have a three line self-relational portal and have dropped a button in the portal to open a pdf file relevant to the portal record on that line. The button works perfectly. However despite only putting in one button on the top line of the portal, with the expectation that the button will only be duplicated in the line below when there are more than one related records, Filemaker is by default revealing a button on the portal row below, even thought there is no document in that line. Any ideas? Your help is appreciated. Thanks

I am trying to get data out of a portal. I have 5 fields in a portal I want to copy to the clipboard from a script the information lets say from field1 in portal row 1 but I can't seem to see how to do that. Am I just missing it or are portals just for viewing the data? Thanx, Thomas Lepkowski

I made a solution based in FM Pro 3.0... My problem is the next: I have a database named "Credits".. in this file I save differents kinds of credits named "Credit1302", "Credit1304", etc. To differentiate the type of stored credit i have a numeric field name "$Credit" and other text field name "KindOfCredit" and a calculate field name "TotalCredit". The formula in this field are "Case( KindOfCredit="Credit1302" , $Credit)" Here all it

Okay, so I'm just learning this FileMaker 5.5 stuff and portals are confusing me. Here's what I have. I'm setting up a database for our school that will allow us to bring together bits and pieces of information that are spread far and wide now. So, I have set up a series of files: (for example: 1. Demographic Data 2. Counselling Notes 3. Administration Notes 4. Classroom Teacher Notes 5. Resource Teacher Notes, etc. All are related by student number. Now not every student will have input from all these areas. However, there are some commonalities. Therefore, I want to be able to create a Report file that will bring together data from the separate files in the …

How do you display a portal based on a relationship (Quote Number > Quote Number), but only display the quotes based upon another field which says "To Order"? More Info: I have a quote database that generates a quote number. The list of items for that quote are written to a Bridge file and carries the qutoe number for each item. There's a status field that is set to "Quote" at this stage. If I go back to the quote and wish to order a selection of the quote only, then I change the status of each of the items I wish to order to become status "To Order". Then I go into my Orders database and it generates a serial number (Order Number) and asks me for the original quo…

I'm not sure if FileMaker has the capability for this, but this is what I'm trying to do. I have a main database with one layout which includes a text field (Equipment) and 2 portals (one directly on top of the other.) I use one portal with a relationship between the main database (using the Equipment field) and a second database (Generators). I then set the second portal to use a relationship again using the Equipment field to a third database (Golf Carts). So for the first record I match "Generators" for the Equipment field and the correct information is displayed in the portal (14 records are displayed.) However, for the second record I match "Golf Carts" for the …

Hi there, I'll give you a brief overview, I've just finished a database, and one aspect holds date ordered notes in a portal (note,date,user,id_no are the fields in the related file) The relationship is specified to sort the date desending. Okay. It works, when I enter a new note it gets shuffled depending on the date perfectly. But, and heres the kicker, I imported about.. 10,000 entries into the portal for the clients, for some reason the portal doesnt sort these entries, only new ones. Can you think why? The date is exactly the same format. So basically if i were viewing the portal for X client I might get: code: Gone Fishing Dean …

Have a file with daily entries of odometer readings for over a hundred delivery trucks. When the client makes a new record in that file, and enters the truck number, would like to have the last odometer reading for that truck number be automatically inserted in the new record. Can

I have a sales database with two seperate portals. One searches for a product code from stock control giving me stock available, price, description, etc. The other writes to a sales lineage database. I select the product in the first portal and enter required quantity. Then I click on a button "Add to Order" and it adds my quantity to the 'allocated' field in the stock control database and then copies the product code and quantity to the second portal and writes with it the invoice number, salesperson, client ID from invoicing database. PROBLEM: I can enter the first product perfectly. In the script I ask it to go to next portal row when entering the next copy and …

Hi, I have three databases (more to follow), which include 1. Sales (invoices) database 2. Sales Lineage database - record per product sold linked to inv. no. 3. Stock Control - created product code, desc., price, commission, supplier name, re-order level, stock room level, allocated(sold), stock available(stock room level - allocated). The allocated can only be reduced once the product has left the stock room ie: delivered. The sales(invoices) database generates an invoice number, allows you to fill in the client info (or lookup from client database) and then enters you into the portal window where you are asked for a product code. This is written as a new r…

I hope this is a better explaination There is 7 databases CLIENTS DATABASE - This database stores Client ID, Name, Address, etc. SUPPLIERS DATABASE - This database stores information on Suppliers like Supplier Name, Contact Name, Address, Telephone, Fax, Account No,E-mail & Web site and looks up from Stock database what products are purchased from this supplier. STOCK CONTROL DATABASE - This is a line entry database which includes Prod Code, Stock Avail, Re-order level, Stock Room qty, Allocated, Supplier (From the Suppliers Database), Retail Price, Cost Price, Description, Catagory of goods. It includes a flag to let you know if Stock Avail < Re-ord…

I'm working with an Employee Database that pulls Job Updates from a Job Entry file into a portal, and sorts by Effective Date with the most recent entry on top. This information is in a portal on a layout that will be used for viewing only, so I unchecked the "Allow creation of related records" to eliminate the blank row at the bottom of the portal. It works great! However... I've now created the layout for updating the employee's record and want to add the information into the portal on this layout, rather than having to switch to the Job Entry File. I duplicated the portal relationship and checked the box to "Allow creation of related records," but when I view this new…

First what I would like to achieve: - The body of a layout with a set background color. - A Portal with rows having alternate background colors My problem: In order to show the portal rows with alternate background color rows I set the fields in the portal row to transparent; however when someone edits the record (or uses find-mode) suddenly the fields show up in the color of the layout body. I tried putting an (invisible) white area behind the portal but this doesn't work. Only when I put a large colored area behind the complete layout with the body set to transparent the fields in the portal seem to use the color defined for the portal. This solution however is…

Its quite complicated, so bare with me while I try to explain... I'm working with three files; Jobs, Tests & Invoices. You make a job and give it a report title, and in the process of making that job you make tests to be carried out in that job. You finalise that job, then you invoice it. A job cannot be invoiced until it has been finalised. Once it has been invoiced (which is just a series of flags being attached to various fields), it is able to be printed. The Invoice file displays a list of all jobs that have been invoiced. Here's where we start to get a bit tricky... Once a job has been finalised or invoiced it can be unfinalised so that more tests ca…

I want to display Job Numbers with their Test price totals in a portal on an Invoice file. An Invoice can have many Job Numbers and a Job Number can have many Tests. So far I can get it to show the Job Numbers (duplicated as many times as there are Tests for that Job Number) and the Price for each test listed beside it. How do I make it list the Job Number only once, and the total for all the Tests in that Job beside it?

This is often a sign that you have set up an auto-enter or lookup in the related file, based on information that can’t be available until after the record has been created, or a bad reverse relationship will generate the same message. You need to go through both files, check what you have changed recently! Did the relationship work before? Rigsby

I have 2 databases. One db contains a portal to records in the other database. Is there any way I can add records straight in the portal instead of having to go to the other db to create records? In other words I need a portal that allows you to add records as well besides just displaying and updating records from the other db. Would I have to write scripts? Your help and suggestions are much appreciated.

I suspect this is pretty basic stuff... I have an "Orders" file with a layout containing a portal called "items_of_one_order". The portal works through a relationship of a similar name to a file called "Items." The "Items" file manages individual products from manufacture until they arrive in the customers hands (and beyond as a reference archive). Items are grouped and managed from the "Orders" file. Through the orders layout, the user can add and remove items from the "Items" file. Here's my problem: quantity of identical items. I want to allow the user to have a quantity field in the "Orders" file. But that quantity must correspond to 10 separate entries i…

I would like to create report in one file that includes a portal list from another file. My problem is that it will only display a user defined number of rows. I need the list to display anywhere from 10 - 200 items but don't want to set the number to 200 because it would make printing unwieldy. Is this possible?

How can i do to search some records that have portal rows with empty values?:

I'm trying to create a grid-type layout with Grade (K, 1, 2, 3, 4, 5) across the top and 16 different tests students take down the side. I want to be able to enter a Student_ID and display that student's test results throughout the grid. Each student has a unique ID, and each grade also. I have a calc. field which combines the two and 6 relationships based on these fields. I have 6 portals based on the relationships, all sitting side-by-side, displaying the test score. When I enter Student-Grade1 I get the scores for 1st grade, Student-Grade2 gives me 2nd grade, etc. What I need, however, is to be able to enter 1 Key and get all the scores in the 6 portals at the same ti…

Here we go: I need to make a list of the data in my portal. for example: portal row 1: "a" portal row 1: "b" portal row 1: "c" needs to return: a b c in my calculation field How do I calculate this? Thankyou so much for helping me out!!! ------------ Thankyou for reading this message but I found my answer all by myself (like a big girl) The 'copy all script step' returns the values with a carriage so I can paste them in one text field...as simple a that, hopefully my question/answer will be usefull to some of you. [ August 24, 2001: Message edited by: michele ]

Hello Everyone Here is the problem, I have two portal's no. 1. display's a list of the customers contracts no. 2. display's the notes / update to each contract. What I would like to do and havn't been able to so far is . To display the contracts in portal 1 as is , however. Only when a particular contract is highlighted within portal 1, I want to have FM sort which 'notes and updated" belong to that contract and only display them then. Right now all the notes and updates display in Portal 2 and it's not as clear as it can be. I seem to be getting lost within the technical jargon of my FM reference books, and conditional portal's etc. I figure there needs to be som…

I know that you specify sort order in the relationship setup of the database but I have a specific problem, that may mean that I do not or can not use a portal. I have created a media database of several video files, with thumbnails in the records for visual identification. I have now created another database to create playlists of the media files. I need to be able to display certain media files through a portal (which I have completed using a repeating playlist ID field in the media database). BUT I need to be able to re-order the displayed order of the media files in the database. Anyone got any bright ideas? Joel

I'm not sure if this is the right place to ask this question... I'm working on a solution which tracks a student's score on 16 different possible tests taken in elementary school (K-5). I have the following files: Students.fp5 (contains student name, student_id, grad year, race, gender, etc.); Tests.fp5 (contains student_id, test name, test score, schoolyear and various calculated combinations, such as studenttest, testschoolyear, studentschoolyear, etc.) My last file is Reports.fp5 which contains student_id and relationships to Students and Tests. Using portals I can get most of the information I want. However, I would like to create a grid-type layout which has the t…

Hi people. I was wondering if you could help me out with this idea I have been working on and how to implement it on Filemaker 5. I have a Product database where you can assign three 'Keywords' to describe what the Product is. I have three fields in my Product database; one for each keyword. These will be called Keyword1, Keyword2 & Keyword3. What I've done so far is to create a new layout. On this layout I am planning to place a PORTAL (yep, you've guessed it) that will show certain products that have specific keywords. In my Product Database I have two calculation fields. The first is: - Keyword1 & " " & Keyword2 & " " & Keyword3 The other calc…

Hello I published this question a couple of weeks ago in the Import & Export-forum. But I got no respons, and take it nobody knew what to do. So I take a chance with you portal-guys instead. I am really eager to know if it is possible to solve my problem. I have no experience what so ever with portals. Here is my question: I maintain a list of journals, which are managed by FMPro41 and Web Companion. A part of the list is created by importing an Excel-file provided by a database host. This list contains a lot of journals. For certain reasons I would like to be able to: a) import match, and replace information in a record that in a certain field is identical whereas…

I have Elements listed in a portal on a layout in my Projects file. I want to force the users to use a button I have created called "Create New Element". It is attached to an extremely important script. The users are in the habit with this and other databases of simply going to the last row in a portal and typing to create the related records. Is there any way to hide this row, or lock it, or attach an error message or... something? I even put a large red note on the layout. Oh, and earlier tried a message that appears directly before entering the layout instructing them to do so. They read it and heeded it once and then fell back to old habits. It just doesn't matter how…

Hi people... Here's the scope. I have this little script that goes loops through the portal rows adding up a field to make a total for another field outside the portal. The thing is though that when the loop goes down to the X amount of rows viewable on portal. (as in, the viewable amount of rows in a portal), the script bombs into a uncontrollable loop. Anyone know what's the cause about this? Any tips? Is it me? (probably). Steve Griff

Hi, again: In my DB a user needs to copy information to a portal without having see the portal, it is possible to do this with a Script... He needs to copy of three fields towards the portal which contains six fields, the first three fields used, by which I need that he copies in the field 4, 5 and 6.. It is important that they are copied in the empty fields, for example, in my portal(See above) I have 2 records of which 1 do not have descripcion in fields 4, 5 and 6 he begins for the record 2 field 4... PORTAL FIELD1 FIELD2 FIELD3 FIELD4 FIELD5 FIELD6 VALID VALID VALID VALID VALID VALID VALID VALID VALID EMPTY EM…

I'm building a DB to manage distribution of my clients product into a network of retail agents. To do this I've created two files. File one contains my six clients. File two contains the details for the retail network of 5,000 agents. I've created a relationship between the two by adding a "key" field on both files which auto adds the letter "A" to the field for all clients and agents. This allows me to create a portal on each agent (file two) record which displays a list of the clients from file one. While all the retail agents are used by all clients they categorise them independantly (A, B, C, etc.) based on sales performance. My problem is this. Is there a way to…

I'm building a DB to manage distribution of my clients product into a network of retail agents. To do this I've created two files. File one contains my six clients. File two contains the details for the retail network of 5,000 agents. I've created a relationship between the two by adding a "key" field on both files which auto adds the letter "A" to the field for all clients and agents. This allows me to create a portal on each agent (file two) record which displays a list of the clients from file one. While all the retail agents are used by all clients they categorise them independantly (A, B, C, etc.) based on sales performance. My problem is this. Is there a way to…

OK I have my portals working, but my other half perfers to look at data in the table view. (he's an Excel type of person) How can I get the information that shows up in my portals to show up on the table? Thanks!

Hi, I wonder how I should do to sort what

Hi there, I've finially figured out that I need a portal to do what I need to do, which is the following: I want to create a notes section for each client in the database, the notes bit would have 3 columns, one would record the user who entered the note, the other the current date of the note, and the final one would have the note itself. Every client would have >1 note. so if you were browsing it (on a client with.. 3 notes it would look something like the following): code: Name Note Date Fred client ran away 30/07/01 Susan contract signed 23/07/01 Bob delivered contract 19/07…

I've been running Filemaker over ADSL with server and client at different sites, and whilst it works OK I do get 'Synchronous lock error 10001' messages appearing on the server periodically. Does anyone know what this means or how to avoid it? Many thanks Rufus

I have been a longtime, but only an occasional, user of FileMaker who has been asked to look into the development of two applications. As a result I have been immersed in the design and prototyping process for the last three weeks. I am stumped at finding a particular interface solution that I hope someone can help me with. What I want to do is to create on a layout in a child file a list of a select set of fields of ALL parent records. Then I would like to highlight or click on a parent and transfer the parents primary key to the child's secondary key field. It would appear that situation must have been discussed before, but I can't find a discussion on it anywh…

Howdy all - I'm in what I hope is the final stage of a database for a small foundation. The database keeps track of donors and donations/purchases (they also have some merchandise). So now I have the task of setting up the invoices part of the database. Currently the donations entry process is scripted to an "Entry" db that only allows these users to see so much and helps to avoid duplicate entries by first finding existing donors, etc. I'd like to keep the rest of the process (entering the donations, etc.) within the same "Entry" database if possible, with the actual databases just being related to it. This for security reasons (no need to let data entry people browse …

Hi people I have this invoice type layout where I have a portal in it. The portal has more records in it than it can handle so it uses the scrollbar. The question is - I want to print out the invoice layout. Is their a way to tell the portal to expand so it displays all related records while pushing eveything underneath it down? Please help. Thanxs again (and again and again...) Steve Griff

Hi people Question: I have a layout with two portals. I have two buttons on my layout (not in the portal) that are previous/next buttons. These buttons will "scroll" through the portal. But if there are two portals in my layout, how do I tell the buttons which portal should it scroll? Thanxs Steve Griff

Two databases. TASKS & DATES. Tasks uses a portal showing multiple days that the selected task is occuring on. Dates uses a portal showing multiple tasks that occur on that date. A Many to Many, right? Or is there a way to do this without a joining table? The problem is this. I need to create all the tasks in tasks. Then I need to create all the dates in dates. Then in Tasks, I must be able to have a popup in the dates portal to assign any number of dates to the task. Likewise in dates, I need a popup in the tasks portal that allows me to assign multiple tasks to that current date record. Here's what happens... In tasks, I select a date and it simply creates…

I have two protals Portal 1 and portal 2 linked to a file. In portal 1 I have the values a, b, c, d and in portal 2 I have the values 1, 2, 3, 4 I need to combine these portals in another file so that I will have a 1, b 1, c 1, d 1, a 2, b 2, c 2, d 2,..... I cannot hink of a way to both sources of data for this. In the main display I have a job number which allows me to link the 2 files. Can anyone help my brain is now fried with attempts. Simon

I am having difficulty entering information into a portal. Does anyone have a portal example they could send to me, so that I can look at the layout. Thanks!

When I enter information a record ID, I want the related information to appear. It appears twice, instead of one record. Help!

In a nutshell I'm trying to create two portals in my solution, past tasks and future tasks. I have two DBs; Tasks and Customers which works fine but I'm having problems with the multikey filtering... I downloaded SmartRanges from www.fmfiles.com and it's a great technique file but I just can't get it to work in my solution. I have set up identical fields in my solution but when I try to copy any of the calculations it displays a dialog "this number cannot be evaluated and highlights "," (just after the 9 in the first row) in the calculation which looks like this (Range calculation field): Substitute(Middle(" 0 1 2 3 4 5 6 7 8 9", (Int(Mod(Start, 10^1)/10^0) + 1) * 2 …

i have created a portal of customer_contacts for a customer. the customer_contacts row displays name, phone and email. i want to be able to click on the portal row and open the customer_contact form for the contact that has been clicked on. any suggestions would be greatly appreciated.

Question peeps. I have a portal with 1 row. I basically want the ability to have two buttons, next and previous where you could go through each record one by one. I guess I am trying to navigate a Record in Form Mode using portals in a Record. I hope you guys understand what I'm trying to say. Thanxs Steve Griff

Question peeps. I have a portal with 1 row. I basically want the ability to have two buttons, next and previous where you could go through each record one by one. I guess I am trying to navigate a Record in Form Mode using portals in a Record. I hope you guys understand what I'm trying to say. Thanxs Steve Griff

OK OK im a newbie but Ive never seen anything inside FM that says something about portals. Could someone tell me what they are or giveme a web page where I can download an example or see how to make them Thanx

I'm creating an invoicing DB and have our and clients basic info in the title header and the actual bank transfer template in the title footer. The body only has a portal to "line items". I've set the portal to slide/reduce which works okay. The portal is 50 rows so that all the possible products fit to the invoice. I've set it up so that if all the portal rows don't fit in the body it continues on another page (in preview mode) this works fine if I only have one record in the whole DB. If I have more records those portals also print in the preview mode, why? I can prevent this ******* thing by omitting the current record and viewing omitted (although FM still prints the …

I have an interfacing challenge. I would like to produce a layout (or series of layouts) that give the ability to expand several portals to fit their contents. e.g. Where a list of orders for a particular job contains four orders, when you click on the header (button) the header expands to show the four orders. In other words I need to be able to take the number of records for the portal and use it to adjust the size of the portal. Anyone out there with any ideas?

If you see the first field repeated in a portal it is a sign that there is a mismatch between the portal relationship and the field relationship. Since you copied the portal from a previous layout, check the field definitions to make sure they use the same relationship as the portal. One other thing: sort order of portals is set in the relationship definition options. You can't have two portals with the same relatinship sort two ways. I suggest you duplicate your original relationship, set its sort according to your second user, and use that relationship for your second user's layout, portal and fields.

In my clients database i have a portal to a Notes database. When I open the Contacts database on my Mac, I see in the Window menu the Notes database in parentheses as hidden. This is fine, but in a Windows environment, the database shows up, although minimized. Is this normal behavior? I prefer my user not see this Notes database, or have access to it at all except through the portal.

I have a customers DB and a tasks DB which are related (each customer has a unique ID). I've created layouts for past tasks and future tasks. I have portals to "tasks DB" in both layouts and I want to filter the portal to show "*today" tasks in the other layout and "<today" in the other. Can I use "*" or "<" operators to filter portals? What do I need to filter my portal as described above?

I have a list of projects which are displayed via a portal. The portal displays only the entries speficied by a Global field which contains the project managers name. Once a project is completed I require to hide the entry from the portal. Otherwise my users have to go through an ever growing list. I have setup a script which changes the field "assignedto" which is the user name to become "Completed" thus making it disappear from the protal. However when I script this step It seems as if the script will only work if the record I wish to change is the top most record in the portal. Assitance requried please.