Portals

2 databases related thru a ID#. Main database has portal linking to the second database. As it should, when I click in a blank portal field in the Main database, a record is created in the second related database with a matching ID#. Here is a twist...Is there anyway to click in a empty portal, and instead if it creating just one record with a matching ID# in the related database, can it create 8 of them. Reason I ask this is I almost always created 8 records thru the portal. And instead of always having to click the last empty line in the portal to generate the next line/record, I would just like it to start of from the git go with 8 blank lines/rec…

I'm goign to set up a DB with a 4 part category selection. Part 1 will result in different subcategories in part 2, 2 in 3, and 3 in 4. What would be the best way to do this. Not all the categories go 4 deep, and the last one will have a category number assigned to it. Thanks -j

I have read some place, printing problems with "Portal"... I have a new feature in my solution, I change repeating fields with a portal... The thing is: I have a list (2 rows) for each dataline for AirConditionning equipment, most customer can fit in one page... but with shopping mail and 250 units.... that can be a problem.... I have try it, it will be a NCR 3 copys on a dots printers, I have done some test on a HP Laser, and I have some cuts in between pages... FM always gave me some problems with printing (long story short, no one ever return any message on news group about my problem)... So in my layout, I have on top from releated records n…

Here's my sitch... Call Tracking Customer Service DB I have two files: Clients and Parts Many clients and many part #'s In the Clients file, I have part #'s and descriptions in a portal from Parts file. If someone enters a new call record and enters an existing part #, I need the unique description that is connected to that part # to fill in automatically. Thanks in advance. Matt

I am using FMP 5.5v2 in OSX and have noticed on occassion that after entering an record in a portal file that the entry is invisible when viewed through the portal. I don't think I've ever come across this in OS9 versions. Example: Customer & Invoice files-after adding a new invoice through an invoice script, it is not seen in the portal from the customer file until after closing the customer record and reopening it as though the portal is not updating its contents until after the customer record is closed and re-opened.

Hi there. This is a weird one, so bare with me ... Take at look at this screenshot as http://www.stevegriff.com/filemaker.jpg As you can see, the text box contents for some reason goes behind the portal... is there anyway of getting round this and get it to appear above the portal? Thanxs Steve Griff

I'm a new FM Developer and so my terminology won't be right at this time, but I'm working on it. What I would like to do is be able to have one screen where I put in a client's name and somewhere on the same screen will be a box of some sort where all the reports that have been submitted from him will show up without me having to go and hunt them down. Can this be done? I'm not sure what to do. If this doesn't make sense, I would be happy to try and explain another way. Thanks in advance! Mish

Hello, My trouble spot today: My portal contains street, city, and phone. In the main db I need to build a calc field that brings all the rows together into one text field. row 1 - street, city phone row 2 - street, city phone . . . Is there a way to do this? (like GetPortalRowNumber?) Thanks, Steve

I was wondering if anyone knows how to compare data within a portal. For example, I need to compare a numeric figure from the most current row in the portal to the previous row. If the number increases I need to prompt the user with a message. Any input would be greatly appreciated. Thanks!!

I have 2 files(custinfo & rundate) linked by customer number, portal displays one record, the first in rundate, no matter how it(rundate) is sorted. I want portal to display last rundate, no the first. Any ideas.

I'm a new user of FileMaker Pro 5.5 and have a question on filtering inside of Portals. I've read a few postings on it but for some reason I'm not getting it. Here is the details: I have an Orders data file with years of data in it and I'm needing to invoice out of that file. I've created an invoice data file and I'm using a customer no. in both files as my relationship to tie them together sorting them by date descending. The portal shows all files from orders O.K. and I would like to be able to do the following: Pull up only files in a date range i.e. startdate and enddate Be able to tag those records once they've been invoiced (o…

Help, I have 2 files: 1 called "Jobs" that contains specific job information. Including a portal to a file called "jobItems". No problem here. The other file is called "Invoice" and contains billing information for each job, also with a portal to the same file called "jobItems" where a user will check a box when the itam is invoiced. So, the 2 seperate files need to display the same portal. At one point, i got it to work, but was not able to create multiple invoices for the same job with the same set of "jobItems" and the same job number. Here's what I think is involved relationshipwise: Jobs - jobItems = 1 - many Jobs - Invoice …

Hello everyone!. I'm a novice with FM, and I experiencing the following problem: I loaded a database on the web and configure it with the Instant Web Publishing Interface and noticed that images don

