Portals

Hello, Is there a way of referring to specific portal lines in a portal, to use in scripts (other than first, next, etc)?

I am new to "relationalizing" long used Filemaker files v5.5. I have 2 questions. First is baffling me but probably a simple oversight I have "Ship Tickets" and "Ship Tickets line item" files related by "TicketNumber". The portals in "Ship Tickets" display correctly but when i attempt to total "Shipped Quantity" using "QuantityShippedTotal"=Sum(BZ_ShipTicketLine Item|TicketNumber|BZ_shipTicket::QuantityShipped) in "Ship Ticket" file it only totals the first portal row. I have what i thought was the identical type of set up- fields, relationships, formatting etc in a "Contract" and "Contract line items" files and the totaling works perfectly I've tr…

I have a database called Job Tickets and related database called Clients. I want to see if there is a way I can view the files in Clients as a seperate layout in Job Tickets instead of having to open the Client database to add/edit new clients. Kind of like the way ACCESS handle sub-reports in a main database. it allow you to create a main database, and add/edit sub tables inside the main database without having to open the sub table.

Does the concept of sub-summaries exist for portals? I have an invoicing solution that has files called INVOICE and LINE_ITEM. I have a portal on my Invoice Layout that shows line items like this: Category 1 1000.00 Category 1 2000.00 Category 2 1500.00 Category 2 3700.00 I want the Line_Item portal on my Invoice form to *subcategorize* the info (like I could by using subsummaries in the LINE_ITEM file to print a report that shows: Category 1 1000.00 2000.00 ======= 3000.00 Category 2 1500.00 3700.00 ======= 5200.00 Can this be done in FileMaker 5.5?:??

I just spent hours perfecting a subtle design for some "tab" buttons, and got them just right. However, now when I click on the button in browse mode, it highlights the entire button as black for an instant while I click it. Is there any way to control what color this highlighting is (or in fact to get rid of it?)

Is it not possible to have summary fields doing their thing for records in a portal, even when the portal is using a self-join relationship?

Can anyone explain to me how to do indented portals?

I have searched the Portal Forums, and can't find an answer I can make sense of. If there is an answer to this question...please point the way. My question: I have 3 Files: Assignments/Questions/Criteria. These are Parent/Child/Grandchild respectively. In a Parent Record layout I want to have 2 portals: Questions (related by Assign_ID) and Criteria (which is related to Question file by Question_ID). The behaviour I want is click on a row in the Questions portal and see all related Criteria in the other portal. I gather from other posts that I need to create a Global field in the Assignments field which would be the left side of a relationship with some kind of calc f…

Do I gather that using a Repeating Field(s) for a purchase order will not permit me to produce summary values for specific Item #, i.e. report how many #347 knobs did I purchase last month? Is that not possible to extract from a repeating field, and/or is it thru a portal, or must I generate a separate record for each item on PO to accomplish this?

Hi ALl, I want to select a row in portal and go to the related file based on content of portal row selected using a button? Somebody has an idea about it? Thanks

Using FM 6 on Win XP Pro. I've got a portal where users can create records. They select from a drop-down list of ID numbers of people in the database. This ID # field is placed underneath another field that displays the actual name that is related to this id number. When I scroll down the portal, the ID # field is brought to the front making it impossible to see the name field which should be on top. Strangely, this only happens to the portal rows that were visible before I started scrolling. The rows further down the list show up fine as I scroll. If I click on a row where the ID had come to the front, the name comes back to the front, but only for that ro…

I have a parent file which has a specific unique date field. One record for each date for 2004 I also have a child file which holds info regarding training seminars. These can be over 1 day or several days (upto a week). The child file has "Start Date" and and "End Date" fields. I need a portal that will show any child records for seminars which are active on that particular parent record date. Obviously there are three possibilities - 1) It will start on the parent date 2) continue on the parent date 3) end on the parent date For example if there was a seminar from 12/2/2004 - 15/2/2004 then the seminar details would showe in the portal for all parent …

greetings, is it possible to (based on a script) colour certain records in a portal. ie. if name = "Pall" make this record print out blue and if name = "Jim" print this record in red. cheers!

Hi all I

I have two databases. One database with the customer information and another database with zipcodes, city and state. I would like to compare the zipcode information (city and state) that the customer gave me with the zipcode information in the zipcode database. I'm currently able to compare the city and state that the customer gave me with the first record in the portal of the zipcode database. How do you do a compare with all the records within the portal? Here's the relationship: (Customer Database).........(Zipcode Database) Zipcode field ----------------> Zipcode field Here's the database (Customer Database)<----------(Zipcode Dat…

