Portals

I am trying to find a set of records that are identified by a Category record id#, duplicate them and then switch the id number on the duplicates to a new Category record #. Of course when I try to script this it can create a new record, copy over info in the set variables but gets hung up on going back to the second record in the found set. If you want to see my current script you can but I'm pretty sure it's monstrous. I still have a hard time thinking in loops and steps. help?

I am running FMPro Advanced, Server, and Pro 9.0. Server is on Mac, Advanced and Pro on on a mixed pc/mac platform. My relationships for the particular portal I'm having trouble with are set to add new record. The folks that are trying to add a new record via the portal have full access privileges. We can delete the records in the portal, we can also update records in the portal. The problem is we can't add another record. We go to the empty field, type something in and it comes back with the error "This action cannot be performed because this field is not modifiable". It does this on every field. However, if I go to the original table, I can enter record…

In all of my portals, I always get an extra portal row/record at the end. I do allow records to be created via the relationship, but is there anyway to disable this?

Hi everyone, I have a portal with around 2000 records in it, sorted alphabetically . What I'd like to do is put a search field above the portal where I can enter a few letters from the name of one of the records and have the portal only show records that start with those letters. Like if a record I wanted to find was called "Anderson", I would just enter "and" and the portal would only show records that started with that. This would let me narrow the portal down and quickly find the record I'm looking for. I saw another post that suggested using a global field as the search field and using that in a relationship to the name of the record. However, I think that w…

Hello I have a summary field in a portal that summarizes a monetary value for like records having the same value for another qualifying field in the portal: Field1 Field2 Field3 00001 $100 $300 00001 $200 $300 00002 $500 $500 My issue is when I enter data for a new record in this portal (which is sorted for the summary field), the sort instantly occurs when I first enter the value for the first field. This messes up data entry because the field where the cursor ends up after the instant sort is not the field in the new record. Is there any way to have a summary field in a portal where the sort d…

I am making a Football Stat database and I don't know what I did to make my Portal not show up anymore. I have attached links to 2 files, FootballWorks and FootballDoesnt. I want the FootballDoesnt file to be the one I keep. Here is how my database should work. Enter the game data on Game Stats screen and it should show up on Player Stats screen in the portal which draws from Players Table and Freshman Stats graph. I am only concerned right now about the Freshman Passing stats for Ben Konen (only one with stats on both) because once I get this fixed, I can get the rest. Now it looks like the relationships are the same in each graph. Why won't this work in Footb…

I have searched to find a solution to what is probably a very simple question. I have a client layout with a portal that displays all the invoices for that client. I want to limit the portal display to a specific year. Tried creating a global field gFilter which I related to the Year field. Then set the value of the gFilter in a script to use as a find but that did not work. There are a number of portal queries in the Forum but I have not been able to get any of them to fit my circumstance or possibly I have not understood them. Any help greatly appreciated. Thanks Mitch

How do I show a portal's summary field on the layout of the parent table? When I put a portal summary field in a layout of the parent table it gives me the the summary of the related record only.

Hi All, I am having a hard time trying to explain this one! I have a database for a tradeshow. I want to keep the same database for each year of the show to hold history, money spent, points, etc. I have built a portal to capture this data. The problem I am having is there is a booth# field that is unique but if one of the years show has past and we go into the second year (same portal) all the booth numbers are taken because its looking at the year prior. Do i need a calculation to fix this or is the portal a bad idea to capture this?

I have an invoice database that lists all items in a portal, and is designed to print them. The portal is 32 rows, which it prints. A script then rolls the portal down to show the next 32 rows, and print them as well, until it nears the end. When the script realizes that it won't be able to scroll another 32 rows, it simply goes to the end. My problem is that, for an invoice, I can't be printing the same data twice. This occurs at the end, when the portal only scrolls, say, 17 rows. The 15 rows above that would appear on this page, as well as the one I printed last. I'm wondering, is there any way to purposely get FM to dynamically show more empty rows at the…

My current layout is centered around a table containing RMA information. We then have a portal that contains information about individual products. I'd like to add a field that would be for problem diagnostics. The only problem with this is that a single field per product isn't cutting it. Thus, my first thought: A portal in a portal! Well, that didn't work. I would assume it didn't work because the newly created portal is still related to the main table, even though it's inside of another portal. Bummer. Now, making a new layout that is centered around the products, rather than the RMA records is not an option, as the records are most commonly brows…

Hello all. The kind young person who's testing my database form is having trouble copying information from one portal's field and into another portal's field. However, when I log in as administrator and use the same data entry form I can copy and paste as much as I like. The data entry user's account has privileges to change records in all tables and layouts, so I'm puzzled about this. Please offer me some ideas about what the problem might be? I mean other than that I'm a rank beginner who's in over his head, of course. I already know that. Thank you.