Hello Forgive me for asking such a simple question. But I just don't understand portal basics. (And further more I use a swedish copy of FM 4.1, headache...) I am planning a small database. Maybe no more than 50 records. Each record will contain something like a title, an abstract and keywords. Each abstract is, of course, uniquely connected to its title. But the keywords may (or may not) be related to more than one record. I see no upper limit to how many keywords each record may contain, though it's not likely that each record will contain more than 5 of them. Repeated fields seems to be a stupid thing, only thing sillier is me who just don't get it. Ho…

We are using FM to run our real estate office including preparation of contracts of sale. A contract can have several "condition clauses" The contract clauses are in another file with a clause number. In the contract there is place for several clauses which the user enters a number for each and the assocaiated clause is shown on the contract. Problem is the user needs to know what clause number to use. What I want to be able to do is allow users to scroll through the clauses until they find the one thay want and then "select it" to be entered into the contract. I have played with displaying the clauses in a portal and that works but don't know how to have the…

Hello Is there a way to have a portal "stick in postion" instead of always scrolling back up to the first row all the time? Thanks

hello, i have not worked with portals that much, for that, i am at newbie level. here is my setup. i have an invoicing, clients, and contacts db. on the clients db i have 3 layouts (info, contacts, and projects). on the projects layout i only want to show the related projects for the client. i also need to do the same thing with the contacts layout, only show the contacts for the spacific client, but i want to get the projects one done first. i have the portal setup for the projects (sorta). my relationship is setup for Account ID: Account ID to invoice.fp5. everything shows up great. but when i click on a button in the portal i have defined as Go To R…

This is sort of portal related, so i'll try here. I'm trying to get from a layout in one file to a particular layout in another file. The second file is the many in a one ot many portal. Normally i'd do the "show related record" but the layout in the other file is just a menu, w/ no data being shown. What's the best way to do this? -j

Greetings, I have several years worth of records in a database. I have a self join that allows me to browse and get summary data based on the "category" field. Unfortunately the portal brings back several years worth of data. Is it possible to set up a portal so that the records match the "category" *and* satisfy a time constraint ( say,for example, for the current year...). Each of the records contain a "date" field. Thanks, Gray Fox

I have 1 file with a list of Purchase Orders that I want to view in a portal. I have a self join relationship of record no to record no The portal is set to show 5 records, but it only shows the current record. The fields all seem to be correct ... Please help. Thanks. Jack

I guess I misunderstood what a portal is an what a porta could do. I viewed a portal as another table (file) and that you could set a portal up as a table (sub-table) inside of a table and that one could then directly enter records into that sub-table. So far, I'm only able to use a portal to display related records. Is there a way to enter new records into a portal while it is being displayed on the main layout? What am I missing??? Thank you

Hello, I'd like to set up a portal and put all my stuff from the repeating field I have into it. How is this done? I've created a portal, related it to another table, but I don't see how to pull all the data from the repeating field into the portal....

I have a portal for inputing checks and when we make a partial payment we input that into the portal. Paid date, check number, amt. paid & running total that subtracts each time we input a check. so when we totally pay up. The running total reaches 0. Can anyone help me with this. Thanks