i have a portal sort going on, but it does not sort "Number" values properly, somehow i need it to sort on a number that is preceded by 0's... but not actually display the 0's. this is how it sorts at the moment: 45,567,123 5,600 9,020,111 but i need it to sort this way: 00,005,600 09,020,111 45,567,123 and then format the numbers for output without the following 0's 5,600 9,020,111 45,567,123

I thought I was dashing off a demo file, but instead have a riddle in the form of a misbehaving file... The idea is to create a portal that shows which records are actually being browsed, keeping up with all sorts of additions/omissions/deletions, etc. I had no success with self-join relations on the promising Status(xxx) functions. But FM gives us ONE potential handle on the identity of the found set: a summary total field can be analyzed to figure out which records are being totaled, provided only that every total is unique. A sum of any set of unique powers of 2 is unique. So if each serial ID#n is assigned a 2^(n-1) binary ID (1,2,4,8,16,...) then any total (like…

Hi, I'm a newbie and I'm not sure if I'm in the right topic. I am working with a db for tracking all of the information associated with hymns. I have a Serial #, Title, Composer, Author, Copyright, ect... What I want to do is create a report which will show me the following: Author............ X,XX,XXX, (Associated serial#'s) Composer.... X,X,X,XX, " I am supposing these are in a portal, but I cannot get a portal to show them to me this way, only in a vertical list. There are some cases where the Author and Composer are the same. In those cases, I only want one record to show. I Figured out how to do this, but I can't …

I have a contact database and have finished it so am now onto reports. I simply want a month to date report, which when you indicate the month, it will display on the layout all the done items for that time period. So i created a portal on the layout with a generic x relationship to done items. However, say in January there are 10 done items, that is fine, they appear but then in March when there are no done items the original 10 items from january are still in the portal list. now i get why, but what i want to do is have portal display the current found set of the done items table. Can i do this.....? Chris

Hello All, I have a "case" record with a PK of case_ID that has a to-many relationship to an "event" that uses case_ID as its parent_ID. The "event" child has an event_ID as a PK which has several to-one relationships with different "event" detail records which in turn uses the event_ID as its parent_ID. (It also as case_ID assigned as case_number as information but not used in the relationship scheme.) Inside case I have a series of layouts that displays the details of a single event child at a time with "previous" and "next" arrows to show all the child event records - which are essentially grandchildren. I have a calculated value in case called child_id_fo…

My portal lists all accounts owned by a specific customer. I want to create a field that will total the number of the ACTIVE accounts (elimiating the CLOSED ones). The result I'm looking for is a number of ACTIVE accounts that I can use for billing.

hey kiddos. happy holidays to one and all. we are trying to keep track of things like vacation dates, or employees available to work outside their normal schedule...etc. Files being used: employee file: each employee =one record. date file: each date =one record. right now i have thru 12/31/2004. (i basically scripted the creation of new records in the date file for one year. near the end of 2004, i'll prolly create 2005's records) i would like to have a portal in the employee file that has 366 rows. Row 1 is the current date, row 2 will be tomorrow, row 366 is today's date +365. when i use the db tomorrow, row 1 will be tomorrow's date, row two…

I have a really long list of fee codes (+/- 3500), so a "hotlist" is an obvious necessity. I could just allow users to flag the hotlist items in the "Fees" file and display the flagged fees in the "Invoice" file using a conditional menu, but I'd like to give the users a 'professional' interface to create the hotlist, where they can move codes to and from the hotlist....something along the lines of the FM Sort dialogue box. I've tried a variety of relationships (and even tried writing hotlist entries to another file...) nothing has worked... can a brighter mind suggest a solution? Thanks Dave

I have looked for an answer to this problem but can't seem to find it. I have 2 dbs - Clients and Episodes (a given client can have more than one episode of contact). In the Client file, I have 2 portals - one is a brief summary of each episode, the second is a single line portal containing a number of fields giving more complete information about the episode chosen from the first portal. This portal is invisible unless triggered by a specific value in the episode file. If I browse a client record in the Clients db, choose an episode from the first portal and display the complete details in the second portal, then browse other clients in the Clients db, the c…

Hi All, Merry Christmas and all that. I have a problem with a portal that I can't work out. My portal is showing records correctly, but does not allow me to create a new record in the related database via the portal even though the relationship is set to allow this. The error message I get tells me that the relationship is invalid. If it is invalid then why is it displaying existing related records correctly? My match fields are both calculated fields and have the same calculation, which is: If(Study = "AMFS", Individual ID & "-" & Family ID & "-" & Blood ID, Study & "-" & Individual ID & "-" & Family ID & "-" & B…

