Portals

Hello Everyone, I have a portal that indexes off of a value list. This works well... Is there a way to add and entry to the value list that will index the portal for all entries on the value list. Joseph

Hi, I have a relationship set up (with appropriate "add records" ticked) where the user can type in a new record. Problem is - it won't let them. I can delete a record, I can edit a record, it just won't let me add a new record (ERROR MSG: this action cannot be performed because the field is not modifiable). The field is a straight text field. I have checked the following: Relationship - ticked to allow creation of records Field - edit, allows modification, text (not calc) table - on the actual layout with the table I can add a record. Portal displays current records correctly so obviously the relationship works. I've created these th…

I'm uncertain whether this belongs in Portals or Relationships, since it pertains to both. Perhaps I don't understand how Portals really work, but this seems counterintuitive to me. Say I have two tables, A and B, with a join table (call it J) between them. This accomplishes a many-to-many relationship by including the ID fields from both A and B. Additionally, I have a flag field in J whose purpose is to filter the join. To do my filtering, I can place a *global* flag field in A or B, and then in my relationship I can specify that not only do the IDs have to match, but also the flags. Now imagine that I have set up a layout based on A. In it I put a portal view…

This is a quick question for those who have developed a vendor ordering system for a business. I have a line items file and with each item a purchase order field. The p.o. number appears in this field when the item has been ordered by the business. So many items can contain the same p.o. number. I'm trying to find a method to view the p.o. numbers in a summarized format where each p.o. number appears only once (one p.o. per line). I'll keep searching the message boards, but thought I'd ask. Thanks

Quite simple me thinks, in fact I've never had a problem with this before until now. I click on Client Name It opens a new window and I FIND a client from a Portal list. The field ::ClientName from the portal window is a button that triggers a script to: setfield ClientFound, FindClient::ClientName What this does is copy the client name from the correct relationship name (FindClient) into a field called ClientFound which is used for another relationship to show client information in another window. The problem is: The portal window may show Johnson Banks John Malchavitch etc etc If I click on John Malchavitch, it goes to the …

Hi, Using a self relation from client table to client table for searching by alphabetical sort; tow fields Filter(text) and Filter"Z"(caculation) and Name of clients. Filter----------<=Name Filter"Z"---------->=Name This is working well foe rearchin on names; only when a name has Z in it by example FAWZI. This is not working if i search for FAW; but working when searching for F, FA, FAWZ, FAWZI an displays well all names bigning with theese. Do you have an explication for this; and something to do to fix this search. thanks [color:"blue"]

Hello, I have a portal, which already has some filtering in it - you click the column header and it will sort the portal by that column (only ascending at the moment). I also have a popup-list above the portal, which allows the user to pick their name, then click a button [Filter] to show only the records which were created by them. Well, now I need to sort the portal by the status - so, there is a status column, and I click on the title of the column and it's sorted based on (the tricky part) the order of a value-list. The list is status: (Open, Closed, Pending); so when they click the title of that column, they will see the order showing n Open records; m Closed …

We are using portals to track our theatre ticketing history. We have it set up so that the most recent order appears at the top of the portal. However, when anyone tries to pull a report than involves any of the other portal rows, it finds the correct patron and puts it in the report but posts only the info from the top portal row. The info in the portals is kept in a separate FM document and each portal row has its own order id number. Any ideas on how to fix it? I have a feeling it's something really simple I'm overlooking.

All, I encounter this behaviour on both Mac and Win, in FP7v3. I have 3 global fields, two of them numeric, one text. The text field points to a related table (this table is in a referenced file); this table returns a numeric key corresponding to the text. An unstored calculation in my local table returns a numeric value from this key and the two numeric globals. The calculation result points to exactly one record in another related table (again, that table is in a referenced file). Fields from this table (one of them a container, but I do not think this is relevant) are shown in the same layout as the globals. What happens is this: Whenever I change any of…

I am using a portal to view a list of invoices from the related invoic DB, filtered by the clients name. I placed a summary field outside the portal to show me the Total Ammount of a client. That works fine. but as soon as i change the clients name (pull down list) the summary field turns into a blank field. i have to klick into that field to see the new calculated result again. Is there a way to show the information on the layout without scripting? thanks Norbert