A selected portal in my invoicing db is printing sporadically or rather "on top" of the page hiding all of the line graphics behind the portal and extends down into the non portal area. I have been able to reformat the portal and it goes a way for a day and then is back the next. I can move the "infected" portal to the extreme right (off the page) and the invoice will print correctly. This has just started in the last 2 weeks along with an intermitent and sporadic bolding of characters within fields. Does anyone have any similar experience and what is the solution to correcting the error? (We don't allow duplicate posts of the same question. I'm closing this …

can you have a portal within a portal by this i mean i have company database within which i want to show their orders (which is fine) done in a portal i can show all of their orders. BUT each order has a list of order items stored in a file related to the order file. in the order file i have a a portal showing a list of all the items in the order (great) i basically want to show the list of order items in the company file is it possible and has any of this made sense the relational scheme goes company----<orders -----<items [ April 09, 2002, 07:48 AM: Message edited by: thewalker ]

Hi all, I need to know how many row there is in my portal. I seem to remember doing this somehow easily a couple of years ago... I was surprised to find that there is no such thing as Status(PortalRowCount). Can anyone recommend a method ? I could do it with a script but I swear I once got a calculation field to report the number of portal rows....I might just be missing something obvious... Thanks ------------------------------- I knew I was missing something obvious... For future refference : The way to count the number of portal row is by using the Count(field...) function (in aggregate functions) to count one of the related field…

I am working with two related files: Employees, which contains all general information about the employees, and Job Entries, which contains all of the job-related information for each employee (contract dates and renewals, position titles, department, manager, etc.). In my Employee file, I have a layout called "Job Entry-Update" that contains a portal to view all related job entries for that employee and allows the creation of a new entry to record contract renewals or merit increases. The portal is based on a relationship called Job Entry with the related fields being Filename::Filename. This portal is set to allow creation of related records. This portal works…

Hi guys, I am wandering if it's possible to view the "many side" of the relationship in the portal without normalizing the file into two files. What I mean is: I have a file called companies, which also has employees in it. I know this is not the right way to do things, but let's just say that's the situation. There are several employees in each company. Is there a trick with selfjoin to view all the employees per each company in a portal? Thank you

I am using a portal to create an invoice. Sometimes the invoice is several pages and sometimes it is only one. Is there a way to automate it so that it will print all the information without going into layout mode each time? Mindy

Hello I haven't been able to figure out sorting records in a portal based on a value list when defining the relationship. I want to sort the records in the portal on any field in the portal. Is that that what a value list is used for in that situation? If I don't specify which field to sort related records on, the portal always displays them in serial record order. I want them sorted by DueDate, CustomerName or DocketNumber. As well I would like to filter them based on the contents of one field. I am completely lost on this one. Thanks for your help.

If a certain value occurs in the child record, I need the parent of it do be duplicated, and a few fields changed. Unfortunatly I can't get over to the parent file to do this via a script. Right now i'm having to set a field that is accessible by both, and then search for it in the parent file and update. Is there an easier way? Thanks -j

Hello I have a parent Work Order data base with a child data base showing in a portal that shows only the work orders currently being worked on. I have a button on the portal row that I want to use as a find to navigate back to the proper parent? Thanks for your help.

I have several portals on the same page. If I have a script that says go to Portal Row #1, it always goes to the top row of the first portal. How can I tell it to go to the first row of the other portals? I have used several combinations of Go to Field... and Go to Portal Row... script steps. It always goes to the correct field but then goes to the correct row on the wrong portal. This is very confusing. Any suggestions?

I have a database that stores rentable products I want to show a diary split into items going out and items coming back. Booking Ref Customer Date Out Time Booking Ref Customer Date In Time Hope this makes sense. Thanks

I have a file with day names and I want to force them in a specific portal row in the related file. Monday on row 1, thuesday on 2 etc.... If monday doesn't exist I want the portalrow to be empty. Any tips ?

Hello everybody, I have a portal question: I am making a database for this particular question 3 tables are important: 1. Table items : 1 item consist of different vendorjobs (relation 1-n) 2. Table vendorjobs : here we have the name of the job, start date, end date, etc 3. Table Vendor : 1 vendor can do more vendorjobs (1-n) What I have now. In the table items I have a portal with all the vendorjobs in it. The name of the job, the dates and the vendorname. The vendorname is actually a value list with all the vendors in. (linked with vendors) What I want to do is : I want to add a field called vendor function in the table vendor. …

This solution worked perfectly thanks. The search is much faster too...

I a trying to write a script that will simply create a new record in a portal. The portal is a payment database that records payments made by date, type, and amount. To save time keying, I want to use buttons that say 'cash payment', the script would create a new record in the portal row, then add the date, the type, and simply ask the user to enter the amount. Thanks

I'm trying to find a way to perform two actions in one script: Action 1(Already works): Search for all records w/in a specific date range and that contain a certain critera within each records portal. Action 2(The problem): Once I know how many cases there are that meet this critera I want to know how many of the portal rows within each case have a certain criteria. I actually need the number (i.e. portal for record 1 contains 5 occurances of a particular word, record 2 contains 1, and so on for each record in the set I've found). There is probably a much easier way to do this than what I'm doing so any help is appreciated.

Hi Alison You don't need to write a script. You can use SPECIFY BUTTON to simply GO TO RELATED RECORD (same relationship as your portal) A button placed in the row should pose no problem - a nice way of keeping your portal clean is to make the Executive Name field the button - therefore clicking the name field will take you directly to that record. You only need to place the button in the top row (in Layout Mode) and it will repeat for every portal row in Browse Mode. Cheers! - Pete [ February 28, 2002, 01:06 PM: Message edited by: Peter Fenner ]

I created a portal to keep track of clients who check in. Each time a client checks in, a date and time are logged. I want to be able to delete a portal row by clicking on a small bin placed in the portal row. I looked up the bin with this script: Delete portal row. But it didn't delete the log. Any idea? Bikeman17

Is there a way/trick to make 2 fields scroll together? The issue concerns a main file and 1 related file (1 on 1 relation). I need to display 2 of the related text fields next to each other in the main file, the difficulty is that the height of the text entries vary(together). I know I can put a vertical scroll bar on text fields but I would like to have the 2 fields scroll together. I may well be looking the wrong way, I'm open for any suggestion.