For each record in my database, there is a billing section. On that section I have a pull down menu with the tweleve months. I want to be able to choose a month and have three fields be filled with information. I want it to display billing information based on the selected month. Im assuming I should use portals and a seperate database. Can anyone explain to a total newbie how to go about setting up this process? Any help would be GREAT! thanks in advance chris

I am building an Manufacturing Order Process. I have a Product_order_form.db or order.fp5, and a Product_manufacturing_order_form_5.db or Man5.fp5 (order.fp5 & man5.fp5) What I need to have happen is for the user to be able to enter more than one item with its coresponding data fields on one invoice (order.fp5), but for it to automatically create a manufacturing order (man5.fp5) for each item with its coresponding data fields. i.e., <item_no> <qty> <lot_not> <prod_description> <price>. Any Ideas? Thank you in advance for any input. Josh

Some fields display the data of the current record in every row of the portal, whereas other fields behave as expected (and display data chronologically). Any suggestions? Thanks, Jason

How can I print the entire contents of a portal and not only the Xnumber of lines that show on the screen? Mike

Hey I have two db's A & B. the results of a find are displayed in FILE B and I have a portal in FILE A wirh the fields from FILE B in the portal, but no data is showing up, even though it exists in FILE B. WHat am I forgetting? I know it has to be something simple... Thanks! M

I want to use the portal visibility trick to display (or not) a delete button in a single row portal based on the user's access to that record. I have everything set up and the portal visibility works perfectly however I can't get the button to delete the record I am viewing. If "Allow deletion of portal rows" is checked in the portal setup, the first record in the records I am browsing is deleted. If it is unchecked, nothing is deleted. I've tried attaching a script to the button to call an external (through the self-join) script but I can't get it to work. It seems that I either have to have the portal automatically sort so that the current record is first, or …

I have a database of every race ever run in the NASCAR Craftsman Truckseries. The db that holds all the race information is called "races". I have another db which shows the complete driver history for each driver...total top tens, wins, top fives, etc. I want to put a portal in the "driver" db which will show me how say driver "Travis Kvapil" did at every track he has ever run on. The problem is if I put the field "races::track" in the portal then I will get "Daytona" three times since he has run there in each of the last three years. So it looks like this... Daytona Daytona Daytona How can I make the portal work to get just one Daytona instead of …

what would be my first step in trying to sort portal rows? i would like to create buttons near the top of the columns that will sort each column in ascending and descending order. any help would be much appreciated. cheers!

i have a portal that's filtered according to two fields. the client number, and the month&year of the jobs. i'm doing some diagmnostic tests, and i noticed that there's a few records from the child file that are making it into the portal but the two match fields don't match. for example, for a portal from december, jobs for a certain client will be from november and december. i need to fix this, but i can't figure out why it's doing this. the relationship seems to be fine, it seems to be that somewhere it's _just_ _not_ _working_. i'm pulling out my hair wondering what it could be, does anyone out there have any ideas??? thanks in advance for any help...…

I have two files. One contains the main items, the second contains the parts that make up the main items. I want to display the main item (a title field) with a list of the related records (records of subitems) from the second file. Very simple I know, I've done it, but my problem is I don't want any borders or boxes when I print, just the text. I've looked and there doesn't seem to be a way to get rid of the border or black lines around the portal, at least none that I've found. Is there a way around this?

Hi, I currently have a portal that shows 4 fields from another database (ie Order Number, Order Type, Product, Biller). I have a global field called g_biller in the database which contains the portal. As I type a different name into the g_biller field, the portal shows the records that belongs to the biller. Is it possible for the portal to show a specific biller AND a specific product at the same time. So it's like a find with 2 separate field but with a portal? I'm using FM4.1 Thanks

I have a database of clients and another of episodes of contact with each client. I have set up a portal in the clientsdb that shows basic details of each episode in each row. Each client has a unique ID (Christian Surname -> surn chr1, Christine Surname -> surn chr2 etc) and the episodeID is surn chr1-001, surn chr1-002, surn chr2-001 etc). The relationship for the current portal is via the client ID, and the episode number is displayed in the current portal. I would like to have another portal in the clientdb that showed another set of information from the selected epidode when it is selected from the first portal. I would like only that episode's details…

Hi! Is it possible to change the relationship for a portal by changing value in a field? The field contains a valuelist with several choices