I have a table related to its child,(that holds related data),the relation is built by auto generated serial(like usual) The portal works all fine and always create a new records as its past on is filled. But i want to create a button that creates new rows without being needed filling past records. Will help alot in IWP!!

I have 2 tables - one is the main customer log and the other is a table to collect 'Next Action' dates. I have a script set-up so that when you click on "Next" to move between records it will automatically create a 'Next Action' record for that lead in the next action table. I have a portal created in the Main customer log to show a log of all next actions. For some reason the portal information is not showing up. I checked in the next action table and there is a record for a lead number (this is how the tables are linked) with all of the information filled in, but in the portal in the main customer log it is not showing up. I'm not sure why it's missing?

PROBLEM: I am trying to display a portal of only those Activities that have not reached capacity yet. I know the problem is as follows: Reservations Layout Reservations::ActivityAvailabilityLink (Which I have created an auto enter field of “1” to use as a link – this may not be the best way to do this either) Times2::RemainingCapacity (this is a calc field – which I know is the problem – but I need to display only those “activities” that have not reached capacity yet) Any ideas? QuikTiks.zip

Hi, I'm hoping someone can help me out. I'm a bit of a beginner with some of the more advanced filemaker features - specifically with calculations and formulas. I am hoping someone can help me with a portal filter solution. I'll try to describe the specific sections of my database as best I can so you can understand what I am doing. I have a database setup with a bit of a time/expense tracking system for consultants working on projects and tasks. Along with this, we have built a budgeting feature so we can provide an estimated cost for fees and expenses on a project to compare against actual fees costs for each project and task. I have a numbe…

Hello, I have a situation where I have a Customer Table and Invoice table and I have them merged on a layout I call Sales Slips. I want to be able to add new customers to the customer tables, but if they are repeat buyers, I don't want to be typing their information again, because then I would have a duplicate entry. So.... I need a way to still add new customers, but at the same time have filemaker tell me if it is a repeat buyer so I can just use their information again for another invoice. I know this is probably hard to follow so let me know if something needs clarifying, otherwise any help would be appreciated, thanks - Jeff

Is it possible to display all records of a table in a portal that doesn't relate to any other table? What I'm trying to do is displaying all the records of a a table through a portal. Can it be done?

I am trying to show related records where the relationship is based on unstored calc. Please take a look at the attached file. Any suggestion will be highly appreciated. Thanks InvPmt.ZIP

When viewing an [color:purple]Order record, I have a portal for [color:purple]Items Ordered. Inside this portal is a container field from [color:purple]Inventory showing a photo of the item ordered. It all works fine when viewed in Filemaker, but when viewed online the images don't load. All that shows is a box with a ? inside of it. Also, for some reason the scroll bars don't show on any of my portals when viewed online (but they do in Filemaker). Someone using a slower internet connection than me said they saw the images for a split second before they went to "?" I tried moving the container field outside of the portal onto the main body of the layout and…

i want to be able to view a found set of records individually on the left of my layout and as a list via a portal on the right so i can then get an overview of the whole set. i have found examples of this but cant get my head around how to dissect them! thanks

Basically I have a portal in Order layout which displays records from Line Items. I would like to be able to sort the portal by each field that is in portal (I have field labels above the portal identifying each field) - for example: Item Cost Total Row 1 IT001 25.00 25.00 Row 2 IT002 35.00 35.00 So when Item is clicked it would sort by item, when Total is clicked it would sort by Total. I have searched here on forums and have found some methods on how to accomplish this. One involved creating relationships and setting the sort orders there. That would mean that I would have to create as many relationships as I have …

New Member. Have been using Filemaker for ages and now am starting to get a bit more advanced. I have been developing a database and it is a main file that allows the creation of portals rows in a related table. Each record in the reference table auto enters a incremental number. The portal is then sorted by this number. I am trying to find a way of changing the sort order i.e. moving records up and down in the portal by swapping the previous records unique number with the one after or before thereby swapping the order up or down. Have tried and tried and not got anywhere and am now asking for help. thanks Duncan

ok, i have a table that holds all of my customer's data (name, address, and id) i have another table (linked by id) that holds a 'call history' that has the following fields: id date time call notes contact name technician now...i have a layout designed that has a portal inside of it to show all of the call history for that customer. my problem is that i want it to automatically fill in the "id" field with the value of the "id" field in the customer info table. is this even possible?

I'm having trouble with a Contact list within a portal for our Suppliers (ie having multiple contact for each supplier complete with name, nbrs, email address etc). I have an ID field that is set to create a serial number and increment by one for each entry. The relationship is set between the portal ID and portal ID on the parent Supplier entry. My problem is that each entry within the portal has the same ID number (although if I enter ten entries into one supplier, the next portal entry in another supplier has a serial number eleven higher than the previous)> Not sure if I have explained this well and I'm sure it's simple, but I am complete numpty. Please f…