Shouldn't you have the completed part of the compund key in your primary calc as well. Or rather, what is not completed Otherwise, you can never trap for that.

I have created an invoice file (parent) that pulls the orders (children) associated with each invoice into it via a portal. Is there a way to summarize the fields in the portal and perform a count on them? (i.e. if there are 15 children and 3 of them are named Sam, show the name Sam only once and the count as 3).

is there a way to skip a field in the line when the tab is pressed. for example...i have a couple of fields in a portal that will be fixed based on the first entry the user inputs before going to the portal... So i would like to hide that particular field and not have it "tab"able when the user inputs the other fields... is there a way to make this field not show and not be "tab"able thanks

Is there anyway to prevent the portal background from changing colors when a user clicks within the portal but not in a field?

I've been able to figure out how to display a portal based on two fields using tech knowledge dbase file 104553... however, i was hoping I would be able to add new records based on the two fields...but because the relationship is based on a calculation, I cannot... I have a database that has about 8 fields and I once someone enters the date and vendor, reference number... I would like them to be able to open a portal based on DATE AND NUMBER and then just have to enter multiple records for client, description, amount (which is based on the date, number, reference #, etc)... is this possible and if so, how? thanks

i have a materials list database that has date, client, quan, description, vendor, unit price Sometime, when we have a bill, i need to split the bill for different clients...what I do now is enter date and vendor and press copy a few times and enter client, quantity, description, price, etc. However, I was wondering there is a way to enter date, vendor and then have a button to click if I need to split bill and a new window opens with client, quantity, description, etc. and I'm able to enter all the clients there...Then when I go back to the materials layout..it shows a separate record for each entry as above... is this possible and if so, how? th…

I've got a setup with the following 3 files, Companies, Contacts and Orders. Contact records contain a Company-ID key. Order records contain a Company-ID and Contact-ID key. Currently I'm showing all Orders for a particular contact in a portal on a Contact-layout. The idea is to show all Orders for the Contact's Company on a Contact-layout so that you can easily see the Orders booked on other Contacts for the same Company. The lookup is simple enough using the Contact-Company-ID and link it to the Order-Company-ID. The question is how can I make orders where the Order-Contact-ID is equal to the current Contact-ID stick out in the portal or maybe sort so t…

Hello, I've set up a portal but no text is shown. It seems like the relation works, because I can select the number of rows that are supposed to be shown. And changes affect the number of lines that are selectable. So why doesn't any text show up?

Hi, hope you can help me. I have a portal in a orders dbase which shows files from another dbase (films), I have a field which is called film id and a relationship to the films dbase via film id. I want to put in the film id in the portal and it will show all the details of that film in the portal. My problem is I need to add more than one record for a film on an order - I have put a tick in allow creation of related records, but it keeps repeating the last film id that was put in. I have seen it mentioned somewhere that i should use line items but I don't know how to set this up. Thanks in advance Roy

Ok. this is a hard one (I think). I have a self-related portal for currency of transaction in invoicing DB (US$ or CA$). I have 'CAD' and 'USD' in globals and used as the primary key to itself, and 2 relations for them. This works fine but I have to be able to show transactions from a date range. I can't think of a way to make a calculation field do this, since it has to be a range of dates. ideas anyone?

First of all, I'd like to thank everybody here for being so helpful! I have been trying to build an invoicing system, and thanks to your help, I've advanced somewhat. I need to know, however how to filter a portal in the invoicing system, AND to sort it. This is the problem: I have an inventory file, with an article ID. The articles in the inventory file have unique serial numbers (within the same article number) and a "best before" date. When selling products, I'd like to enter the article ID in a global field, and a list of the articles with this ID should show up in the portal, sorted by the best before date... Anyone pls tell me how to do this! Thanks …

Is it possible to add a second (or more) condition to what you see in a portal window? Can you have information displayed in a portal that are based on two fields? The first by an invoice number and the second by a category. In other words, I would just like to show records that have the same number and category. I thought it could be figured out simply but it's just not coming to me. Any help (even a hint) would be appreciated. Thanks, Ben

I have a file with two portals in a layout. One of the portals displays hardware and pricing information and the other portal displays line items. I want to be able to select an item from the hardware portal and click a button to add it to the line items portal. Due to FMPro not handling portals very well I can't specify which portal I want to add the data to. How can I script the button to perform the operation? I'm using FMPro 5.5.