Hi All, I'm new here. I just came back from Devcon and had an incredible time. I have a question that I think this is the best place for it. But, its not the ideal one. I'm trying to set up a method to duplicate a record by selecting manually which fields will be duplicated. This should be similar to the Import/Export control panel. I want to give the users the ability to select which records to duplicate and which not to. Ideally, each user will use a checkbox or arrow to select which fields will be duplicated. The FM duplicate option does not work for us, since it duplicates everything. There are certain fields that we do not want to duplicate…

I have a portal with a string of text follwoing. How do I make it dynamic so that the text shift according to the number of record display.

Hello, and thanks for your help. So,I have created a CONTACTS database, and I want to create an EVENTS database that links to it. So, in the CONTACTS file, there would be a portal that shows information from the EVENTS database that allows the user to make choices in the CONTACTS file that would relate to each event. So, Event Number 1 created in the EVENTS Database, would show up in the portal in CONTACTS automatically, and then the user could choose to invite this contact to this event or not. Then in the EVENTS Database when I look up this event, it would dynamically store all of the contacts that I have invited to this event, and then I can make …

I have searched through a lot of past posts but I have no found the specific answer I am looking for. I have a database with hundreds of records. Each record has a portal that contains several fields with 1 row of data to hundreds of rows of portal data. There have been several times now when users have entered large ammounts of data but had forgetten a line of information. These lines need to go in a specific order since they log time codes on several tapes for each project our company is working on. The users need to be able to insert a portal row in the exact place they had forgotten teh information (could be the 2nd row could be the 75th). Is there a way to do this?…

I was wondering if there is a way to show the newest records in a portal first. Everytime I create a new payment, it adds it to the next line in the portal. I have read a few posts about sorting a portal. It sounds like that would do it but I have no idea how to sort in a portal. Could someone explain it to me? Thanks a ton!

My project involves printing a report on each transaction, including relevant feedback text from the two most recent *related* transactions. I have been using a portal with two rows to accomplish this. The only problem is that the related field's text entries vary tremendously in length. To accommodate the longest, the portal row is a pretty tall brick, but that means that lots of space is wasted on the portal rows with barely any text. I really dislike big white space and wasted page-breaks. As far as I can tell, no sliding/printing options can get a portal row to shrink its height. Right? (If it were possible, I might even go for more than two rows, since on average abo…

Quick (hopefully) question: Using a DB in FM5.5, and trying to perform a find on a portal field. The field links to a KEYWORDS database from a main CONTACTS file, and each record can have as many or as few keywords linked as it likes. When I enter find mode, I can enter a single item into the KW portal-field, and the find executes perfectly (finding all parent records with that keyword). However, I cannot (to my knowledge) enter more than one keyword at one time this way, as the portal does not recognize that it "should" create a new portal row, etc. Thus, I cannot execute "AND" finds on this field. Is there a way (via any method, ie scripting, etc) to execu…

Hello all, My details I have a file called Meetings and created a self-join relationship to a file called Mychild. The problem arose when I created a portal in Meetings that went to Mychild. I then created a field in the portal that is Mychild::Title. The field does not show in the portal, I also made the field into a button that would go to the layout Action Items. The button does not work, the field seems invisible. After reading the entry level portal post I thought the problem could be because there is no data in Mychild. Could this be the case? How would I get data into Mychild? thanks in advance, Christian

In FileMaker Pro 6 I am creating a database that will track meeting minutes, agendas, action items, attendees, etc. I plan on dividing up the layout into different sections according to the different departments of our Real Estate company, for example Business Development, Sales, Closing Department. Within those sections I would like to have an outline in which the outline numbers or letters are created by FM upon prompting by the user as with Word outlines. Is this possible?

I come from a SQL background and am used to being able create joins between multiple tables to get at the data I need. With FileMaker, I am limited to a one-to-one join and I would appreciate any ideas for how I can accomplish the following: I have a Company DB that relates to an Invoice DB. The Invoice get LineItems from a LineItems DB that gets product information from a Product DB. On the Company DB Layout, I want to have a portal that shows all Products that the company has purchased (i.e. been invoiced for). Essentially, I need to find all Product ID's that related to that Company ID through an Invoice. How can I do this? I already have a portal that shows…

Hello Any and All, This is my first post so I am new to all of this. I am sure my problem isn't unique and if it has been answered before, please direct me to the post. I am designing a database solution to track all contracts and spending for my company. I have one main user interface "Contacts" table which is related to several other files (grouping related material). The problem I am having is with the "Invoice" table. Invoices come in from some vendors very often, up to 10 to 12 in a one month period, each with different invoice numbers and dates. I need to not only be able to calculate the Year-to-date (YTD) spending per contract, but to be able to pick a m…