Hi All, apologies for lack of input on these forums, but I've just started new job and things are a bit hectic. Anyway - I've been tasked with creating a new Asset Management Database (Users, Hardware, Software, Attached Devices etc etc) and immediately thought of FMP to develop it (as it's the only thing I use for DB creation!) First problem is hopefully something really silly - On the hardware page I want a portal row at the bottom where 'Attached Devices' can be entered (i.e - On Mac 1 I want to specify that a Scanner is attached, a USB HD etc etc). I's also like to be able to view these attached devices on a seperate layout that shows each device, and what '…

Hello, Does anyone know how to index a portal from 2 fields (Seperate). I know how to index it from one field... But not two... Thank you, Joseph

(we're still using FM5&6) In a portal, I have a field that may be one line of type, or may take up to several lines. Is there a way to make the field the size of the data entered into it when it prints? (i.e. if the size of the field in the layout allows for 5 lines of type, but sometimes when entered, only takes up one line, is there a way to omit all that extra space) I've been playing around with things, including the sliding/printing features, but can't seem to get this to work WITHIN A PORTAL. Thanks in advance for any input!!

In FM6 I have a layout with several portals. When you print the page, portals only print the # of matching records and everything on the page slides up if it can. If there are no matching records, then the portal doesn't take up any space on the printed page. Is there a way of having FM7 do this too? I'm getting multiple pages where I used to get only 1. Thanks.

Hi, I am a new member with only small experience about FM. I need to transfer a field content to my Foxpro program. Please imagine that I have a FM browser with an icon on that, when I click the icon, the FM should transfer a field content of a certain record to my Foxpro executable program. Help me please how to do it. Thank you very much.

Hello Everyone, I need to do a simple count on one field in my portal. I need to count only the Yess. I have tried using PatternCount (File_Login_SubSheet_Brokers::Entry_FileMaker ; "Yes" ) This seems to work but it seems tobe counting the first row of my portal.... How do I get it to count all of lines in my portal if they contain Yess. Help? Joseph

HI, I am having a difficult time getting my scroll bars to be visible on a portal. Is there anything special I need to do other "Show vertical scroll bar" in Portal setup? The width of the portal is "accounting" for the scroll - (blk sizing blocks are about a 1/4" to the right of the protal in layout mode). But in Browse - they are invisible. However, if I click where the scroll should be...I can get the portal to scroll...I just can't see the arrows. I put the portal and fields inside of it all the way front. TIA Chas

Ok, first off i've been using FMP7 for about 2.5 months. I'm making a 'cash register' the layout is based upon an invoice table and the items are viewed through a portal, to the items table. Several values such as subtotal, sales tax and total are on the invoice table and calculated on the fly as information is entered through the portal. When I opened up my file this morning, it no longer calculated the sales tax on the fly.. you have to click outside the portal. Subtotal calculates normally and the total calculates but is incorrect because it takes the values from sales tax and the subtotal. When I opened an older (1 day) backed up version of the file, it cal…

Hello all. I am a frustrated individual. First I'll tell you my initial problem, then where I am going. For background I am a long time software developer using SQLServer and C++/C#. However don't think I dislike FMPro because it is different than what I am used to - I know it is just that I am having a difficult time adjusting my way of thinking. Problem one - I have two tables Clients and Contacts. Joined by Client::ID == Contacts::ClientID. Both are numbers. When I put a portal on the client form I get nothing. I can't edit, nor can I tab into any fields on the portal record. I am sure I am doing something simple wrong but I am pulling my hair out try…

I have built a really nice central navigation system with script parameters and horizontal portal rows. The one big problem that I have is the graphics and text flash when scrolling through records. I tried filling all the fields with a color but the portal refresh is still a problem. This looks highly unprofessional. I know a lot of other people are going to this type of model so I was wondering if anyone had any suggestions. (Each tab is one portal row, with a graphic tab, text field and a script parameter) Thanks.

Hi. I come from access and mysql, so this is mostly a general question. I have a table with items. itermsid, name and partnumber. in another table i would like to show a portal with all iterms with itermsid over 10. in sql: select itermsid, partnumber, name from iterms where itermsid > 10; how kan i do that in fm pro 6. I miss all the function to extract data with parameters from the tabels, like i used to to do in mysql. So please eksplain how i extract and show the data in fm pro 6 Thanks

i'm having a problem with writing a script to do the described function. details: An existing database to manage all contacts has been given a new portal to hold all kind of contact details such as phone, fax, cell phone, home phone, etc & etc.......... previously, types of contact are kept in separate fields and are poorly organised. the database currently holds a substantial number of records and thus, a script is required to take data from those separate fields (phone, fax, etc) and put it into rows in the portal. i was able to do this on the first row but i haven't found a way to add to the second and third row & so on... any suggests wou…

Hi all, If my portal more than one pages how do I print? can you please take a look my attachment files! Thank! Another problem is can I follow the attachment files, when the records go to second pages, the first pages show the word "continue...."? I hope you'll understand my questions, Thank!

Ok, I have been doing portals now for about 2 months and I thought I knew how to do them until now. The setup: 2 Tables Welcome table -- which holds the portal Login table -- which hold info for the portal Fields: Welcome table: "In_Folder" Login table: "In_Folder" "FirstName" "LastName" Releationships: Welcome::In_Folder --> Login::In_Folder Easy so far... here is the tricky part the field "In_Folder" on the Login table is a "Yes" / "No" answer but it is a calculation field -- a simple case function that looks at different fields on the table and retuns a simple "Yes" or "No" when the case fits. -- works great The pr…

I'm having a problem with some related records. I have a table that has a series of "trips" related to a table called "states". Each trip record has a "state" field and the "total miles" traveled in that state. Each trip record also has a date. A relationship was made between trips and states where state equals state and date falls between a start and end field in the states table. I have a portal based on the state table that shows me a list of states for a given client. I have placed in this portal a field for the "state" as well as a calculation field that is a summary of the "total miles" field. It seems to be working properly accept that it only return…

OK, I'm stumped. Pardom for the newbie type question. Is there a relatively simple way to access field 'X' of row 'N' of a portal in a calculation, ie: MyRelationship::MyField[4] Which would access field 'MyField' of the 4th (or 5th, depending on your viewpoint) row in the portal? I assume there's probably a way to do this with a script but I'd prefer to have it automatically calculated.

I have a portal setup and I thought it was sorting correctly, but I guess not. Its probably an error on my part so maybe there is something wrong with my logic. Right now this is the order: 1. sort prioirty by custom values 2. sort by assigned (created) date by ascending order 3. sort by modified time by by ascending order Basically its a queue for things that need to be done and priority is working fine, when set to high it goes right to the top. However for some reason it doesn't sort it correctly by modified time. I want the most recently modified item to be sorted to the bottom for that day. Currently everythign is sorted correctly by date and prio…

I am in the process of creating a database for use at the school that I teach at. The database is near to completion. The problem I am having at this stage is displaying records found in a portal correctly. The best way to describe the problem is to download the database (MASTER.fp7). It is compressed as a zip file. The account name and password is MASTER.fp7.zip

OK, coming over from Access and Fox. Here's my problem, I just need to display grouped data in a portal. I have 4 tables:Technicians, Invnetory, Transactions and Locations. When I move an Inventory Item from one location to another the transaction is recorded in (oddly enough) the Transactions table. When displaying a Technician I want to display what the technician has in his Inventory based on Location. This all works. What doesn't work is when I display the list in a portal I see all of the transactions listed even if they are the same part number. All I want to do is display the items grouped by ItemCode, then sum the Quantity. I have tried many times to fol…

Hello, I've been working on a database and have one big problem left. I have two tables 'Customer' and 'Equipment' that I would like to relate to each other. A Customer can have more than one piece of equipment, but MIGHT NOT have one. After several attempts I still can't figure out a way to create a portal on the 'Equipment' table that shows the names of the Customers from the 'Customer' table. I would like to be able to type in a few letters of a customers name into a field on the "Equipment" layout, press enter (or tab), and then get a list of all customer names that begin with those letters. Finally, I would like to be able to click on a portal record an…

i am returning to fmp after a couple years. i have totaly lost my way ... i had once created a portal that i could use to monitor people in a self study classroom as they checked in and out there name would be added to the portal what pc they were asigned to and the time they checked in . i think i had a drop down list based on the number of pc's in the room. when there record was retreived from the search was able to asign a pc# then it would time stamp and add to portal bottom of record screen when they checked out could click button on there row in portal to time stamp and remove from portal... i cannot remember how to get started with this again ... please help ....…

I created a portal to show related records from another table. Each row has a delete button to allow the user to delete that portal row (only). Unfortunately, clicking the delete button on any portal row deletes all related records in the portal. What am I doing wrong? Frank

Hello all, I just wanted to know if there is a way to print from a portal? Let me explain this in more detail: I have a portal and this portal is sorted by 3 different sets of radio buttons, simple ones (Yes or No). What I would love to do is to be able to print what the portal displays. If the user click yes for each set of raido buttons i wish it only to print what the portal does. Thank you Joseph

Is it possible to have a script that will read several fields from a form and insert that information into a portal? I saw a bunch of field related commands but nothing for portals. However they may be one in the same, I thought I should ask. Simple example, you fill out the fields for a check payment, then click pay and have it added to the Portal, at the same time update the account balance.

Hi there, I am trying to create a portal that shows different members with different kinds of membership status information. I have created one field called Status_for_Portal and another called Year_for_Portal - the idea is that a user selects a Status and a Year from a drop down list in each of these fields. The relationship is betwen these 2 fields and a Membership Status field in each related record with exactly the same text result as the drop down item in the status_for_Portal field, and a Year field that matches the Year_for_Portal field. The Membership Status field in each related record is a calculation field based on whether a member has paid their fe…

Hello, I posted this in the Scriptmaker forum but only got one reply so thought I would try here...I have written a script that loops through a selection of records and sends out an email (using value of global fields as subject and body). I would like to keep a record of what email was sent to whom so I created a related table (related via an auto-generated, unmodifiable number field) to hold this information. Each time an email is sent I would like to automatically create a new record in the related table and fill it with the sequence number of the current record in the loop, the current date, and the subject of the email. I would then display these records via a p…

Example: In table 1, I have a portal row with 5 different entries. I table 2 I have another table with the same layout and portal setup. How do I, at the push of a button transfer all the entries from the portal in table 1 to the portal in table 2? Thanks for your help Heathbo

I just don't understand why or how portals and relations works. I want to make a simple Client / Product model, where Client is a Table, and Product is a Table. Client and Product both should have a field called ProductID, The Client::ProductID is linked via a Relationship to the Product::ProductID. In addition, Products keep track of the the clients that have selected this product. Therefor each Product keeps track of a ClientID, in the same fashion the Clients keep track of the products. So all I should have to do is this... 1) make the appropriate relations in Define Database (ProductID/ClientID) 2) Create a Portal in the Clients layout that …

I'm looking to create a calendar from scratch. It seems like all the other solutions that offer this use a series of portals. The main question is how is the mail calendar calculation work for months, years and days so they fall in the appropriate spots. Hope my question make sense. Thanks, Michael

I'm using a calc field with a container result to highlight the current portal row. When the user selects a different row a script sets the ID from the related portal record to a field in the current record. The calc simply uses an IF and when the ID's match the result equals a global container that holds the hilite color. The problem is that the last portal row highlights in addition to the current row. I understand that if I uncheck the box that allows record creation it doesn't do it anymore, but I want to be able to create records from the portal. Is there a workaround that will keep the last row looking normal without disabling record creation through the porta…

Hello Fellow DBer's: I need your help with an issue displaying the seconded owner name of an account that associates 2 names within a portal. I want to display the owner's names on a billing statement. Through the relationship it will display the first name (owner1) but will not allow me to display the second name (owner2). Any ideas on how to best do this? Thanks Mike Tables: Units (where the portal resides) Owners (where the owner information resides) Accounting (where I want the 1st & 2nd owner names to appear, btw, the first name appears but not the second) Relationship: Units (pkunit#) = Owners (fkunit#) allow creatio…

I have a database of bills and expenses that I record every month. I have the various bills in a portal with the date they are due and the amounts. What I would like to be able to do is to select only certain rows (or ID's) from the portal and then get a summary of the amounts from all of those rows only. Then, I would like to take this total and divide it by 3 to get a new total. Can anyone help me with this?

Hi all, I am trying to create a sub navigation for a clients' list by using a portal. Lets say for example I have a table where there is a customer, year, make, and model fields. I would like to implement a way so that from a find result by customer, a self join could be used in such a way to create a navigation but with unique values. For example. Customer Table joined to Main Table via id numbers. Customers: Bob, John, Sally Main Table: Record 1 Customer: John Make: Ford Model: Econoline Year: 2000 Record 2 Customer: John Make: Ford Model: F-150 Year: 1999 Record 3 Customer: Bob Make: Nissan Model: Sentra Year: …

I have three tables: Companies, Communications, and Home Page. Companies = list of companies with key_company_ID as the unique field for relationships Communications = list of communications with key_communication_ID. (phone calls, emails, etc). Each communication also records the key_user_ID and the creation_date for the communication. Home Page = global field where key_user_ID is set (after logging in). When a user logs in, I want to present their own "home page" using the Home Page table. I want the home page to list in a portal the last 10 companies they dealt with. The way to determine this would be to look at all the communications a user has mad…

Hi, I am rebuilding my office DB during XMas break and have several one to many relationships from Customer table. I have various layout views for Customer in which I display related data through various portals (one per layout). Data from old external tables in imported into new tables. All relationships work, one one-to-many relationship My contacts-portal only displays customer related data for one customer record (the very first in alphabetical order) and nothing for other customers. Prior to upgrading to 7.0v3, 2nd-3rd etc records were showing ALL contact record relationships in portals, but not properly recognising foreign key reference to CustomerI…

I've just moved solution I generated in FMP 6 over to FMP 7 Server, and am now going back to see where I can leverage the new features in 7. Here is one that has me stumped: What is the best way to generate a list of related values? Currently, I have a table of applicable documents. I have another table that contains paragraphs from a Statement of Work. There is a relationship between them based on document ID (actually, its a bit more complicated than that... it's a many to many relationship, so I have a jump table to link the two tables). What I want is a comma-delimited list of paragraph IDs (so I can have a field in the applicable doc record that states "Referenced by…

I have a Quote Form with a portal to the Quote Line Items (FM7). I need to print the finished quote and send to the customer. I understand that printing the portals from the Quote Form is not a good idea. What's the best way to do this keeping in mind that the customer's shipping information and other pertinent data from the Quote Form needs to be printed along with the Quote Line Items? I'm sure there is a common, simple solution from you seasoned developers!

Hi, i have a portal on one of my layout with few fields in, my question is how can i have one of the field having multiple values while the others reamin the same, exemple: a "part#" have 1 "part name" but could have more than 1 "2Aid" and "tube" Any help would be much appreciated... (if u need a copy of my db u can download it from my post in Value List) Thanks again for all the help we found on this great forum

Hi I'm just a new Filemaker user so I am making my excuses from the outset. I am trying to create a database to handle event scheduling. At the moment I have three databases that talk to each other - 1. Personal contact details 2. Organisation details 3. Program details (we run a festival so this includes fields like session title, start & end times, date, venue, speaker 1, speaker 2, speaker 3, speaker 4 etc.) The speaker 1, 2, 3, 4, fields in "program details" have drop down boxes of all the contacts in the "personal contact details" database. I'd like to be able to create a personal schedule for each speakers (must update automatically when…

HELP PLEASE. I am using FM6. I want to scroll through entries that correctly display a detailed related entry and also enable me to select the detail entry from a list. Let me describe my structure briefly: I have a CONTACTS file and a VEHICLES file. In CONTACTS, I have a layout that displays contact info, a List portal (multiple rows) that shows a list of related vehicles from VEHICLES and a Detail portal (one row) to display detailed vehicle info. I have no problem using a global field and relationship to select an item from the List portal to be displayed in the Detail portal. The problem is that when I scroll through the contacts, the same Detail port…

A simple question probably, but I'm stumped. I have two databases linked by an ID number field. DB A has household info, DB B has individual info. I made a portal in DB A which brings in info from DB B just fine. There may be up to 6 related records in DB B for each record in DB A; the number varies. The portal is set up now with 6 rows. That works fine, but I would like the number of rows in the portal to be variable; 6 when needed, 1 when needed, etc. Any suggestions? Right now I have to print a lot of blank rows.

Good Morning. I am trying to find out if it is possible to sum line items donations totals by date in a Portal. I have a portal (Donations) linked to Customers where we enter donations received by a customer in his /her portal lines. I would like to group/total these by date. is this possible? Many thanks. Roger Eg. Customer 1000 29/11/04 Donation - Xmas Appeal

I use portal to auto-fill some fields in the database. I also do "allow entry" on those fields so users can change the values of the fields. However, when a value is changed in the form, the value in the related database is also changed, which I do NOT want. I only want the value to be changed in that one record, and not touch the original value in the related database. How do I do that?

Hi everyone - I'm making an invoicing system. I want to be able to select items in an invoice from a drop down list in a portal which grabs the items from a related "invoice items" table containing all of the possible invoice items. The selection area in the "invoices" window is set up currently as a portal; the problem with this is that I can only change entries that have already been entered from the "invoice items" table, which works, but I don't want to have to keep switching windows. It would be easier to do things in one step. I was wondering if there's a common way to do this (ie- some settings in the portal I could change so I can select data fro…

Hi everyone, Is there anyway to have a portal with sub summary fields. I have a solution that is multi tiered. That is to say I have a Job file and a Job Line item file. The line item file is made up of "Descriptors" which in turn have there own line item file. I have a script that breaks down the line items into the Descriptor Line Items and places them in a "BOM" file. I have a portal on the Job file that displays these items. I currently have another file that summarizes these items for display in another Job layout because i couldn't figure out how to display a summary through the portal from the BOM file. Is this possible? The script that I am using now is a ver…

I have a portal that doesn't seem to show related records when I share the database using FM7 Server but it works fine when I'm just accessing a copy of the same file on my harddrive using FM7 Pro. I have the database set up so that everyone has access to everything and it doesn't require a password. Other portals on the same layout work fine and the only difference in the non-working one is that the table it's pointing to is a self join table as follows: eg. (Table G 2)-----(Table G)-----(Table A) The Layout I have is of Table A. Inside this layout I have a portal pointing to Table G 2 which is a self join of table G. What's strange is that if I add on…

Hi, It would be absolutely great if someone could help me with a really tricky matter. Let me explain first of all that I am bound to the database structure I will explain, because there is an existing mysql-database which should be administrated by my filemaker-solution. The tables of interest are: FILMS PERSONS PERSON_TYPES PERSONS and PERSON_TYPES are linked to FILMS by an n:m-relation (X_Films_Persons, with the fields ID, Film_ID, Person_ID, PersonType_ID). Now I want to display all the persons and their personType belonging to type 1,2,3 in one portal in FILMS, all persons belonging to 4 in another one and the rest (5,6,7,8) in the last portal.…

When you click on the "Add Relationshp" icon, an Edit Relationship window appears where you define information about the relationship. Once this has been done for a table pair, how do you go in and look at what has been specified and if needed make changes? For example, you want to change how the records are to be sorted in one of the tables or no longer allow creation of records in a table based on this relationship.

I want to add a button in a row of a portal that will jump to another layout with the current record displayed. TIA

When using a join file... sorry, LIST (old habits...) to create a many to many relationship between two lists, I have read that you can actually create new records in one file via entering data into a portal on the other. I've tried this and seem to have it set up correctly, but it won't create records. The relationship works fine if I create records manually. Is it a myth that this can work, or am I doing something wrong... or is it only a feature of Developer?

I'm overlooking something. Years with filemaker (Version 3 my first) but never used portals. I'm not a programmer either but have done ok on my own. SSsssooo, I sell books. Each record is a title. I want all titles to show in 1 field so I can copy paste or send in emails of current availble titles. I have tried my relationship but can't seem to get them in there....HELP!!

I have database1 with 280 records

Greetings, I need the ability to insert a new portal row in between other rows, preferably by using a button on the portal row. I'm sure this is a pretty common need, I just have not been able to find an easy solution. Any advice is greatly appreciated!

I have a script that loops through a portal to set a field in the parent table with the related fields in a format for printing that cannot be achieved by just printing the portal. When I run the script on a Mac, it takes 32 seconds, which isn't great but passable. When I run the script on a PC, it takes more than 3 minutes. My client is in a PC environment (medical center) and switching to Macintosh isn't an option. Does anyone have an idea why there is such a discrepancy between the PC and Mac and what can be done to resolve the issue? All of the other scripts seem to run equally well on both PC and Mac. Thanks for any advice.

I have just got the program and am trying to set up something very quickly (and basic). I have 2 databases - 1. a forms database (a list of company forms) 2. an ordering database (to order one of the forms) The 2 databases have 2 related fields which are "Form Ref Number" & "Description". I have populated the forms database with around 7 entries and what i want the ordering database to do is when the user is creating a new order, when they click on the "Form Ref Number" a popup of the form numbers to appear so one can be selected (i have this working and its gets the data from the forms database no problem). However i wa…

Hi, i am quite a Newbie in FM (using FMP7) and i am building a database for design and production validation testing in a Vehicle company. I have many tables (see attached) and i want to use 3 Main Layouts (Lab Data, Projects sheets (parts, test) The way i want it to work is as follows: Engineers will create a new project and feeding the parts No, tube, connectors, etc... Then create a list of Test to be done with all the details Ideally i would like to create a matrix (like Excel spreadsheet) matching which test as to be done on which part or tube or connector And at the other end, i will have the Lab guys feeding the results in the Lab Data layout As…

Good Day I'm creating contribution gathering DB for my church. The DB has basic tables (MemberMain, MemberDetail, ContributionMain, and ContributionDetail)on ContributionMain I have main infomation (such as ConID, Date, Enterby) and Potal using ContributionDetail. Now, on ContributionDetail I have ValueList for Types of Contribution (Such as 1/10th, Give Thanks, Weekly, and Other). I used a Summary field option to gather LineItem Total and it work. but I want to create a Tab(new Layout) for SubTotal Potal for my ValueList. Is there a way to do this? Thankx Kimi at work ~

FM for some really odd reason does not have a selection list. Not a Pop-Up list, but a multi-line selection list. So I'm trying to imitate this with a portal... I'd like the user to select an item in the list, then click on a button (not in the portal) and run a script. I need to know which portal record is selected so I can do the right thing. So far I can't figure it out. Any suggestion? Thanks, S

I have two tables in a one-to-many relationship. I'm showing the "one" in a layout with a portal for the "many". The "many" table is already populated. I don't want to add records in that table. I just want to select one of the already-existing records to relate to the "one" record I'm currently viewing. I'm hoping someone here can give me a clue as to what approach to take. I'm not making any progress with my experiments so far.

I have a database I use as a point of sale system. It is for keeping track of which zip codes a realtor is assigned to represent. I have 3 tables. 1. Agent Info 2. Orders 3. Order detail. -Agent info is just that. Contact info and the like for that specific agent. -Orders is the parent of order detail and basically is there to allow there to be numerous orders for each agent and still different zip codes per order. -Order detail is the zip code info for that specific order. The problem I'm running into is this: I would like to have a lot of this info on one page. When I select the order on the left, I'd like to display only it's childs records in the…

I am working on a program that will help the person who does school scheduling layout the master schedule, teacher schedule and student schedule. I have the master schedule and teacher schedule figured out. In the master schedule (table) each room and period is equal to one record hence each room has 50 records in the master schedule table because we have 10 periods in a day and there are 5 days in a week. The teacher schedule (table) is analogous to the master schedule. Each teacher has 50 records the teacher table. 1 record for each period of the week. I have it set up so that when class is entered in the master schedule, the teacher who teaches tha…

Newbie Question: I have a one to many relationship and need to copy a value from the Many to the One. The one is a "project" table and the many is a "team" table. The team table contains two fields that are important. "Responsibility" and "Name". I need to copy the "Name" value from the many into a field in the one based on a calculation of the "Responsibility". I have three fields that I am trying to copy into, "Production", "Trainer" or "Consulting". When I use a calculation, *If ( TEAM::pta.Responsibility="Production" ; TEAM::pta.contact ; "" )* and a similar calculation in the other 2 fields, I am only getting the first record in the many and it ignor…

Hi, I have a portal ten deep. I want to be able to choose a company name from a drop down list, then in the next column have a company contact automatically fill in. The problem is that when I do it for the first record, it changes the contact name for all ten records to that one company. I used to have the user enter a company number and all the corresponding info would fill in, but my boss wanted to make it easier, hence the drop down box idea. Any ideas? Vandy

I know this topic has been covered a lot recently but reading the thread left me confused! Sorry! Here is my problem: I have a text field called CHOICE which has three checkboxes called OPTION 1, OPTION 2 and OPTION 3. I would like to see those records where OPTION 2 has been clicked to appear in a separate portal. As an extra, can the results in the portal be further modified to show records where OPTION 2 has been picked between 2 dates? What I have in mind here is a button setup which asks for the first and last date and then shows the found records in a portal. I am a FM newbie so appreciate your responses! Frank Bugeja

I have an idea of how a join table is supposed to work, I just can't seem to make one work properly. Does anyone have a simple FM7 file that demonstrates how a join table is supposed to work?

Great forum, been coming for a while and have found lots of goo advice/help, just never had a reason to post - until now. I have a JobInfo table related to a receiving table and shipping table. The receiving and shipping tables both are related to themselves to show a portal in their layout. The portal shows the receiving (or shipping) dates and what was received (or shipped). I would like to show the last date that was entered, but I want to make sure it was the last date received (or shipped). I would also like to do this without a script. Any help will be greatly appreciated. eddie

I have a simple Point of sale databse with the main file housing customer info and the related file housing the stuff that they bought. I would like to be able to omit certin items they bought from the invoice (printed report). I'm thinking of a simple checkbox on each portal record line. If it is checked, that record is excluded from the report. If it is left alone, it is included like normal. What I'm missing, of course, is the functionality. I'm a intermadiate to filemaker, but new to version 7. Any thoughts are much appreciated. Thanks

I created a portal to display related records and chose to sort them by date. However the portal is showing the same record over and over again (significantly, the number of repitions equals the number of related records), rather than showing each unique record. Oddly enough, this problem arose when making a new portal utilizing a copy of a relationship in order to create a new layout with a different portal sort order. The portals using the original relationship work just fine; but the duplicates of the relationship have this problem....

Is anyone able to tell me how to get a portal to display ONLY the current found set of records from the SAME file? I don't want to have to insert / replace a value in the match field to identfy the currently found records each time I've done a find since it would have to be deleted again each time I do a new find / omit any of the found set. Is there any way of creating a dynamic relationship based on the records that are members of the current found set? I've tried self-joins based on calculations of the Get(recordnumber) but they won't work unless the calculation is indexed (which of course defeats the object of the exercise as it won't then change/upda…

I have a product_sales database with a portal to a product_inventory database. It works perfectly _IF_ you press 'Enter' before entering any data. If you create a new record in product_sales and start entering data in the portal, it does not retrieve the data. It doesn't do anything wrong, just nothing. I'm new at Filemaker, but everyone here says 'That's the way it is.' Fine. My question is how to generate that 'Enter' in a script. I need to create a new record and populate it with parts and have the portal work correctly. Hope that's clear. Thanks,

Hey! I have two questions. Question 1: In a portal: line 1: Blue $100 line 2: Red $ 50. How can I create a total ($150) for the layout where the portal resides -- preferably outside the portal? Question 2: In a portal: line 1: 5) Process 1 line 2: 3) Process 1 How can I create only one line showing: line 1: 8) Process 1 Thank you!

Hi all, I was wonder if anyone has any suggestions to this problem I've encountered. Perhapse the solution to this is rather simple, please point me to a direction. Thank you for any inputs to this matter. I am working with 3 selection portals - A, B, and C. Each built on the relationship base on global fields equal to a row that was click in the other portals. For examples, when user clicks on a row in A, a global field is set to equal to the value of that row then B portal is populated base on the relationship to that global field. Same method is done so C portal is populated base on the row clicked in B. Each portals has 15 rows on the layout. Some …

Hi, I have a portal at the bottom of my layout. It contains detail items. Well, up until just recently, those detail items have never been enough to go past the length of the portal. The portal will show 8 items. But when I added some new items - so now I have 16, the scroll bar on the right doesn't display. I have in the portal setup "show vertical scroll bar" checked. anyone ever have this happen to you before? If so, what did you do to fix it? thanks, sincerely, J__

I have 2 files - one of these with a portal which summurizes input of the other one. When I am trying to create invoices (using my portal) for a certain period ( I can do this using the Datafilter - plugin), I become all records (patients) who had treatment during this period. The problem is that some patients paid some treatments (but not all) already cash within the selected period. I indicated this in my input field by a seperate field (list) (paid/not paid). Now if i do the search for all patients within a gving period and indicate that the field must be not paid, I still become all records (paid and not paid), since the my portal summarizes per patie…

I am using a portal for data entry, and would like to limit the number of records created through the portal. Is there a way to do this? [email protected]

Hi there, Feeling still like a newbie, so bare with me. I'm having problems setting up a simple invoice/invoicelines system..... To my unbelieve, the only templates, as far as I found, that come with version 7 Developer, show this solution with only 6 fixed lines.... I can't believe that something so trivial as a master / detail form is turning out to be such an headache.... or am I mistaking ?

Am I missing something here? In FMP 6, if the user tries to tab from one portal row to another without having filled in all "Not Empty" fields, the validation-error dialog box will stop him and force him to fix the empty fields before moving to the next row. In FMP 7(v.3), "not empty" validation isn't checked until the user clicks out of the portal and commits the master record. The dialog box alerts him to the error, but the cursor simply returns to the relevant field in the first portal row, instead of to the row that actually contains the error. This is very confusing for the user, particularly if the error exists in a row he'd have to scroll down to find. Ho…

I'm working with FileMaker Pro 7.0v3. I have a table 'Customer' that has the name, city, and state of many businesses (which are customers). I have another table 'Equipment' that contains information about a piece of equipment (specs, etc.). The 'Equipment' table also includes a field for "Customer Name". When I'm looking at the 'Equipment layout' I would like to find a way to type in part of a customer's name (in the "Customer Name" field) and bring up an automatic sorting view/portal of the closest options (including the ability to view the associated city and states for those customers from the "Customer" table/layout). Then I would like to be able to select a…

Hi, folks. Ready for the holiday? First off, here is a screenshot. It will help me explain what I mean. On the left, under "Staff" is a portal using a self join relationship. It's meant to be used for navigation; click on the name and see the related info on the right. There are about 100 staff members in the database, so some quick find/elimination is in order. This is for a school. Let's say I want to display only the staff for Classroom 1. What I'd like to be able to do is type "cl 1" in the Search field below the staff portal (there is a field "nameWorkLocation"), click the "search" button and have the resulting found set display in both the port…

I have a repeating field that contains an ID but they can be entered in a random order like 2, 5, 6, 1. Then a portal to shows me related record for each ID number. But the portal only sorts in oder so it would be 1, 2, 5, 6 or 6, 5, 2, 1. How can I force the portal to sort in the same order that the id number are entered in the repeating field. Or can I have the repeating field automatically sort itself?

I hope there's a solution for this problem. I would like to be able to show the result of a calculation using information from the current record and each related record appearing in a portal. The problem is its a many-to-many relationship. The problem is biology (genomics) related: Two tables (sample data) INSERTS name location (1000, 2000, 3000) GENES gene start/end (500/1500, 700/2500) relationship location >= start and location <= end (this isn't exactly how I do the relationship since non-identity relationships are astronomically slow, but the net effect is the same) So the first record in INSERTS is related to bot…

I've changed my system around so that all primary keys are now autoentered, not modifiable. So this way I have a ProductID for each product. There is a related table , Resources, which lists resources required to produce each product, and a join table, ProductResoureces, with ProductID, ResourceID, and qty. Now, I have a ProductResources portal on the Products layout. This allows me to view and add/delete resources needed for each product, via a value list to select the resource. Here is the problem: I need to select the Resource ID (and then the resource's title will pop up of course in that field)... BUT - I don't want to display the ResourceID (just a numbe…

I have this problem but I think I'm just missing something very simple. I have a core table called "clients". I have a related table called "fleets". Related to fleets I have a table called "units." It is possible for a client to have more than one fleet. Each fleet can contain more than one unit. I have a layout based on "client". On the layout I have a portal based on units. I want to see ALL units related to the client through the fleet relationship. As of today, all the portal displays is the very first unit record of the very first fleet record. Any suggestions?

Aahhh ... what's going on in FM 7? I have a portal with a number of records, sorted by a sort number in a separate number field. When I deselect the portal, the sorting doesn't work anymore... I use this portal for navigation, so the sorting must be accurate ... Anyone any ideas?

I'm sure there's a very simple solution to this, but it's not coming to me... I have a portal that contains in each row a small container field with a pic in it (a thumbnail if you will) and a filename field. Next to this portal I want a larger scale preview of the "current" pic, and some way to select which pic would be that current selection. As far as selection goes, some kind of mouseover would be VERY cool, but I don't think there is a way in filemaker. But perhaps clicking each one would select it somehow? And then how to display that pic next to it but larger (obviously a larger container field, but how to relate it through the portal, while still keeping my…

I have a job record with a portal revealing the perfomers who worked on the job. Some of the perfomers will not get paid ontime and will have a late payment, which I have fields for on the portal calculating the amount due. In another file I have the late payment letters. I'd like ONLY the perfomers who have late payments to show up on the portal in the late payment letters file. How can I just choose those people and not have everyone show up from the original portal?

FileMaker Dev 7 Vers. 3 Whenever I try to scroll through the records in a portal that I created, it seems to slide the frames of the first record in the portal over the rest of the recoreds. It is hard for me to explain, but I can provide a screenshot(jpeg attached). I have setup many portals in my app with no issue; however, no matter what I do to this portal, the first portal record in "drag-framed" over the rest of the records. Any help would be greatly appreciated.

Hello there, I have a portal with 6 rows and I would like to have two buttons (previous/next)to jump six rows by six... like an internet page. I really appreciate if somebody could help. I'll be happy to receive all your suggestions. Sorry for my bad English. Thanks. French version: J'ai un portail avec six lignes et j'aimerai ajouter deux boutons (pr

The problem I have just encountered is this. I'm creating a program to track my opinions of movies, actors and studios. I have a table for the movies, one for the actors, and one for the studios. I want to be able to enter the cast through a portal in the movie table. I can create entries in the actors table through my portal from the movie table, but the problem is that if an actor is in more than one movie there is more than one entry in the actors table. Anyone have any ideas as to how I should proceed?

Using MacOS X, FMServer Adv 7.0v2, connecting with FMDev 7.0v3 on MacOS X(different machine). I have a Name table and a Gift table. On my Name table's main layout I have a portal to Gifts. I want it so that the user does not see their own gifts. So I have the View privileges set to GetAccount(Name) != Name in the Name table (with the proper "doesn't equal" symbol) and I have GetAccount(Name) != NameTable::Name and IsValid(NameTable::Name) in the Gift table. If I view a layout from the Gift table, it works fine. The user sees all of the records except his own. But if I look at the Name table's layout, the portals are blank for every record. Here's the …