Good morning - here i go again On my invoice screen - I have a portal set up to enter my items being purchased. The commission amount is calculated from the information in the portal rows. My delimna is - if I have them enter a FIN(Finance Charge) or ADJ (Adjustment) in the Item Code box of the portal - I do not want this line item to be included in the Comission Calculation. I have the Commission Calulation set up - If(lineitem:item code ="FIN" and "ADJ", 0, SUM(lineitem:item cost). This seems to work for the first line of the portal. But typically - the FIN or ADJ item code is entered farther down the portal entry. How can I have my Commission …

A customer database solution based on a relation between a Company db and a Contact person db. In the main layout of the Company db I have a portal row showing related contact persons of the company. This is the way it should work: Make a new record in the Company db, fill it out, select the first portal row, type in firstname, tab will bring in information from the Company db from a lookup. This doesn't work proberly :-( The information from the Company db should be copied to the Contact person via the lookup when tabing in a new contact person, but only if a) I delete the just typed in entry in the portal and try again, or : if I type in a new entry below…

I have a timesheet dbase where I have placed a comment field for employees to place any comments on a particular client for public viewing...the comments field will be broken down by a type field (design, install, maintain) i have created a portal that sorts the comments so the records that have data in them will show at the top. The problems are: 1. I'd like to only show the non-empty records (there are 800 timesheet records and maybe only 10-15 have comments attached to them) 2. Since the commments are further filed by 3 things (design, install, maintain), if their is an install comment in the design portal, it shows as empty record. So the design…

I have invoicing database that contains a portal to items purchased. Since the store does US and Canadian dollars, each item has a price in both currency in the inventory database. I have the user select which currency for the transaction in the invoice and the lineItems database has a field for the current price, which is auto entered calculated number (price depends if its on sale and its currency) from the inventory DB. My problem is that, usually on the first portal row, since its a auto enter, the lineitem doesn't have the invoiceID to check for the currency or itemID, so it defaults. How can a get around this? make a script that creates a new invoice …

Hello all, I'm wondering if anyone knows of a technique or plug-in that will solve my problem. I need FileMaker to perform "spreadsheet" like calculations in the following way using relations and portals: DatabaseA - Customer List DatabaseB - Each record represents End of Month total sales. I'd like to be able to look at the customer in DatabaseA and see calculations that would represent the % increase/decrease in sales from record to record (which in this case would be month to month) and just for this customer (easily filtered through a portal). I thought this would be easy at first, but I'm now finding that it's going to be a bit more diffic…

i am using two layout with the same portal on how ever on one layout the portal shows a list of five recs and a button to take them to the next layout with the same portal on it only with one row and more detail. i want the user to be able to click on a portal row on the first layout and be taken to the detailed layout but unless i use a side bar this does not work it just goes to the first rec in the portal any ideas it may just be my script set field global 1 to current portal row num goto layout port2 goto portal row by field value global 1 hellppp

Hi, I have a script which loops through all the portals and inserts a calcultated result if the rel files date = todays date. When performing, it will not get off the first portal and go to the next, however if I replace the "insert cal result" with say "set field" or anything else it will work. Can anyone please help me out with this. The script is: code: Go to Portal Row (first) Loop If("RelFile:date = Today") Here is the problem, why? - Insert Calculated Result... End If Go to Portal Row (exit after last, next) End Loop. The "If" is fine so it must be the "Insert Cal", but why, Any ideas? Thanks in advance for any help.

A customer database solution based on a relation between a Company db and a Contact person db. In the main layout of the Company db I have a portal row showing related contact persons of the company. This is the way it should work: Make a new record in the Company db, fill it out, select the first portal row, type in firstname, tab will bring in information from the Company db from a lookup. This doesn't work proberly :-( The information from the Company db should be copied to the Contact person via the lookup when tabing in a new contact person, but only if a) I delete the just typed in entry in the portal and try again, or : if I type in a new entry below…

Hello, I need a little help. I want to setup a web companion enabled database that will allow the user to query the database and get specific results based on the query. However, when the results are presented I want to eliminate any redudant values from the user's view. Here's an example of what I'm trying to do. Go to this web site and select [View Results]. http://www.websource-paper.com/webfinder/index.asp Is this possible. Woul using a portal be the best solution for accomplishing this? Thanks, Kelly

This is probably a stupid question, but I'm a beginner trying to get the hang of Filemaker - hoping to get some help from you experts. I want to construct an inventory/invoicing system consisting of the following databases: Products (basically a static file with all articles that I can sell - they have a part number and a unique serial number) Clients (the clients that I sell these articles to) Inventory (a live database of the articles I presently have at home) Invoicing (the sales that I make - articles are pulled from Inventory to this one and an invoice is printed) The problem I have is with the invoicing part. I have been able to show only the products I…

Hi there all, I'm sitting here going crazy trying to figure this one out! Can anyone tell me how to achieve the following? I have a database called "A" which contains all the serial numbers for any item ID in another db called "B". What I have done is in a third database called "C" made a portal that sees these serial numbers. This is all working fine, all i need to do now is be able to generate a list of the serial numbers in a different field in file C so that I can look into it from another file (D)'s portal. Any advice on how to do this? I've racked my brains! thanks, john.

HI, I have 2 DB (Patients & Letters), I created a relationship to bring the letters to my Patients DB, now, I can't make a portal with a History of all letters sent to a one patient. Each patient can have many letters. Could you help me, please?? TKS Saludos from MEXICO Jorge S.

This really has to be simple to do, I'm missing something.... I have two files: Organizations and Individuals and a join file OrgInd. In the Organizations file each organization has a serial number (OrgSN) and in the Individuals file each person has a serial number (IndSN). So the join file just is a list of OrgSn and IndSN. There is a portal in the Organization file that lists all of the people associated with it and one in the Individuals file that lists all of the Organizations that the person belongs to (and the obvious relationships between the SN's in each file so that the portal works). I want the user to be able to add a person to an organization v…