Is it possible to limit a portal to display fields from related records that were created after a particular date? In other words, I have one file which creates a record for each patient visit. In a separate file, I have portals that relate back to the patient visit file. I would like to only show patient visit data in the portals after a particular date. Thanks.

could i get a quick instruction on how to setup a portal, i can't seem to get it. i create a relationship, create a portal, but get no records... i'm confused. thanks in advance for any help!

Yes, this is a bug that I have not found a way to eliminate, except don't use portals. I would recomend to use a list view instead of portals.

We have set up a portal through a relationship from one file (called Leads) to a file named Line Items. The records in Line items were initially created through yet another portal through the file Orders. Line items are related to Orders through the field Order Number. When they are created a field called Account Number is populated with a Lookup. The file Leads has a portal into Line Items using the field Account Number. When I enter an account number in Leads some but not all of the records in Line Items appear. In every case, the missing records have a different Order Number than the records that appear although Order Number is not used in the relationship between…

Hi all I have been trying to do a clairvoyance portal for our national broad number. The problem is when i try to do the selfjoin relationship on "Keywordc" and "Matchcalc", Filemaker says that "Matchcalc" cannot be index and that the ralationship will not work. Would someone look at the attached files and please tell me what i have done wrong. Thanks Lionel typeahead.zip

I have a portal on my "main" layout that shows "registration paid info" from a related file. I would like to be able to tab into the portal to a new record, rather then into the first field of an existing record. Can someone help me with this? Thanks.

Using FMP 5.0, I'm trying to create an Invoice DB thta includes info from a couple of different DBs. Using the model from the user's guide, I tried to build a portal that would display records from a line item DB that contains related fields from an inventory DB. Problem #! I can't place the related fields from the inventory DB into the portal. (It says I can do that in the user's guide)Problem #2 How can I make calculations on items in the portal?Problem#3 Is there a way to place info from different DB's together in calculable fields? thanks for any help.

My questions is maybe very simple. I have a layout with a key field and a portal so I look for records in the portal that match with a that key, but I need to know how to get summaries from the records shown in the portal. [email protected]

Hi, I'm having trouble getting a display in my portal. Here are the details: From a custom dialog... I prompt for a partial name (self-join relationship on indexed "Family Name") ie "sm" which should result with rows for: "smith" and "small" Enter Find Mode[] Set field ["Family Name","g_familyname"] Perform Find [Replace Found Set] Goto Layout ["Find Family"] The portal appears BUT displays only the "small" row. The "find" works correctly since it omits the non "sm%" rows. I can click with the "index card" and see each of the 2 rows. How do I get BOTH rows to appear in the portal?

I have a portal which shows events. I would like events scheduled for the future to be displayed in a different color, or perhaps underlined or in italics. Any suggestions? Thank you, Jason

Hi guys I've created a portal in which I don?t want to create related records. So "allow creation of related records" is UNchecked and "entry into fields" isn?t allowed. I want to make a script with wich I would create related records in that portal. ie If there's a record in the first portal row, to create a new record in the second row ...etc. Can you help? Thanx Lulu

I've got one file (eye surgery) in which every surgery is a record. There are two portals that list all patient surgeries, one for the right eye and one for the left eye. Unfortunately, when the right eye has a surgery, the left portal creates a blank entry, and visa versa. Is there any solution to this? The portals look a little questionable with the blank spots in them. Plus, if you click on the portal (button) in a blank spot in the left eye portal, your taken to a right eye's surgical record. Thanks!

I have 2 files, the main file with a portal to the data file....from the main file i only want to print the data specific to the record im currently in....so lets say Record 1 has 5 lines and if im in record one, i want to print that 5 lines of data, but when i look at the data file more data is there since i have more than 1 record on my main file...any help would be greatly appreciated

I am creating a portal for daily attendance. When the user clicks in the first field of the first row and selects a name, I would like to automatically create a new portal row. I am not sure how to do this. I have seen it done before. Please help. Thanks so much.

I'm trying to have each row showing in a portal have a number, but I can't figure out how to do it. My Key Field is called Name. If I create a summary (count of Name field) [Running], it does not just count all the records for that particular name, but *all* found records. And when I add to the records by creating new records within the portal, it doesn't update properly in any case. Is there a way to do this so that say, each of the rows for Joe Bar's records show 1., 2., 3., 4., etc. and each of the rows for Nancy Foo's records show 1., 2., 3., etc. ? All My Best, Jeffrey