I have a new PROJECT table which is related to the main table with the main ID. I plan to use the Project table to keep track of all actions for each project. In the main table, a found set of 2000 people are assigned to ProjectA. How can I create the 2000 records in the project table and put them in ProjectA? Thanks for any help! -Sal

hello again... i have a portal showing 100s of records for 100s of patients. but i only want to show the last two records for each patient. i don't want to keep these records in DB aswell [except the last 2 for each patient]. so i want to know how can i delete these records from db, leaving only the last two records for each patient. i was thinking whether looping through records for each patient and delete them one by one will be a possibility? or is there some other easy way to achieve it? i only want the last/latest two records and nothing of the rest. PS: records are being displayed in a portal. thanx.

I have a 450 row portal that prints out over 11 pages. After a few pages, the printout mangles the names at the bottom and/or top of the pages. I know I can do a summary report instead, but wanted to do the portal if it was possible. Any way to get a portal to break properly over multiple pages? Thanks Peter

I have a portal from an Follow-Up Table that is tracking attempted call dates for a record in my main table. The portal record field is called "Attemept date". I also have a summary field in the follow-up table called "Total Attempts" which is a count of attempt date. Each entry will have multiple attempts. I want to create a report that will list all of the entries that had an attempted call on a certain date - which I have done. However, the "total attempts" is not showing the total number of entries in the list (for instance, I'll do a search for today's date and will come up with a list of about 40 entries -- some have today's date showing in the "attempt d…

I have a Relationship between two tables. I created a portal. In this portal I need a calculation field that will count Only fields in it that do not have the word "pilgrim" It can show in the portal but not be counted. Then I have another field that if that field has something in it. It will be counted. Example Class date pilgram "This Record would not Count" class Speech date Class Date The next two would be counted, the speech field would need to be counted when ever something is in the field. 2 classes 1 Speech. If I had more speeches then it would count them to. The Total would be displayed on the …

I'm sure there is a simple answer to this one, but can't figure it out. I have three tables - a person table, an activity table & an activity occurrence. I made the activity occurrence table because I want to relate people to activities, but several people can be doing the same activity & and people can do one or many activities. Using the activity occurrence table, I have a portal showing a list of all the people. Working my way through the activities I select each person involved with the activity via a portal. The portal shows all the people via a cartesian (x) relationship. First a new record is created in the activity occurrence table. The ac…

I have a portal in my database and I would like (if possible) to have a field that will capture the total value for certain fields. My portal is set-up similar to this: Job Number PO Number Type Invoice Number Invoice Amount I have 2 different types of entries - CONTRACT or AWO. I would like to have TOTAL AWO and TOTAL CONTRACT fields set-up, so that if TYPE = AWO then it gives a total of the invoice amount for only those entries, and same thing for TYPE = CONTRACT. Does anyone know how to do this?

In FMP 8.5, I have two globals - Company and Department (to use in a portal filter). I have a pop up Value list of Companies on the gCompany field, and want only the Departments from the selected Company to appear in the gDepartment Pop up value list. I made a relationship gCompany Filter, with gCompany to Company and have the value list defined to include values from gCompany Filter::Department. In a portal :gCompany Filter, the list of Departments change with each gCompany selected, but the value list does not change. What am I not doing right? Thanks Stublito

I need to do a social networking table/layout for our membership database. The concept is who know who? I've done a cheezy one based on a join table and a portal from Name 1 to Name 2 that gets me the all the friends of one friend, but there are duplicates in the results and it isn't very elegant. I think I'm going to need a recursive script that "follows the branches of the tree". Has anyone done this? Thanks Peter

hi .. i had try different ways to get a right report this is how my portal look .. what i want is a report that shows me how much i sell from each reference ... from all customer ... i have try subsumary report but when i run it... it doesnt show anything ... what i am doing wrong?? thank for your help

I have 2 tables that have a relationship. It is essentially goods(inventory) and buyer (cashier). Is there a way to have the portal in cashier only show the items (invoices) not paid. I am sure its easier than i making it, but for the life of me i cant get my head around it.

i have two tables that are linked [relatipnship] and i'm showing their data on two different layouts. on one layout user can enter the data but on 2nd layout i'm using two portals to display entered data from the two tables. however, portal is showing a blank row at the bottom for new record but i want to hide/remove it. the relationship between the two tables is to allow addition/creation of new records but thats only for layout 1 where user can add a new customer thus adding info to related table as well. but in portals [layout two] i don't want to have new record blank row. i know i can do that by removing the option through relationship but then that will not all…

hello all i have a portal showing results of drug tests. it works fine except that it show tests which do not have any results [clinic visits]. so when i load the layout, it shows patient info [parent layout and table], related tests [in portal one] and related results [in portal two]. i want to show all the tests in portal one [working fine] but i only want to show results of the tests which have anything but clinic visit in tests. how can i omit/filter out "clinic visit" result-rows from the portal. for example PATIENT ID : 7 ============== TEST PORTAL [shows these records] =============== CLINIC-VISIT,DATE,ETC CLINIC-VISIT,DATE,ETC HEARING,DA…

When I select a record from the portal I would like the appropriate set of photos from the LogEntries table to load in the tabs. But I don't know why it doesn't load them. Can someone give me some pointers? Also, how do increase my canvas / form areas width?

It has been a while since I have done FM development. So I could use some help with HOW to think about this. I have a table listing products. I have a second table listing Images for those products. The key is an item #. An Item may have several pictures. Using a portal I can see the list of images for that Item. That's great BUT I need to put each picture path into a separate field along with the item data to export to an Excel report. Therefor: Item # 4, Name "Red Car", Image1 "outside", Image2 "inside", --- and so on. The number of images varies from 1 to 5 so I need 5 image fields. I can see them in the portal but how do I get them in…

I hope I dont post to much. Let me know if I do! I try to figure out how to copy one fields value to a different field in a portal and clear the second field value. portal_copy.fp7.zip

I've just run into a portal problem after converting to FM8.5 from 6. I have a portal whose visibility is determined by a calculation - if certain criteria aren't met, it "covers up" fields to stop data entry. This has been defined as a button to "Exit Script" if clicked outside the field entry, I think to stop the portal from staying highlighted (it's been years since I last looked at this). In FM6 I could still click on the fields and gain entry to them however now in FM8.5 if there is any button definition attached at all it stops entry into the fields - if the button "Does Nothing", then the portal stays highlighted if clicked on outside the fields. I ha…

I do have a portal with 8 rows. When I click on one of them, then the "Detail-Infos for Person XYZ" appear above the Portal. This works like a charme, but ... The Portal jumped back to the first position in the portal list. So if the user scrolled a lot and want to get some infos of the person, he has always scroll again all the stuff only to get to the last few persons. And maybe he also forget in which position he was after that magical jump? Is there a way to keep the position in the portal? Maybee fetching the status which position or row I clicked in the portal, and then jumping to the calculated positin instead of the normal first position?…

I have a portal in which I click on the client's name and it bring up the clients profile on the same layout. However, the portal then resets to the top each time where as I would like it to stay where it is. The portal is sorted by the client's last names. For instance, when I click on John Smith, my portal goes all the back to A's instead of staying in the S's. My portal is set up through a self-join relationship Clients Profile to Client List. I then use GTRR to get from the portal to the profile. Any ideas on how to keep the portal still? Thanks for any comments.

Hello: I have a portal that displays various amounts on each portal row say $50, $25, $100 etc. And I have a summary field that is outside the portal on the layout that totals the 3 records so the summary field will have $175 in my example. When I add a line - I do this thru a new window with a field that allows the user to enter an amount. After exiting that window the line appears in the portal -- fine BUT the summary field does not update. I use a Refresh Window command but the summary field will still not update. If, however, I click anywhere on the layout the summary field then updates to the correct amount. Is there a way to refresh that field without hav…

Hi, I asked a similar question to this before but now I have an example. I have two portals, one is behaving the way I want and one isn't. When a portal row has no data, I don't want the static elements (in this case some boxes, slashes and the word Staff) to appear in the first empty row. What controls this? I have attached a picture of the two portals. Thanks, Matt

Value list not updated until leaving portal - any way to do this?? I think it is a COMMIT RECORD, but how to automagically implement so the user does not have to click button?? 1st TO - Company 2nd TO - Business Card (All the typical field from a business card, used to collect multiple contacts at a single company) 2nd TO BizCard::fk_Company_ID related to TO COMPANY::Company_ID; allow create on from COMPANY 3rd TO BizCard MATCHFIELD (Source TO BizCard), where NAME is related to 1st TO COMPANY::MATCHPERSON; allow create on from COMPANY Portal on COMPANY layout 3rd TO BizCard MATCHFIELD, no scroll bar Value List NAME, from 2nd TO, related to 1st T…

Gday all! This is a bit of a strange one, so I wasn't sure which section to put this under... OK - I have two layouts that are both 'showing records from' "VEHICLE DATABASE". On one layout is a "PAYMENTS" portal and on the other is an "INVOICES" portal. Essentially when ANY payment is made by a customer is gets added to the PAYMENTS portal. Maybe half of all payments need to be referenced to an invoice, so I have a drop down list in the payments portal so people call select the invoice number. What I want to know is - Is there a way whereby when somebody selects an invoice in the PAYMENT portal, there's a way of updating the INVOICE with the payment …

I have my database setup right now consisting of 3 tables: Autohire, Notice, and Main. My overall goal is to have my layout relating to Main be my main page consisting of a portal and a few buttons. The buttons I can worry about later, right now my current goal is to get the portal working. In the portal I want it to display information from Autohire. Autohire consists of different information. The two items I'm only really concerned about display in the portal are the fields recordnumber (which is a number field that enters an auto-enter serial number), and title (which is a text field so that a user can enter in a title of a job position). In the Main tabl…

Using Filemaker Pro 9 I have a file with about 150,000 customer records. I want to have a portal that shows me the states customers reside. Currently, the portal shows every records state. Then I would like to show the number of records per state. Any advise would be much appreciated.

Can anybody point me to a solution where there is a layout with several portals across (3-4) and with each click moving from left to right the next portal fills with the options related to the first. Basically, I would like to implement something like this as a user-friendly way to create reports or lists with the search criteria laid out for the user to select. Ideally, the first portal would be where the data comes from like Institutions, Students, Courses, Budgets, etc. Then each sequential portal would have the options relative to the original table. So my thoughts laid out would be something like: Students->Year->University->(speci…

I know there is no direct way to rotate a portal 90 degrees, but anyone seen either a work-around or a way to simulate the effect. i am trying to use related data in a columnar report and need the portal to show the keys or legends of the portal rows.

I would like to know if it is possible to have a found set of records in a portal for a related record? EXAMPLE: (Table1 = Service Calls, Table2 = Employees) On Table2 there is employee info with a portal that displays all the service calls made by each employee. (This part works fine) The problem I'm having is when I try to do a find to see the service calls for a particular employee within a given date range. It seems to be returning all service calls, not just the service calls for that particular employee. (This strange due to the fact that when all records are shown, the portal only shows service calls related to the specific employee) Any help would be greatly appre…

I want to display the total contacts for each company but I don't know how to do it. Could anyone help me? Thanks. PS: if a contact change to the different company, the result of total contacts must change to. Thanks James Total_contacts.zip

Hello! In a multi portal layout, when I run another script, I can keep a portal row visible in a 10 line portal even if it is the 25th record, with the Go to Object/Go to Portal Row steps. The only thing is that it puts that portal row at the bottom of the portal. Is there any way to "freeze" it, so the user is always looking his record in the line of the portal that it originally was? I hope you understand what I mean. TIA.

I am creating a FM7 database to manage projects handled by our in-house design group. I'm using portals to capture time and materials used on each job record, and creating an invoice layout that uses copies of those same portals to show what resources were used, along with the associated costs. Since both billing and time data need to appear on the same single page invoice, and the number of records in the portals usually exceed the available space, I would like the portal to return a summary of the total quantity of items used (per item) or the hours worked (per staff member). It currently looks like this (sorry 0 the html post is killing the spaces - name is in one c…

I am creating a FM7 database to manage projects handled by our in-house printing department. I'm using portals to capture materials used on each job record. I would like to create a lookup table so that when the choose an item from the value list it auto-enters a specific item cost into the appropriate field. The FM7 help is pretty thin on how to create lookups. What I have been able to do seems to pull only the value from the first record in the portal. Can anyone give me some pointers? I'm stuck... Thanks in advance, Jen

Hello. My layout consists of a portal on a table alias NAVIGATION. it's an alias for DATA which is the layout table too. I linked navigation to data on STATUS = cPORTAL_FILTER Portal Filter is a global field. I placed data.portal_filter on the form. Going to brouwse mode show an empty portal. Only if I enter something in cPORTAL_FILTER I get a message that the field isn't editable. There is also a link on the tables on order id so when clicking in the portal the clicked record is displayed.

I'm using a variation of Ray Cologon's Portal Sidebar Navigation System. I added a navigation bar at the bottom of the portal. My problem is that in order to get the portal line item to show the related record in the main screen there is a container field with a script step attached to GTRR. So when I click on the portal row it activates the GTRR and shows the related record. However, when I click on 'Next' or 'Previous' on the navigation bar it only goes to the next portal row, but does not activate the GTRR. I tried a script with a script parameter to mimic this, but, I get unreliable results. Any ideas how I can accomplish this?

I am very new to FM9. I would like to display on a main page all the records from a table called jobsheets. I thik I need to use a portal but on trying it as not worked. I just get a blank table. Can anyone help me out please or point me in the right direction.

Hi! I'm new to FM Pro and i'm having a problem that when i try to create a new Portal in my Workflow layout, it suddenly desapears! I make all the necessary connections and relations but when i change from layout mode to browse mode it desapears! Please, help me! I'll be glad! Thanks! :

I have a portal that show me records from my main DB. We are a printing company and I use it to show me all of the jobs that are printing on a certain kind of paper. So in my header, I choose a paper type and the portal displays all records which match. Each record in the portal also shows me how many sheets I need. I want to find a way to total all of thos sheets via the portal. Is this possible?

I have a list of transactions showing in a portal with date, document number and simple invoice value - not calculated. How can I get the list to show a blank new record? At present it only shows the list of previous transactions and allows editing or deleting.

Is this possible perhaps using the GetLayoutObjectAttribute function? ie Table Occurance Relationship (squid) Business => PortalFilter => ProjectsDate Layout based on Business has portal named 01 for example. PortalFilter Table has field which uses GetLayoutObject calc to find out which portal it is in (this is the hard (impossible?) bit...) and then adds it to date. So field = portal number + TodaysDate. Relationship to Projects is based on above calc field. So I can use this single relationship to display different records from same table occurance based on the portal object name... If I could get a portal record to identify…

Hi everyone! I'm using a portal to manage my members of staff who work for me like: assistants, makeup artists, producers, etc. I have two fields in this portal called "Type"(drop-down menu) and "Name"(drop-down menu) which means that in the"Type" field i'm placing the type of staff (makeup, producer, etc.), and in the "Name" field i'm placing the name of the staff related to that type of work. Now, i do have a table just for my staffs registration, and what i want to do is; when i select the type of work in the "Type" field, in the "Name" field would appear only the names related to that type of work. For example: If i select in the "Type" field "Producer", when i'…

I have a portal which displays data from [use] table with fields "propertyID" "Line#" "Code" "Size" sorted by Line number. Line# Code Size 01 5000 400 02 8000 100 03 3000 85 04 8000 250 In a second table [uSECODES] I have fields "Code" and "Description". Code Description 3000 descr a 4000 descr b 5000 descr c 6000 descr d 7000 descr e 8000 descr f ... ... I want to display the description of the code in the above mentioned portal so it would be something like this Line# Code Description Size 01 5000 Descr c 400 02 8000 Descr f 100 03 3000 Descr a …

I'm working on an Invoicing solution and I'm trying to decide between displaying Invoice Items (a table of labor and materials consolidated for reporting) in a portal or in a list view layout. Items are added to an Invoice from a floating menu of billable items. I need to Display the Items that have been added to the Invoice. I would like to retain the easy searching and sorting, and potential dual use of the List View layout as a Reporting layout, but I haven't come across any elegant solutions for auto-updating the displayed found set when Invoice Items are added. In short, I'd like to get a list view layout to act like a Portal showing only related re…

I've created a multi-multi relalionship through a join portal. There are 3 tables: Patient Patientairway Airway The meaning is to select 1 or more airway devices and add them to the patientairway table. I tried to do this through by making a portal for the airway devices to have a list to pick from. Then using a script to add them to the patientairway portal. The problem is to get to the portals populated. Does somebody have a solution for this or an easier way? Thanks portal.fp7.zip

I have a Tab controlled by lets say Project"TV0509" This project number is linked and input in the tab from the main layout. Now, the portal is linked to the tab by the Above project number with a Mix# added in the tab layout. So lets say the Portal is linked to the tab by "TV05091" then When I want to add another mix to the tab I start a new record and name it mix 2 which would change the "TV05091" to "TV05092" now my totals change in the tab accordingly but,the problem is, The portal line items still show mix1 and mix2 at the same time in the list. How can mix 2 show in the portal when the tab is in mix one. There is no logical connections between the two? To my logic w…

I have a file that relates customers to products. Products ordered show on the customer table in a portal. Is there a way to copy a customers product list from Day#1 to Day#2, since customers often repeat their product choices. Copy the portal contents of Day#1 to Day#2? Any help is appreciated!

Long time FileMaker user, first time trying to create a portal... Need: Show up to four picture or movie clips in one database from a separate media database that has one picture or movie clip in a single container field in each record with it's own ID number. Have: Media database with single picture or movie clip in a container field in each record with a unique media ID number : How do I get the one database to show various pictures from the media database by entering the media ID numbers… I can supply the two database files if needed. Thank you in advance for any help…

I am using a scripted button to create a new portal record which then takes the user to a specified field in that portal--ready to enter their data. Everthing worked dandy in FM6. (I am working on the newly converted files in FM8.5) I understand the use of a commit record script step and have used it to instantly refresh the portal. However, when the new portal record is created and comitted, up pops a validation error message. The old version (sans commit) put them into the field, let them enter data, and properly triggered the validation when they attempted to leave the record. The new version prematurely triggers the validation through the commit recor…

Hello, I'm have multiple inventory items (records) in a portal and they have prices, but I would like to add something outside the portal in the same layout to total up the multiple inventory prices. How would I got about this? I have attached a picture to show what I'm doing.

I am trying to figure out how to transfer data from one portal, to a different one. its for a todo list i have as a portal, when its completed they click the delete button, and i want it to transfer that data to a journal. on the todo list i have date, contact, info, and notes. i thought i had a solution, which was when you click the delete button, it performs a series of copy and pastes into the journals notes section. but i soon found out that it failed because it wouldnt take all the data from the correct row in the portal.. anyhelp would be appreciated!

I'm trying to produce a printout of an invoice. The makeup of the data is a single record for the invoice header (i.e. customer information and subtotal, taxes, shipping, and total) and 1 to many records in the invoice detail. On the entry screen I am using a portal with no limit to the number of rows which can be printed. Based on print sizes that have been selected, if there are less than 20 item lines on the invoice, I can print it all on one page. However if there are more than 20 item lines I need to break to multiple pages. If that is the case, I want to leave the subtotal, taxes, shipping, and total fields empty on the first page, and have them printed o…

Hello every one, I have this problem with my portal, hoping that you can shed some light. one of the field in my portal is displaying twice, first line and second line, and if I try to delete the second line, then the content of the first line also got deleted. I tried to recreated the portal but the same thing happened. Hope that I have explained myself clearly. Thanks for the help. Michael T

So, thanks to the help of Comment, I was able to take the records I had stupidly made with repeating fields, and populated a new table by dividing out the repetitions as separate records. I am back to my original layout, where I am going to strip out the repeating fields and replace with a portal. Of course, I tested the portal before finalizing the layout. However, in the portal, it only shows the first record. So, for example, in the repeating fields, I have 4 repetitions. In the new table I created by copying & importing the records, I have 4 separate records, 1 per repetition. However, on the portal, it only shows the first of the four. I have the portal se…

I have a portal that is sorted based on a one-digit field that, occasionally, can contain an Exception Code (A, B, C, etc.). The portal uses a "custom order based on value list" to place the entries with Exception Codes (6 different ones) at the bottom, like footnotes. Any entry with a blank sorts to the middle of the pack. The value list is 1, 2, 3, ... 9, , A, B, C, D, E, F This has worked great, so far. But now I'm faced with having to support decimal fractions instead of just integers. The following is an example of what I now need the portal to look like: 1.11 1.74 2.01 2.42 A B D So my question is: is there a way to define a cu…

I am not sure where to look for this scenario as I am brain dead again today... I have a table, copied it in relationships and made the relationship "date = date" allow adding in both. Now I added the portal in the layout. Now when I need to add a line in the portal, I start typing in the fields in the portal and a new line should appear, and it does, however, it also creates a whole new record rather than just making the fields in the portal hold the data. I end up with 2 records, but only want one record with the multi line data in the portal. It is a time sheet, so if I do 3 jobs, I want them to show on 3 portal lines not 3 records as well as portal lines. Where a…

Hello all, I'm new to FMP, but not to db programming, and am having a hard time doing something that's pretty easy in other programs. I've read the "User's Guide", but that's decidedly elementary; I've searched, but I guess I need to get the hang of the jargon. It's an artwork database, in which depicted characters depicted could conceivably show up in hundreds of artworks. Because of this, I put those names in one table, and created another table for the artwork/character relationships. The db schematic for the relevant tables & fields: Artwork - ID (auto-serial) Global Characters - ID (auto-serial) - Name (text) Record Characters …

I am making a Contacts database consisting of: 1. Contacts: People's names and contact details (just phone and email) plus the company they work for. 2. Companies: Address, phone, website and a portal showing people who work for this company (related to the 'Contacts' table). I'm trying to do two things but failing spectacularly. 1. On the 'Companies' table (with the portal) I have a button for people to add a new 'Contact'. It's just a script that goes to the 'Contacts' layout and makes a new record. However I want it to set the field on the 'Contacts' table to show the company name from which I clicked the 'Add Contact' button. Does that makes sense? …

I have read post after post prior to posting this so hopefully I can prevent from being flamed. I have a portal setup to display sub items. It works great. Now I am trying to filter out all the rows that have a quantity (field quantity) of zero. I tried a table with the field in it and then set a relationship to my portal records quantity but it does not do anything. I also tried putting a field in the related (parent) table and then putting it in the relationship. Well it works except it will only allow me you enter in the portal quantity field the value that is in the parent record (I am sure that has to do with the relationship forcing the value) Does anyone kn…

I am trying to write a script where duplicate dates in a portal are deleted. For example I have a database of people and related table of Attendance dates. Sometimes through an automated process, duplicated dates might get entered in a person's record in the portal. Is there a way to have a script that automatically finds those duplicates in the portal for that one person and deletes the duplicate dates? This could be a sub-script that is incorporated with the script that records the attendance in that portal field. Thank you.

I'm doing my best to 'professionalize' my designs, trying to hearken to the advice I gleaned from the White Paper for Novices, so it's time for me to shed the Status Area in my layouts. This is probably a really simple question, but how do I find the information for the Records counts -- total # of records / Records in Found Set, and the Current Record number? It seems like these would probably be gotten from some Caluculation functions -- and put in, maybe global fields? I've poked around and can't seem to find what I need. THanks Albert

I created a layout with portals from relationships with two criteria (ClientID and SlotUsed, between Client table and Prescription table). Works great. Needed the same layout involving another table (Client table and OTC table), so I did for it what I did for the other. I have checked the variables, the relationships, the layout, and everything matches. Except, nothing in these new portals show on OTC layout. You can't even click into the fields (yes, I have browse checked in the behavior). I duplicated the layout, changed the portal to the corresponding OTC verison, the variables to the corresponding OTC version. Prescription layout Layout based on: Cl…

How can I sort records in a portal so it recognises the number (as a whole number) inputted and not just the first number. i.e Sort order should be 6 8 20 100 [color:red]Not 100 6 8 20

I have a portal in a layout which pulls events from our calendar database. I want to be able to limit the portal to only pull the next 5 events listed. I have the portal setup to filter only events from today's date onward and can set it up so that I can get the next ten days, but I think only seeing the next five events would be clearer for users. I know I can setup the portal so you only see five rows and hide the scroll bar, but I'm setting it up for custom web publishing which ignores the portal viewing settings and displays all the records. Any help would be appreciated. jon

To allow entry of different types of products into the same inventory table from the same parent (one invoice from a supplier), I have created multiple portals to the inventory table: (Diamonds, Emeralds, Rubies, etc.), each on a different tab. Also on the same layout, I have a simple portal that shows all the items, regardless of type, so the user can see all entries in a list. What I want to do is be able to place a button in the general portal that will then open the appropriate tab and go to the correct portal row for that item. I've got the first part, through an If-Else If-Else If structure, with Goto Object and named tabs. But whenever I try to go to a fi…

I am a newbie for FileMaker. When I check for scroll bars in the portal setup dialog they don't show up on the interface. But if click in the corners, the I can scroll down. I just cannot see the scroll bars. Users will not know that there are scroll bars. I am using FileMaekr 8 version 3. Thanks for any help.

Following the recurrent sound advice on this forum I’m trying to convert all my repeating fields into properly related tables, but I’ve run into a problem. I have two main tables: Courses and Staff, which I want to join in a many-to-many relation so that eventually I can see which staff will be teaching which courses (from the Staff layout) and which courses will be taught by which staff (from the Courses layout.) Record creation needs to work in both directions. I know the basic principle of how to do that by creating two one-to-many relations through multiple table occurrences. But the intervening variable is Timeslots. Each Course may run in a number of di…

Ok so i have a Inventory of certain items. Within my layout i have information about the items. Then i have a portal showing related items. I have a Self relationship to display the portal. I am trying to make it so that you can click the portal row and go directly to that record. Ive tried most of the basic stuff its probably somthing simple i have over looked. Thanks ao

Hi, Quick description first. I have a Loans database. There are three tables: Loans, Loan Line Items and Items. Loans has a portal to Loan Line Items which does a lookup to Items. Each Item has a status: Available, Not Available, Reserved. Here is the question...as I enter an item in the Loan Line Items portal, is there a way to get immediate feedback as to the status of the item (beyond just having the field there). For instance, a dialog that says "This item is reserved you can't loan it" and then have the item removed from the portal? What would be the best way to accomplish this behavior? Thanks, Matt

Hi guys, I've got a portal with about three records in it. But there is a blank extra row also available under the three records where a user could input a record etc. I wish to remove this and force the user to click on a New Record button. Is this possible with Portals? Thanks, Sully

Since I'm a beginner with FM, I attempted to use one of the build-in templates for my purposes (the template is Education - Administration -> Registration). I chose the template because it has a portal each on two different layouts (connected to two different tables) and basically the portal on layout A shows records from table B and the portal on layout B shows records from table A. I'm really sorry if this sounds all like gibberish, I'm only beginning to grasp FM. | When adjusting the template to my purposes, I must have made one or several mistakes. Now the first problem is, choosing a certain row (via a button with a script) in the portal on layout A will…

I have a Layout with two portals I have each portal set up to "allow deletion of portal records" I have a trash can button on each portal line with the button setup set to "Records" and "Delete POrtal Row" I have this exact same setup on other layouts that work perfectly, it delets the portal row. On the other hand one portal works fine where the other delets the whole record from the main layout and the informat in the other portal as well. I have checked the setting quite a few times and they are all the same. Can anyone help??? The Tramp

WinXP FMP9A Time billing database. Each record is a month with a portal listing the date, project, activity, hrs billed, amount. I’d like to have fields that show (on each record/month) outside the portal the total hrs billed for the month for each activity. Not sure how to do this. Hope you can help. TIA

Can you remove the lines in a portal? Thanks ao

Ok, I have a layout with data. It was 10 fields for text input. I have a check mark next to each field to change the color of the field when there is something that I need to be warned about. I would like to create a summary page that will only list the fields that I have set the conditionals (check marks) for. What would be the best way to do this? Portals would show all of them. I only want the ones that I've marked. Thanks.

Hi I'm trying to create a layout using two related tables. I want the parent table to display the clients info. I want the child table to display the booking(s) the client has made with the ability to add new bookings. The problem is the contract info contains 45 fields way to many to display in a portal without using hrizontal scroll bars. So my question is how can I get this to work?

Can containers (in this case pictures) be placed into portals in fmp9? If so, would the picture size down to the container field size or would the picture be occluded if the container wasn't the same size. I'm thinking about how different sized pictures in the portal would work.