Hallo I’m a newbie to FM but have worked with other databases earlier. I have reed a lot of the discussions in this forum and think portals may be a solution to my problem but I need a little more information (help). I’m administrator to a database on a FM 5.5 Server with about 15 to 20 users on Mac and PC with FM Pro 5.0. I will store a few thousands persons where every person may have taken up to a hundred different tests. Each test can be taken more than once by each person. Every test will have a first layout with information about the person and when the test has been taken. A second layout will contain the whole test. Which is the best way to build this d…

Hi, Is it possible to use portal to do the following? ITem|Description 1 Test 2 Testing Is it possible to use portal to select which record I want to copy to another related file? If not,any other suggstion? Thank you!

Hi, I have this portal that holds records for 2 companies, say co A and B, I have been trying to get records for one company(only) that would show in onother portal. i have created a self relationship with a global field that holds records for both,the global field relates to a calculation field(text)that contains the name of company.(and created a script-set field(global field,"A") Problem is this is not working..its just producing strange results. Any ideas out there?? thanks anita

I have a job ticketing database that uses a self-join relationship to list all previous tickets for the client. (ClientID=ClientID) I would like to indicate which ticket the user is on by highlighting it within the portal by using a calculation to "get" a highlight graphic. Is there a way to do this without requiring a script to "mark" a record. I would like it to be based completely on calculations so when the user clicks through the records the highlight moves up or down in the portal. I've been trying for a few hours now, but can't seem to find a function that truly shows the ACTIVE record (ID or Number) because when referencing through a portal it only shows it's o…

hello everyone, i am relatively inexperienced with fm but have done a lot of work with msaccess (forgive me please ). i have files for job/item/products with the relationships 1 job to many items. 1 item to many products. i want to select a job and have a portal showing the related items and within the items portal have another portal showing the related products for that item in the portal row. is this possible? any help would be greatly appreciated.

I have a Part Entry file and an Assemblies file. An intermediate file, AssemblyPartJoin, allows me to enter multiple parts per assembly through a portal in Assemblies. In Part Entry, I have a drop down list that shows all of the assemblies that each part is contained in, with a button next to the menu that performs a script to search the Assemblies file for the record matching the assembly in the drop down list. This all works fine. This is where I'm stuck: I don't know how to get the portal row with the Part Number in Part Entry to highlight. In other words, I want to be able to search by discrete part and go to the place in each Assemblies record (each assembly where i…

I have one database file (indiv_master.fp5) that is related to three other database files (indiv_2002.fp5, indiv_2001.fp5, indiv_2000.fp5), with relationships based on the same key for all four databases - and each relationship is named the same as the three database files without the .fp5 (example - indiv_2002).... I want to display info from each database right after each other. I need to be able to do a "loop" where the only thing that changes in the CDML is the year - as the formatting is long and tough to repeat four times - especially when trying to develop and edit the CDML for the page. So - I want to do something like this - but in CDML (or JavaS…

Hi all, I would like to make it possible to view the most recent records in a portal ,say for the past three days,and the portal to be updating itself as the days go by. i've tried doing this using a script but am not getting succesful. i dont want to use a find Because that would mean a user being able to say show all. any ideas? anita

I am wondering if anyone knows a way around the following problem....I have found a way to avoid getting the "So-and-so is modifying this record" message when clicking into a portal while another user is also clicking on a record in the same portal. I did this by creating a separate record for each user. The only remaining time I get the "....is modifying this record" is when someone is scrolling the portal, not even selecting a record in the portal, and another user tries to scroll the same portal. It is very aggravating for myself and my users. Especially for me since I have them on totally different records, but dealing with the same portal.

Hi Forum, I hope you can help me with this problem, I have 2 tables "Films" and "Orders". On my orders table I have 8 fields where you can put in the film id and the info will appear as we sometimes have to send out more than 1 film (I had to create a relantionship 8 times). What I wanted to do is have a portal in the films layout that could show where this film had gone etc.., but in the portal I can only put the 1 set of fields from 1 relantionship not the 8. Any ideas? Regards Roy

I've got multiple portals which relate to a scheduling database. Each portal shows what is scheduled to be printed on what day. This much works fine. If you change the date or any other data in the portal item, the change is reflected. However, what I'd like to do is put buttons in that allow the user to click a "+" or "-" to move the item forward or backward by a day. Unfortunately, once a button is clicked, it somehow locks itself to the record first modified, even if that record is now in another portal! What have I done wrong? thanks, Stanley

Hi all. I'm not sure if this is possible but I'm hoping one of you gurus out there can confirm. I have a portal in DB1 which displays the contents from DB2 based on a shared ID. When you type in any given ID the portal will show the following wherever there is an ID match. Portal-Row-1 DB2_Field_A DB2_Field_B DB2_Field_C Portal-Row-2 DB2_Field_A DB2_Field_B DB2_Field_C Portal-Row-3 DB2_Field_A DB2_Field_B DB2_Field_C Etc... Nothing fancy and it works fine but the only trouble is it shows all records that match the ID and I want to be able to show a subset based on a user selection. Is there a way t…

It maybe that my file structure is completely wrong, but I need to figure this out and change my file structure if necessary. Here's what I have: 3 files - Events, Lists, and Notes For every event there multiple lists For every List there are multiple notes I have a portal in Lists that displays 2 fields from Notes. The portal is based on the relationship List_ID=::List_ID(in Notes). In this portal I need to be able to display all Notes records for the event, not just the notes for the current list. So far so good, however, I need every note to have both a List_ID and an event_ID. I need this to happen upon record creation in the Lists portal. I can get one or …

Hi all, Can anyone tell me if there is a way of using the calander and contact management of Outlook with our FM database? Is there a plug-in or a way to link the two together? We would like to avoid importing records into Outlook because of the hassle keeping the two in sync. Thanks. rg ps. sorry about posting ths under the "portal" discussions. I'm new to this list and will post to an appropriate subject next time. [ January 25, 2002: Message edited by: richardg ]

I have several databases: Clients, Expenses, Invoicing, etc... I would like to create a portal in each database which basically brings up the client names with the any given text string entered into a global text field in the non client database. However, I only seem to be able to execute a search via script. What I would like to accomplish with out scripting is: Search field: user inputs text string Portal: Returns those records with the text string in the client name. Is it possible??? and any suggestions??

Add a script that puts the current time & Date prior to entering the field. Or use the Last funciton to calculate the last time & date a record in the notes file was updated.

I have a database that does an invoice. The list of items in the invoice is a portal to a listitems DB which is in turn related it a item DB (for item discription, amount in stock,prices etc). So it looks like this |Items| ---> |listitems| --P-- |Invoice| I want to be able to subtracht the quantity from the invoice from the item database. Right now i have it loop thought the portal with go to row ( first) etc. and with every item it runs a script in the itemlist DB to take the quantity off in the items DB. The problem i found is that when i run a script it resets the go to row and it takes all the quantitys off the first item. I just tried doing a manual count wit…

I'm planning a new relational database where I need many different users (salespeople) accessing a database of customers. I also need each sales database to access an Order database which can be used for reports later. Simply Database "a" =Customers, Database "b" = salespeople data ralting to "a", and Database "c"= orders relating to both "a" & "b". Does this sound correct? What's the best way to start?

Have a file with workshops and portal with students who follows a specific workshop. In the portal there is a button. When i click on it it goes to the related record in the related file. It shows the latest lay-out when i work on in the related file. How can i force it (in a script )when i click on the portal button that the related record opens in a specific lay-out in the related file.

Hello everyone! I have two related databases to hold training records (when people took a class, what it was, etc.). The first file is the name repository which stores information about the student. The second file holds records of classes taken with a unique identifier (the relationship) between student and class. So, each record has the student id, class number, description, date taken, etc. What I'd like to do (using the student ID relationship) is create a repeating field in the name repository which contains all the class numbers taken by that student (data from multiple records in the related file into a repeating field on the master). Would anyone be able to help…

I'd like to have a Running Total in a Portal. Each record in the portal has user-entered values, and the Balance caluculates OK. But I need a running balance in the portal, like a bank book. Should be a simple thing, but can't get it to work. "Use value from previous record" won't work I don't think. Any suggestions?? Thanks. [ January 14, 2002: Message edited by: Rumble Seat ]

I have set all the priveledges for both the related files properly and yet I am unable to add any information to a portal in a new record. Does anyone know if this is a known issue or something that I am missing ? (We don't allow duplicate posts of the same question, I'm closing this thread. -bd) [ January 14, 2002: Message edited by: LiveOak ]

Hi everyone, I have a portal with following relationship "Name::Customername", when a name is typed in the Name-field, the portal shows all the names that are identical to the name that is typed in the name-field. Is it possible that if i type a piece of a name in the field, the portal shows every name that consists that piece? For example: If i type '"ROB" in the name-field, the portal shows all the names that consist "ROB" (like ROB, ROBERT, ROBBY,....) GreetZ&Thanx in advance

I have 1200 People in DB. Each are associated with a Group and Sub Group. I have a self-join relationship which sorts alphabetically by last name the people that belong to the same sub group. I need a calc field that numbers the people based on their sorted position in the subgroup. Albritton = 1 Baines = 2 /.../ Thompson = 38 Williams = 39 I'd love to accomplish this numbering without a script. Any suggestions? Thanks, John

Hi, i have a big problem... i want to scanne barcode and the number goes on the last portal row.. but after i scann it.. i want to do this again without press the TAB key or clicking on the seconde portal row for each item i scann.. how can i do this ? sorry for my por english.. i usualy speak french :-) tanks H

I have a portal which I need to filter via a specific relation. However the relation needs to be by user name and Date. I have a field called "Username" and antoher called "DateCreated" From a series of popup lists I need them to be able to select the user name and then a date. The portal will then only show the entries for those selections. any ideas? Huge thanks in advance

The blank line is there so that you can add a related record simply by typing new record information there. If you don't want to do that, Edit your relationship, and un-check the "allow creation of related records" checkbox. Then the blank line will disappear

I have just inherited a soccer league registration database in FMP v4, which is new to me. Past practice has been to use the previous season's records to track the returning players for the current season. Once registration closed, all records marked ACTIVE are kept, and INACTIVE are deleted. Problem is, if one of these INACTIVE kids comes back next year the record for that player will have to be recreated. I've been trying to have a kid's record copied to another file (Active_Player) from the original file (All_Player) when the player registers for the current season. Being new to FMP, I'm not sure if I should be learning about scripts or portals or something else. …

Long time no speak, Hope everyone's New Year was great. I would like to know if there are any known database issues/problems with the following: My user can view, alter and create records in Child file portal from within the Parent file. When the new record is created in Parent, the PK auto-number is given to the Parent record. But to make a relationship, the user needs to mannually type this number into the portal Child record. I wrote a script (based on another relationship to avoid cercular reference) to copy this auto-number and paste it into the related FK field in the portal, so when the user clicks the button the relationship is created automatically. Has anyo…

ok. I know this works because it works fine in my other database but for some reason in this database i'm working on, i can't get the delete portal row script to work. I have a button at the end of my portal row(s) that has the script Delete Portal Row (that's the only step in that script). In the portal set up i checked the "Allow Deletion of portal records" box and also in the Relationship i checked the "when deleting record..delete related records". But, for some reason when i use this script, it deletes ALL the portal records (in that one portal, that is) AND THE WHOLE "parent" record that contains the portal. This database is set up just like another one I h…

I have been trying for a long time to create a new portal. I have file A and File B. This is a conference in which a person can register for 20 different classes from a choice of let's say 80. I want to be able to enter the class no. in the portal and have the class name flood in from my Classes Database. I am having no success - even went to an extensive class on this. I have looked through filemaker help to no avail. I have a serious deadline now and if anyone can respont to my email at [email protected] and keep in mind that I am self learning so not that familiar with different languages, calculations or anything else complicated. Please help if possible!

database is for reservations. on layout #1, it holds showdate, showtime, showday, customer name on layout #2, I have created a portal, using a self-join relationship using 2 fields. field 1 is showdate on layout #1. field 2 is a copy of showdate, which I have placed on the portal. the portal is using relationship showdatecopy to showdate. I have created sum fields to show totals for each show, for each date. the totals do work. they are placed on the portal in layout #2. my situation is: I have 2 shows on a given Friday, 8pm and 10pm. when I enter a date into the showdatecopy field on the portal, I want the showtimes to come up and the totals for that show. I get…