I am VERY new to FileMaker Pro and am far from understanding programing. In other words I need very simple non-programming language for answers. Here's my questions: I have downloaded Solution Framework and have been customizing it to fit my needs. When I work with several test invoices my subtotal reflects ALL my invoices and not just the one I am looking at (same with Sales Tax). It is taking the subtotal from the line item list. When I print out or preview the invoice from the report module the subtotal is correct. I am baffled and can't figure this out. Can't my subtotal (and Sales Tex) reflect just the invoice I am working on? :crazy:

Hi I have a form with a list of item to be introduced. I can use a lookup and remember the id codes for each item, and compleat all the lines, or... I can group several items and when I introduce the group code all the items from that group just show up on the list. I'm using a portal to do that but the problem is that if the items file changes (ex: item 1 was from group A and now is from group B)all the records on the related file change, even the older ones. Can I freeze the data introduced on a record? Thanks

This doesnt seem to work! Here is what I've done so far. I have created a relationship between the two files called requestnumber and a global field in the child file (TestedParts) called gRequestNumber. The scripts look like this: (in the parent file) Go to related Record[show,"TestedParts::gRequestNumber", "RequestNum"] Duplicate Record/Request Set Field[TestedParts::gRequestNumber", "RequestNum"] Perform Script[sub-scripts, External:"TestedParts.fp5"] (in the child file) Unsort Go to Record/Request/Page[First] Loop Duplicate Record/Request Set Field ["RequestNumber", "gRequestNumber"] Go to Record/Request/Page[First] Omi…

I have a weird problem. I have a portal that has a listing of prices and taxes for that item. These are simple total items. When I ask for the sum of the totals of prices and taxes I do not always get the correct answer. Somewhere in the process it seems to round off the numbers causing the wrong answer. It doesn't do this all the time which makes solving the problem difficult. Anyone clues and what to check from anyone would be appreciated. Thanks in advance,

Hi there, I'm trying to design a portal with 20 different users, each user(sales-person) has own specific clients. For example User 105 can only access the fields with the user=105 identified. I have a global primarykey to start the search in the portal that can take any of (Name / Refrence No /Phone No of clients) in characters. Portal Data includes "Name", "Refrence" and "Phone No" and grabs the related data for each logged users and stores in a different field i.e. Name105, Refrence105 and Phone105 because related data is in a different (child) file so that calculation field in the Portal grabs different data according to the user logged on and the shows the …

I am having a problem with the repeating fields and the page break. I cannot get to break the pages properly. The first is fine. The next is a hair off. The next is worse & so on until it is breaking in the middle of the field, printing half of the field on each page. Please Help! Thanks

c'mon, folks. i posted this question a while ago but nobody replied with anything... let me ask again: can i have a portal return specific items/values by running a find? for instance, if i have a portal with two columns... one column with some text-data, and another "identifier" column that i would use as a key (yes, or no)... i went into find mode and, in the second column (the key-field), i'd type in 'yes' to have the portal return all the line items that have 'yes' in the key-field... or i could type in 'no' for the opposite to happen? i need to be able to do this or something similar.

I am using Windows 2000 and FMP6 to store GIS projects data. I export print layouts from ArcView GIS and save them as *.wmf (placeable Windows Meta File) image format. A portal in my master file (Projects.fp5) shows container fields from an external file (Maps.fp5). I right click in portal field and insert the above picture ('Store only a reference to the file' box checked). Although it stores the picture, the screen starts getting full of bugs. It is also very slow.

Hello again. I have another serious issue. It seems like I end up trying to do the hardest things possible. Anyway, here is the dilemma (in as plain o' english as I can muster...) I want to create a system that allows an end-user to select a product, enter a quantity, and then have the system look up a quantity break unit price. In other words, for each product, there are breaks: 1-5 = .15, 6-9 = .14, 10-19 = .13 and so on, and if you enter 7 into the quantity field, the system returns .14 for the unit price. Now, the reason I posted this in the Portals forum is because I have it set up where there is a file called "Products," and a file called "Quantites" that …

Hiya, I have this database of peronnel records that I am trying to create. Currently in each individuals file I have a portal which lists the certifications, the date of the certification, length of the certification, expiration date. I would like to somehow like to each month make a list of each persons certifications that are going to expire soon with their name. I've messed around with it for far too long with no success! Any help would be appreciated Trisha

i am at work and we dont have fm so i cant read the help. i haven't looked into these. what do they do?

This is similar to a previous post, but I still have not made much progress. I have a field called SignInDeposit. This deposit amount changes as often as weekly depending upon the customer, and I would like to keep a "history" of the deposit amounts, shown in a related portal. Currently a new line item in the portal is created via a script that sets the current time, date, and user, and goes to a text field to allow the user to enter a "note". Is there anyway for me to incorporate something into this script and attach it to the fild called SignInDeposit or something I can do to keep this sort of "history"? Any thoughts?? THANK YOU

Hi, I'm trying the make a portal that only shows tour dates to come, and hide passed ones. For example, if a band is having a tour date on 07/16/03, it will show in the portal, once 7/16/03 passes, so will the row in the portal. The problem is, there is no way to have a relation with dates you can't index. Since there child records have to be static dates and not calculations. As well, tour dates could be a year or more in the future, so having a calc in the parent file of a long date range in the only way I can figure this - and I don't like that way Anyone else got ideas?

I'm using the duplicate record/request to copy the record. But I would also like to copy the information in the portal fields as well. Any ideas on how I should go about this? Thanks for any help!

I have a portal which lists dates, times and ticket prices of the performances of a show, an example is below: Friday, June 4, 2004 8pm $13.00 Saturday, June 5, 2004 8pm $12.00 Friday, June 11, 2004 8pm $12.00 Saturday, June 12, 2004 8pm $12.00 Sunday, June 13, 2004 3pm $11.00 or 2 for $20.00 Friday, June 18, 2004 8pm $12.00 Saturday, June 19, 2004 8pm $12.00 From the portal information above, I can easily get the dates of the run of the production: min (Performances::PerformanceDate) max (Performances::PerformanceDate) Now, what I n…

Can i setup a way to make the portal show only the number of rows that actually have data? right now all i know how to do is set how many rows to show. i would like it to change depending on how many records are found through the portal. is this possible?

I have three files. I have tow portals in the first one: one portal for each of the other two files. Same layout, side-by-side. I want to use a field from one portal to create a value list for the second portal. Is that possible? More specifically: I have (to simplify the situation): Organizations, Locations, and Phones. Any Organization might have multiple Locations (eg, Oakland Office, San Francisco Office). I don't want to divide that into seperate organizations. All of the Phone information needs to apply to a specific Location. This number is in Oakland, that number is in San Francisco. I can't calculate based on area codes, Locations are often cl…

How do I copy the last row of a portal and paste into a separate field. In this case the portal displays a calculated field from another file, and it is in the Layout "Current Meds" I've tried the following, but I end up copying all the portal rows: Go to Layout ["Current Meds"] Go to Portal Row ["Select, Last"] Copy [select] Go to Layout [original layout] Paste [select, 'Meds"] I really apprecitate any suggestions! Thanks

help me I'm novice in FMPro scuse me for my English i'm italian I' have portal with 10 row and 3 field Field "FldData" Field "FldUrgenza" Field "FldName" I want Field's Background Color of field "FldName" is Red if Value FldUrgenza = "Urg" without change color Background other row Portal Grazie di tutto

Is it possible to search through and/or sort records found in a portal? I have a portal that displays fifty lines of info... the way i have it setup right now is that, on each line, i have placed two fields that are read-in from another file called BillableX and TestsPerformedX, respectively. In the file that these fields are read-in from, I have fifty value-list-fields ("yes" or "no") that tell the user whether or not a certain test has been completed and if it is billable (these fields go down the page vertically); each field is numbered, i.e. Billable1, Billable2, ... Billable40. Adjacent to each value-list-field, are fields that tell what test was performed; t…

Hi! I tried everything and nothing works if you have forein characters other than latin to filter a portal. It doesn't find anything at all! I tried many ways like "ASCII" characters in fields, etc. Nothing will do I use an English version of Windows with Greek character support and the only compatible font with the least problems, "Arial Greek". Any hints? Is there something i could do, or is Filemaker not supporting it? Thanks

I have a mini dv database in this db I have for each portal row one scene with time code, my goal its to add up all the time of each scene. Please see picture. portal sum.jpg The time fields are split up in 3 fields. Hours Minutes and Seconds. Any ideas in how to calculate this task?? Thank You!

I have a field called LOCATION. Once this is data entered, it is very important that it not be changed by accident, however, intentional changes are OK. Is there anyway for me to have a script run only if the field is changed? This script would place the test that was changed in LOCATION into a related portal, and show exacly what was changed. However, I do not want this script to run on the initial data entry, only if it has been modified from the original entry. Any thoughts??

I have a portal with financial information on my client. what i would like to do is total how much each client is paying each month into they various investment schemes..The first field is a pick list which applies to either the client or spouse the second field contains the monthly contribution figure. there are normally between six to 10 records in each portal. I would like to work out by a calculation what the client and spouse are paying into the schemes by totaling each record by client or spouse in the portal that contains the records... thank you for your help in advance. regards nick

Say I have a portal on a layout in my "Main" file listing the related casenotes from the "Casenote" file. I have some field on the layout below the portal that are also from the Casenote file. My goal is when I click on a row in the portal, it will update the fields below to show the information of that portal row. Below is an image of what I'm trying to accomplish. If I click on a record by A, then the fields by B should change to whatever the values from the record in A are.

[color:"red"]I HAD TO REPOST THE ATTACHMENT...I HAD UPLOADED THE WRONG FILE..LOL Maybe Someone can help. I am pretty fairly new to the Filemaker world but have caught on pretty fast. Heres my problem. I want to have columns in my portal. Yes I know you can easily do it. It requires multiple portals. I seen a demo in the forums that did it quite well but couldn't quite grasp the concept of all the relationships. If I maybe post my solution, could someone maybe give me ideas on how to incorporate the columns into my solution. I want to have Point Of Sale Product Buttons, But List In Multiple Columns..... Any help would be appreciated. POSnPortals.zip

I am trying to set a lookup from a portal in my invoices file to a seperate credit note file portal to ensure correct credit note pricing but I appear to be unable to make this work. The relationships set are as follows Invoice File: Client File >Client Code Invoice File: Product File >Product Code Invoice File: Credit Note File >Invoice Number Should I be trying to lookup from the line items file defining the relationship by invoice number. Chris Courtney-Stones

Some time ago I posted a problem I face with Duplicating records which are related via a portal. I still face this problem today and I hope someone can help me. I have 3 DB's: Quotes, line_items and Inventory I need to be able to duplicate quotes (not a problem) but also duplicate the related items with the new quote number. How do I get the DB's to duplicate the previous items, renumber them so that they become available in the new Quote? Thanks in advance.

I work at a post production company that uses hand written notecards to write down time codes of work that are layed off to video tapes. I have been working to create a filemaker pro database system to eliminate these handwritten cards which are often lost through misuse. Basically there are two layouts, card view and list view. I have it set up so that each card has editable information in it like NAME of CARD and CARD NUMBER which are transfered and displayed successfully in the list view. However, I have set up a portal in the card for each time-code entry. There could be several entries per card. I do not need this information displayed anywhere else but on eac…

OK, I am working on a scheduler for my company and hit a stumbling block. i have a general idea on what i think may work but need advice from some of you FM wizards. . OK, i have a db that is called jobs. it has all the information for a given job i enter in when a customer calls. Then i have a db called schedule that has a portal to jobs and lists the jobs that are scheduled and draws a line across the screen to show visually the time slot it is in say 8am-10am ( scheduled window for my arrival time at my customers home ) that works great. now what i want to do is have another portal ( i think thats the way to do it ) that will list mt techs ( only me atm and show wha…

I am developing a database for media contacts in my office. Right now I have two relational databases -- one for the reporters and another for where they work. I have made a third relational database called Activity History -- through this database, I would like each reporter to have a running history of the press releases, "the activity," we send out to them. Right now I have a portal set up from the contacts database into the activity history database and when they click on "New Activity" -- it takes them to a new record in that database to enter in the press release information and then the script copies the Activity ID and pastes into the Activity ID field in the fir…

is there a way to delete a portal row's record by itself from the portal and the related db? i have the [prtal set to allow creation of related records thru the portal. the problem is if someone clicks in the "empty"/potentially new portal row at the bottom, anticipating a new record/portal row, then types any key, it creates a new record, which occasionally does not end up being needed, and so clutters up the portal with empty rows mixed in depending on the sort key. is there a way to delete these portal rows/related records without going to the related db? there is no need to use the related file unless i'm deleting these empty records, so i don't want to build …

I have a file showing work lists per part with a self joining relationship that shows all open work lists for the same part. It works great, but the portal shows also the record itself. Is there a way to show only the related records buy not the one we are in?

When I click in the portal area outside a field, the whole area of the portal turns to inverted color. Have I set the colors wrong or is this normal? It is not a nice view. Thanks, John

I am trying to be able to show if multiple cities with the same name (but from differnet states) exist for data entry users when they enter a city name. I have a master file and a related city file. So, when someone enters Portland, for example, a portal would show Portland,OR and Portland,ME. Is this the right approach? How could I do this?

Hi, ... Is there any way to get the total (summary) of a numeric field, only for the records appearing in a portal? (e.g. total of "quantity" for only those records that appear in a portal) Thanks is advance