FileMaker Interface Features
-
How Can I make a drop down listbox on a data entry form default to the last chosen entry such: User clicks on addnew. User picks Company Code from a drop-down list. User finishes that record clicks add new again. This time I want that drop down list to default to the value from the previous record so my user can just tab through the field.
-
- 1 reply
- 803 views
-
-
hi...new to the group i have a problem that has been puzzling me for awhile... i'm writing a new solution which has a portal being used as a queue. i want to sort the portal by different fields by clicking on a header above the listed items very similar to a finder window or windows window. i define this sort order of course in the "define relationship" dialog, but that means i have to change the actual relationship to sort differently, which of course means making lots of layouts with the new portal, lots of duplicating and rewriting scripts. i'm allergic to all of that duplication and changing! also, i want different users sharing the same related file to all hav…
-
- 1 reply
- 706 views
-
-
Using a file that has nothing but a dozen value lists, I want a revolving door for the values in a field in my main file, escpecially when the value in a counter field is triggered. Here's what I have so far: if(Global counter <= 10 set field (global text, valuelistitems (file2, field1) set field (magazine, global text) if(Global counter >=11 & global counter <= 20 set field (global text, valuelistitems (file2, field2) set field (magazine, global text) end if end if Why isn't this working? Am I mis-using the valuelistitems function?
-
- 3 replies
- 1k views
-
-
Hi, I'm just starting with FMPro5, or any databases for that matter. I am trying to make a DB that has a set of fields with a pull down menu that has choices of foods. I also have a field that I would like to display certain numbers depending upon the choice in the pull down menu field. I'm not sure how you would do this. I figured out that if I make the second field a 'calculation' field, I can use an if statement something to the effect of, "if the food field is (lets say) eggs, then display (lets say) 3, if not, then display 0" My problem is, I have a long list of choices under the pull down menu of foods, and I want a variety of numbers to display, depending …
-
- 2 replies
- 737 views
-
-
Trial and error and reference to my FM guides have failed to meet this apparently simple requirement. My database has a fax/letter file to automate writing and sending/printing these documents. It works fine when the whole document is set up as a single A4 portrait page with header and footer. However, I want to allow the user to write and fax/print letters of any length, composing the body in a single text field. I understand the difference between title headers and headers and have set these up OK. My problem is what size to make the body field and where to place it relative to the body section and also the broken page border lines whose meaning I don't understand. i…
-
- 3 replies
- 859 views
-
-
I have a global field with merged fields imbedded. basically it's a price list where the copy stays the same but the cost can change. Anyways, I wanted to include leader dots upto the price. I have placed a right tab with a fill of "." (no quotes) followed by a left tab to create a space to the dollar sign and then a tab aligning with the decial point on the price. 1) Here's my problem. the leader lines (dots) have a space every so many and will also run beyond by blank tab area and in some cases past my Dollar sign. Each new price acts different. I checked my tab buttons incase I had left the fill button on but I didn't. I highlighted all the copy befor…
-
- 1 reply
- 762 views
-
-
Hey Guys, I'm a newbie at this FM stuff, so bear with me. I have a feeling that the way to go about this is to create a portal, but am not too sure. I have one database which is dedicated to certain assets. It contains two fields called Asset_Number, Asset_Name that I am concerned with. What I want to do is display a list of both Asset_Number, Asset_Name in a portal on the main page, and I do not want to use a list layout because I am going to want to display more data from a different database at a later point. My end result of this portal will be larger than simply just Asset_Name and Asset_Number, but I want to start with fields from the same file before moving o…
-
- 2 replies
- 923 views
-
-
Hi all, I have been trying for some time to get FM doing what I need, but still struggling. Here is the scenario. Category
-
- 2 replies
- 1.1k views
-
-
I currently have a number of layouts with 'bars' across the top with various options ie. New Record, Print Current Record tec (This is irrelevant!) Does anyone know if it is possible to make this bar stay in this possition on the screen whilst scrolling down the rest of the page. Like a TOC would on a website?
-
- 2 replies
- 785 views
-
-
I have a project of a data base that requires the Footer to chnge to Diffeent panels like a baner ad does on a web brouser. How can I do This in my data Base?
-
- 2 replies
- 879 views
-
-
I have a portal. The portal has many rows. Everything works fine until I try to print or preview. When I print or preview, certain portal rows drift down so that I can only see half of the text in the portal row, or none of it at all (it drifts below the visible box). I checked that the field is not sitting outside of the portal row area. Has anyone seen this? HELP -wald
-
- 4 replies
- 982 views
-
-
I'm not sure if this falls under portals or relationships, so I'll see what you folks have to say. Here's my situation ... The relevant files in my database are structured as follows: --2 files, "companies" and "products", in a M2M relationship --1 join file for the M2M, "line_items" --"products" file is a hierarchical listing (hierarchy done through self-joins) What I want is a nice way of entering, and showing already-entered, data into the "line_items" file FROM the "companies" file. The entry choices (in the form of a hierarchical list) are individual records in the "products" file. My preliminary idea was as follows: --The entry is performed using a por…
-
- 0 replies
- 921 views
-
-
I want to do a self join portal in a file that uses a matching field that is related from another file. I tried to make a calculation field using the relationship to generate a field, the result on which to base the self join match, but FM warns me that that wont work because the result cannot be indexed, because it comes from a relationship. How can I do this?
-
- 4 replies
- 1.2k views
-
-
I have two databases. One is an invoice database and the other is a "production" database. They are related by a common job number. I would like to have the "invoice number" from the invoice database automatically appear in the "invoice number" field in my production database. It seems that a portal would be the most appropriate way to do this but I can't make it work (I have never made a portal before). I would appreciate feedback on if this is the appropriate way to do this and would "really" love a step-by-step. As I mentioned, a relationship has already been established. Thanks.
-
- 2 replies
- 769 views
-
-
You want heirarchical menus? or value lists? What version of Filemaker are you working with?
-
- 5 replies
- 1.1k views
-
-
I have been operating a FMP 4 database for several years (updating from earlier, flat-file versions, etc.) to run a translating business. But I don't know much about designing databases. My system keeps good track of Jobs (when they come in, go out, how much to charge, which translator/s did the work, how much each bills me, etc.) as well as, through relationships, using and accessing client details, translator info, etc. Each job also displays the corresponding invoice number once it has been invoiced. The Invoices file keeps good track of invoices and works wonders generating reports of one sort or another, but this is where the problem lies. Th…
-
- 10 replies
- 2k views
-
-
I am looking to create a conditional value list with more than 1 tier to it ie, I want to choose column A - that in turn, effects column B - that in turn, once B is selected, effects column C, and so on, any one know if this is easily done? I have a database that is full of relative information, starting with size, then type, then costs, etc..... It would be nice to have all my info in one outside file to import into my master, so everything can be easily updated later in just 1 simple location. I'd appreciate any help, Thanks
-
- 1 reply
- 747 views
-
-
I just did my first version upgrade and imported my records. After viewing my portal, the displayed record order did not match my sort order. Sort order in defined portal relationship was correct, but not carried out. What happened? Any suggestions on avoiding this on update/import? [ November 05, 2001: Message edited by: kens ]
-
- 3 replies
- 776 views
-
-
I've gotten great advice from some of you guys, and I wanted to give something back. If this is too newbie and obvious just ignore it and smile at my naivetie. I found a great simple solution to a problem I had. I was trying to use a value list from another related file but wanted the list to be uniquely defined in each record in the related file. I formatted the field that I wanted to have a value list to use values from the related record and selected the the field that would define the value list. I defined that field as a simple text field. In each related record, I entered the text for each value to be used followed by a carriage return. It works just like the "def…
-
- 1 reply
- 686 views
-
-
Hi: I am using checkboxes in one file, I defined the font size in the field as 18, but when I publish this file to the Web, all the other fields show me the font size I defined except the checkbox one, it looks so small and ugly! Can anybody help me on this? Thanks in advance! Catty
-
- 1 reply
- 644 views
-
-
I wasn't sure when it makes the most sense to have a new data base? Is there a rule of thumb? I was developing a quoting data base and job overview layout in another data base and feel that both could be in the same data base rather than having lookups since they use a lot of the same information. I came to this conclusion because I was having to constantly use a relookup when I adjusted estimate numbers on that could be found on the overview data base. Any thoughts? -Morning Man
-
- 1 reply
- 843 views
-
-
I have a number of records appearing in a portal. I need to have the computer tell me how many records are in that portal. How can I do that? Thank you!
-
- 6 replies
- 1k views
-
-
I Have created a button to go to the previous record, this works just fine, but I was wondering if the was a way to click and hold down the button to make it keep going to the next previous record. Thank You Drags
-
- 2 replies
- 836 views
-
-
This is more to do with Windows (95) than FM Pro, but it is a problem. How do you disable the edit functions which are activated by the right mouse buton. Are these deactivated when you remove these functions from the main menu ( I haven't defined access privileges yet)? My users are often pasting unintentionally. Thank you.
-
- 1 reply
- 843 views
-
-
Hi outthere, I have a value list and only want to view the records that match one of my value list entries, can this be done? It always shows all my records. Thanks in advance, Morning Man.
-
- 1 reply
- 753 views
-
-
Q? - Gotta be a way to make PC like Mover Lists? I am developing a FileMaker 5.0 medical application for a client. They have requested the ability to ... 1. Push button next to an empty list box/textbox with scrollbars, database form/layout appears ... 2. Left side of database/form/layout are multiple selections from a value list (actually called/listed from records stored in third database). 3. Right side of layout is empty list. 4. Between both are the Move 1, Move All, Remove 1, Remove All - standard Mover List Buttons ... 5. Once selections have been made - select OK button on layout, all selections are then applied to the list from the form/layout/database…
-
- 0 replies
- 897 views
-
-
Here's my situation: I have 2 files, Main.fp5 and contacts.fp5. Main.fp5 is a "jump-point" file to all other files. In the contacts layout in Main.fp5 I would like to create a portal that displays all contacts for our company. Clicking on on a contact would open the contacts.fp5 file. I cannot figure out what kind of relationship to setup here. Obviously I need some sort of key field that is part of every new contact file so that the contact will display in the portal. I set up a key field in both files called it "cutomer_origin". I set the relationship to match these fileds and was able to see all contacts in the Main.fp5 portal. However, I could not select of …
-
- 1 reply
- 825 views
-
-
When I first started using my databases in Windows I hated the window in a window configuration. Now that I have the 5.5 suite running I am accessing my databases on my Mac in OS X.1. I have 4 empty databases on my desktop that run scripts to call a list of related databases from the FileMaker Server. The problem is that when the files open they default to full screen. Selecting the previous window size/grow button results in a haphazrd size and placement of the windows. What I thought was a pain in windows was actually a good thing. In windows, once I set the size of the application window (which I confess I tried in vain to get rid of) I simply fit each database exactly…
-
- 1 reply
- 939 views
-
-
I have a solution tracking student test scores. There is a Tests file which contains a record for every test a student takes and a Reports file which displays whatever info through portals. I have a grid created comprised of 6 portals (K, 1st, 2nd, 3rd...) keyed on a student id. When a student has taken every test in a given year it works great. As expected when a student does not have a record for say the 3rd test in the list, all the data below that test move up one row in the portal, which doesn't display the grid accurately. I have two solutions which I know would work... Solution 1: Create a record for every test for every student, even if that student will never t…
-
- 3 replies
- 952 views
-
-
I' Like to show records in a portal that match a relationship, but only if they also are marked as active in a field called STATUS in the related file. Is there any way to do this?
-
- 1 reply
- 718 views
-
-
Is there any way to alphabatize items in a value list? I have a simple value list of cities, it would be much easier for users if they could be sorted. I thought of having another file of just cities, then I could sort them, but on the one form that my users will use, they use the cities value list numerous times, and with different answers every time. Any suggestions?
-
- 1 reply
- 816 views
-
-
I have a portal that displays doctor's names and address that I choose from a value list. The portal is in the Client File. The doctor's names and addresses are in the Medical Provider File. The portal and the value list get the information from the Line Items File. This all works great. My problem is that I need to have a field outside of the portal where I can choose one of the doctors as the Treating Doctor and that field will contain the doctors name and address spaced apart appropriately so that I can use that field for a government form on another layout. I also need another field outside the portal which will display the doctor's name and address in a form fo…
-
- 1 reply
- 816 views
-
-
Do a Find for the specific Inventory Code, then your summaries will be based on those records with that Inventory Code. ~Dennis
-
- 2 replies
- 857 views
-
-
I have created a simple address entry program. I have hid the status area and I am using calclation fields setup as merge fields to give me the CurrentRecordCount, CurrentFoundCount, and CurrentRecord. I have created navigation buttons for next, previous, first and last record. The problem is when I scroll very fast using the buttons I get this flashy thingy (actual technical term) thing goin on where my merge text is at. I know I have read something about how to fix this before but cannot find it. Can someone give me a hand or point me in the right direction. Thanks Brian
-
- 11 replies
- 1.4k views
-
-
I just don't get it, sorry... Two databases -- Main and Affiliates I want to create a portal in the Affiliates DB so that I can type in a "Domain Name" and have it fill in the "Account Status" field and the "Start Date" field from the Main DB. Then, down the road I will create a calculation field in the portal that will figure a commission for the Affiliate (based on the Account Status and the Start Date). Is this reasonable?
-
- 1 reply
- 929 views
-
-
I'm fairly new to working with portals...this may be one of those "duh!" questions... My solution keeps track of standards scores for K-6 students across their elem school career. I have a Students file and a Standards file. Both are related to the Reports file. I have my relationships set and my portals created, and everything works great when I import data from the spreadsheet where it is currently stored. However, in the future I want to be able to enter the data directly into the Solution. I have the relationships set to allow creation of new records. I want to be able to enter a Teacher-Standard-SchoolYear and get a list of that teacher's students with blank or no …
-
- 1 reply
- 934 views
-
-
Hi everyone, I was wondering if someone may be able to help me with a small problem. I have a three line self-relational portal and have dropped a button in the portal to open a pdf file relevant to the portal record on that line. The button works perfectly. However despite only putting in one button on the top line of the portal, with the expectation that the button will only be duplicated in the line below when there are more than one related records, Filemaker is by default revealing a button on the portal row below, even thought there is no document in that line. Any ideas? Your help is appreciated. Thanks
-
- 3 replies
- 1.2k views
-
-
You need to create another file (ValueLists.fp5) to store this information. It would contain EquipmentID, YearsSold. The YearsSold field can either be a single year per record or multiple years on seperate lines. Then create a value list relating by EquipmentID and showing the Years field. This will generate the value list from only the matching Equipment records in that value list file.
-
- 2 replies
- 693 views
-
-
I am trying to get data out of a portal. I have 5 fields in a portal I want to copy to the clipboard from a script the information lets say from field1 in portal row 1 but I can't seem to see how to do that. Am I just missing it or are portals just for viewing the data? Thanx, Thomas Lepkowski
-
- 5 replies
- 1.2k views
-
-
I made a solution based in FM Pro 3.0... My problem is the next: I have a database named "Credits".. in this file I save differents kinds of credits named "Credit1302", "Credit1304", etc. To differentiate the type of stored credit i have a numeric field name "$Credit" and other text field name "KindOfCredit" and a calculate field name "TotalCredit". The formula in this field are "Case( KindOfCredit="Credit1302" , $Credit)" Here all it
-
- 2 replies
- 1.3k views
-
-
Okay, so I'm just learning this FileMaker 5.5 stuff and portals are confusing me. Here's what I have. I'm setting up a database for our school that will allow us to bring together bits and pieces of information that are spread far and wide now. So, I have set up a series of files: (for example: 1. Demographic Data 2. Counselling Notes 3. Administration Notes 4. Classroom Teacher Notes 5. Resource Teacher Notes, etc. All are related by student number. Now not every student will have input from all these areas. However, there are some commonalities. Therefore, I want to be able to create a Report file that will bring together data from the separate files in the …
-
- 0 replies
- 835 views
-
-
How do you display a portal based on a relationship (Quote Number > Quote Number), but only display the quotes based upon another field which says "To Order"? More Info: I have a quote database that generates a quote number. The list of items for that quote are written to a Bridge file and carries the qutoe number for each item. There's a status field that is set to "Quote" at this stage. If I go back to the quote and wish to order a selection of the quote only, then I change the status of each of the items I wish to order to become status "To Order". Then I go into my Orders database and it generates a serial number (Order Number) and asks me for the original quo…
-
- 2 replies
- 1.2k views
-
-
Let me see if I can explain this clearly. I have one database (MetaDB) that contains unchangable data. When an item comes in to recieve it there is a second database (SampleDB) that a new record needs to be created for each item of that type recieved. So I have it set up that they create a new record and type in the item number. The item number is related and it pulls up a value list for the color name. That works perfectly. The color name is a pull down that gives them the list of red, blue, or green or whatever is related to the item number. The problem is that there is also a color code associate with each item number and item color name. These color codes a…
-
- 1 reply
- 852 views
-
-
I'm not sure if FileMaker has the capability for this, but this is what I'm trying to do. I have a main database with one layout which includes a text field (Equipment) and 2 portals (one directly on top of the other.) I use one portal with a relationship between the main database (using the Equipment field) and a second database (Generators). I then set the second portal to use a relationship again using the Equipment field to a third database (Golf Carts). So for the first record I match "Generators" for the Equipment field and the correct information is displayed in the portal (14 records are displayed.) However, for the second record I match "Golf Carts" for the …
-
- 2 replies
- 919 views
-
-
Hello, All! I was wondering if it was possible to clear fields if a checkbox becomes unchecked. For example, I have a value list attached to a field, and the field is formatted as a checkbox. One of my value list items is "Appointment Obtained" to report that an appointment has been set. Next to that item is a date field that I want the date of the appointment to be entered. Here's my question: Once a box is checked and a date is entered, if it is unchecked is there a way to clear the date field?? Just in case the appointment has been cancelled, or something. Any help is appreciated. Ken
-
- 1 reply
- 753 views
-
-
Hi there, I'll give you a brief overview, I've just finished a database, and one aspect holds date ordered notes in a portal (note,date,user,id_no are the fields in the related file) The relationship is specified to sort the date desending. Okay. It works, when I enter a new note it gets shuffled depending on the date perfectly. But, and heres the kicker, I imported about.. 10,000 entries into the portal for the clients, for some reason the portal doesnt sort these entries, only new ones. Can you think why? The date is exactly the same format. So basically if i were viewing the portal for X client I might get: code: Gone Fishing Dean …
-
- 8 replies
- 1.4k views
-
-
I am using ValueListItems function to get all the elements from a valuelist and put it into a global field and print it or export it.But I can't.I am using script setfield(VFL,ValueListItems("master.fp5","VLN")),where VFL is a global text field and VLN is the Value List Name what am I doin wrong here??? [ October 12, 2001: Message edited by: Jacob ]
-
- 3 replies
- 1.1k views
-
-
Have a file with daily entries of odometer readings for over a hundred delivery trucks. When the client makes a new record in that file, and enters the truck number, would like to have the last odometer reading for that truck number be automatically inserted in the new record. Can
-
- 1 reply
- 853 views
-
-
I have a simple database withseveral fields that are checkboxes. I want to be able to view records in a table layout, but the results of the checkbox fields are displayed vertically - only the first selection shows and the rest are separated by hard returns. If I select the field, all entries show, buut I want to be able to print the table for people. Is there a way to replace the hard returns with spaces or otherwise display the results in a horizontal field?
-
- 10 replies
- 1.7k views
-
-
Hey All! The solution I am making will be used by a lot of people who do not use computers very well. I went to some of their offices to fix their computers, and they had their resolution on 640x480! I changed it to 800x600, but when I went back the next day, they changed it back to 640x480. Anyways, I was wondering if there was some sort of script or plugin that can change screen resolutions. Dont get me wrong, Im not against those who use a 640x480 resolution, but the solution that I made with FM looks like kaka if it is on 640x480. Perhaps you all could help me with something to change the resolution to 800x600 or 1024x768?? I fathom this is a ScriptMaker question…
-
- 1 reply
- 991 views
-
-
I have a sales database with two seperate portals. One searches for a product code from stock control giving me stock available, price, description, etc. The other writes to a sales lineage database. I select the product in the first portal and enter required quantity. Then I click on a button "Add to Order" and it adds my quantity to the 'allocated' field in the stock control database and then copies the product code and quantity to the second portal and writes with it the invoice number, salesperson, client ID from invoicing database. PROBLEM: I can enter the first product perfectly. In the script I ask it to go to next portal row when entering the next copy and …
-
- 1 reply
- 942 views
-
-
Hi, I have three databases (more to follow), which include 1. Sales (invoices) database 2. Sales Lineage database - record per product sold linked to inv. no. 3. Stock Control - created product code, desc., price, commission, supplier name, re-order level, stock room level, allocated(sold), stock available(stock room level - allocated). The allocated can only be reduced once the product has left the stock room ie: delivered. The sales(invoices) database generates an invoice number, allows you to fill in the client info (or lookup from client database) and then enters you into the portal window where you are asked for a product code. This is written as a new r…
-
- 1 reply
- 959 views
-
-
I hope this is a better explaination There is 7 databases CLIENTS DATABASE - This database stores Client ID, Name, Address, etc. SUPPLIERS DATABASE - This database stores information on Suppliers like Supplier Name, Contact Name, Address, Telephone, Fax, Account No,E-mail & Web site and looks up from Stock database what products are purchased from this supplier. STOCK CONTROL DATABASE - This is a line entry database which includes Prod Code, Stock Avail, Re-order level, Stock Room qty, Allocated, Supplier (From the Suppliers Database), Retail Price, Cost Price, Description, Catagory of goods. It includes a flag to let you know if Stock Avail < Re-ord…
-
- 1 reply
- 1.3k views
-
-
Hi, when im in browse mode in FM on one of my databases, and i click the right mouse button, while the button is depressed, all the black lines (surrounding text boxes etc) turn to dotted lines, its just annoying enough to make me scream is there a simple way to make the lines stay solid all the time? Regards, Doobeh.
-
- 1 reply
- 812 views
-
-
I'm working with an Employee Database that pulls Job Updates from a Job Entry file into a portal, and sorts by Effective Date with the most recent entry on top. This information is in a portal on a layout that will be used for viewing only, so I unchecked the "Allow creation of related records" to eliminate the blank row at the bottom of the portal. It works great! However... I've now created the layout for updating the employee's record and want to add the information into the portal on this layout, rather than having to switch to the Job Entry File. I duplicated the portal relationship and checked the box to "Allow creation of related records," but when I view this new…
-
- 3 replies
- 1k views
-
-
Hi ppl. I need to know if any one out there knows (if it's possible) to hide the menu bar on FM. We are creating a database management soft for educational institutions and we want to give it a more professional look by hiding this area of the screen. I found options to toggle status area, text area, etc., but can't find one to hide the menu bar. For example, on Word you can select "Full Screen" to hide this (although you can close this view if you want to ) and I was wondering if with FM this is possible... Any one?
-
- 5 replies
- 2.2k views
-
-
First what I would like to achieve: - The body of a layout with a set background color. - A Portal with rows having alternate background colors My problem: In order to show the portal rows with alternate background color rows I set the fields in the portal row to transparent; however when someone edits the record (or uses find-mode) suddenly the fields show up in the color of the layout body. I tried putting an (invisible) white area behind the portal but this doesn't work. Only when I put a large colored area behind the complete layout with the body set to transparent the fields in the portal seem to use the color defined for the portal. This solution however is…
-
- 2 replies
- 986 views
-
-
I'm creating a hard copy of a database and one of the pieces of information I want to include is contained in a value list. Right now I've simply included this field as is (it is currently a check-box field). What I'd like to do is clean it up - have only those items that are "checked" to appear. So, while in that field of the database I have the options of "A" "B" "C" "D" and "E", if only "B" and "D" are checked, I'd like the hard copy report to have only "B" and "D". Can anyone help?
-
- 2 replies
- 953 views
-
-
Here is what I have to do.I have a file which has got product no & info.A person has to browse throught the items and using a check box add records into a value list.When he is done this value list is exported to another file and processing is done by removing the items from the value list.Is this possible.Can we add and remove items from a value list based on conditions.
-
- 3 replies
- 979 views
-
-
Its quite complicated, so bare with me while I try to explain... I'm working with three files; Jobs, Tests & Invoices. You make a job and give it a report title, and in the process of making that job you make tests to be carried out in that job. You finalise that job, then you invoice it. A job cannot be invoiced until it has been finalised. Once it has been invoiced (which is just a series of flags being attached to various fields), it is able to be printed. The Invoice file displays a list of all jobs that have been invoiced. Here's where we start to get a bit tricky... Once a job has been finalised or invoiced it can be unfinalised so that more tests ca…
-
- 1 reply
- 897 views
-
-
I created a db where I create invoices for multiple clients. I use pull down value list to find the clinic and item. The problem is the keypad does not respond to the numbers to autmatically go to the item. eg if the clinic is 169 before I would type 169 and it would go right to the clinic, but for some reason it will not work. If I use the keyboard numbers across the top of the keyboard it will work, but not with the number keypad to the right. any suggestions. My platform is PC [ October 08, 2001: Message edited by: David Newcomb ]
-
- 2 replies
- 933 views
-
-
I've got some 300 dpi graphics that i need to print. (Logos and such) to a non-postscript printer. I'm running Win 98 | FMP 5.0. I've tried several types of image files, (Insert: Picture). Looks great on-screen. When printed, I get horizontal lines throughout the image. -Yuk- Does anyone else have this problem. Any workarounds?
-
- 2 replies
- 969 views
-
-
I want to display Job Numbers with their Test price totals in a portal on an Invoice file. An Invoice can have many Job Numbers and a Job Number can have many Tests. So far I can get it to show the Job Numbers (duplicated as many times as there are Tests for that Job Number) and the Price for each test listed beside it. How do I make it list the Job Number only once, and the total for all the Tests in that Job beside it?
-
- 1 reply
- 838 views
-
-
This is often a sign that you have set up an auto-enter or lookup in the related file, based on information that can’t be available until after the record has been created, or a bad reverse relationship will generate the same message. You need to go through both files, check what you have changed recently! Did the relationship work before? Rigsby
-
- 2 replies
- 1k views
-
-
good morning all, i have created a layout format and want to insert a list view into a specific area of the layout. ie i need the list view to look like a portal. any help would be greatly appreciated.
-
- 4 replies
- 1.1k views
-
-
I've spent hours trying to figure this out, and looking for answers... Macinotsh FMPRO5 DB1: Countries.fp5 Fields: Continent Country DB2: Contacts.fp5 Fields: First name Last name Country "DB1: Countries.fp5" has a value list for the field "Countries" that I've called "CountriesValueList". I am adding countries to the "CountriesValueList" via defining the value list as the field "Countries". This works great. In "DB2: Contacts.fp5" I want to be able to access the value list from "DB1: Countries.fp5"; this also I have figured out by simply using the "CountriesValueList" value list from "DB1: Countries.fp5". (I bet you can guess where I'm goin…
-
- 3 replies
- 908 views
-
-
The reason I hardly ever make reports or layouts in columns is that my mostly beautiful interface design is hard to implement into these kind of layoutmodes. Undoubtly reports and columns are very useful once in a while. So is it possible to make a columned layout within my design (homemade statusbar, coloured back ground etc.) TIA Yeti P.S.I just thought how great it would be if you could import your own layouttheme, so that when you make a new layout you can incorporate your own!! A tip for a follow-up???
-
- 0 replies
- 820 views
-
-
I have 2 databases. One db contains a portal to records in the other database. Is there any way I can add records straight in the portal instead of having to go to the other db to create records? In other words I need a portal that allows you to add records as well besides just displaying and updating records from the other db. Would I have to write scripts? Your help and suggestions are much appreciated.
-
- 2 replies
- 1.4k views
-
-
I suspect this is pretty basic stuff... I have an "Orders" file with a layout containing a portal called "items_of_one_order". The portal works through a relationship of a similar name to a file called "Items." The "Items" file manages individual products from manufacture until they arrive in the customers hands (and beyond as a reference archive). Items are grouped and managed from the "Orders" file. Through the orders layout, the user can add and remove items from the "Items" file. Here's my problem: quantity of identical items. I want to allow the user to have a quantity field in the "Orders" file. But that quantity must correspond to 10 separate entries i…
-
- 2 replies
- 932 views
-
-
I would like to create report in one file that includes a portal list from another file. My problem is that it will only display a user defined number of rows. I need the list to display anywhere from 10 - 200 items but don't want to set the number to 200 because it would make printing unwieldy. Is this possible?
-
- 2 replies
- 957 views
-
-
My first Database with FM pro 5.5 I have a text field with a pop-up value list of types of deliveries (I'm an obstetrician) ie. normal deliveries, various forcep deliveries and various cesarean sections. I haven't assigned a field value to any of these types of deliveries but I did out of neccessity define a value list in order to make the pop-up. My problem is that I would like to extract the data as percentages of total deliveries, ie. percent forcep type, cesarean section, etc. Do I need to go back and make a portal to the field and loose all my entries or is there some way to get at this in perhaps a running tally. Keep in mind when and hopefully if you answer …
-
- 1 reply
- 1k views
-
-
short and sweet, what i do: calculated fields everything in the status area can be recreated. jeremy
-
- 9 replies
- 1.2k views
-
-
I am trying to make my layouts more pretty. So, I made a rounded-edge box to go around my text fields. Then I make the box a different color, and emboss it to make it stand out. Next I decide I want the background color to be black. So I select the header and body and make them black. Then, I send everything to the front so I can see it. It looks perfect.....that is until I switch to browse mode!!! The only thing I can see in Browse mode is my fields and buttons. The rest of the screen is black like I never sent the object to the front. I thought the fill pattern for my objects might be on transparent, but they are not. When I make the Body and Header color white, I can s…
-
- 2 replies
- 924 views
-
-
BACKGROUND: I have created a simple layout. Within the layout I have a global field with merged fields inserted. PROBLEM: When viewing the layout in browser mode and enlarging or reducing the screen the formating of line endings changes all around. How do I know which one is the right one? Help!
-
- 1 reply
- 777 views
-
-
I have a value list called "household" that contains the names of ten households in a club. They show up as radio buttons. Each member can belong to one and only one household. I need to develop a layout that shows the members name and household. But, each household name needs to print out as a different color. I know I can set the field to any given color as a general case, but how do I set the color of the text (not the field) based on the household. Basically, this is going to end up as a poster for an end of year party where people will get prizes based on the number of points they have earned for their various activities. The poster will be in order of highest poin…
-
- 1 reply
- 891 views
-
-
I have a database that draws one of its value list from a shared multi-user file on a server. When setting up the value list it gave me the option to select values from another file on the network and I specified the IP address of the server when choosing a host. However, the IP address doesn't seem to be part of the relationship. It still seemed to work ok so I went ahead and distributed the database to other people on my team. It works fine for most of them, but a few will consistently get a Database not Found error when opening it. When I go to their machine to try and fix it, I choose Hosts to find the shared file, but it isn't there. They seem to have their mac…
-
- 0 replies
- 839 views
-
-
reduce the spacing betwwen the lines? http://homepage.mac.com/theaxis/PhotoAlbum.html thanks in advance. [ September 24, 2001: Message edited by: axis ] [ September 24, 2001: Message edited by: axis ]
-
- 0 replies
- 774 views
-
-
How can i do to search some records that have portal rows with empty values?:
-
- 4 replies
- 1.1k views
-
-
I am a CDML newbie and I would like it if someone can help me or point me in the right direction regarding the following: I have a search page. On it is a search that includes a pre-determined FM value list. I know how to get the user to a search_results page after the search regardles of what search value they choose, but how would get the user to a results page that is customised to the value they searched for? Any help is greatly appreciated!!! Christine
-
- 4 replies
- 957 views
-
-
I'm trying to create a grid-type layout with Grade (K, 1, 2, 3, 4, 5) across the top and 16 different tests students take down the side. I want to be able to enter a Student_ID and display that student's test results throughout the grid. Each student has a unique ID, and each grade also. I have a calc. field which combines the two and 6 relationships based on these fields. I have 6 portals based on the relationships, all sitting side-by-side, displaying the test score. When I enter Student-Grade1 I get the scores for 1st grade, Student-Grade2 gives me 2nd grade, etc. What I need, however, is to be able to enter 1 Key and get all the scores in the 6 portals at the same ti…
-
- 3 replies
- 1.1k views
-
-
Here we go: I need to make a list of the data in my portal. for example: portal row 1: "a" portal row 1: "b" portal row 1: "c" needs to return: a b c in my calculation field How do I calculate this? Thankyou so much for helping me out!!! ------------ Thankyou for reading this message but I found my answer all by myself (like a big girl) The 'copy all script step' returns the values with a carriage so I can paste them in one text field...as simple a that, hopefully my question/answer will be usefull to some of you. [ August 24, 2001: Message edited by: michele ]
-
- 16 replies
- 1.7k views
-
-
Hello Everyone Here is the problem, I have two portal's no. 1. display's a list of the customers contracts no. 2. display's the notes / update to each contract. What I would like to do and havn't been able to so far is . To display the contracts in portal 1 as is , however. Only when a particular contract is highlighted within portal 1, I want to have FM sort which 'notes and updated" belong to that contract and only display them then. Right now all the notes and updates display in Portal 2 and it's not as clear as it can be. I seem to be getting lost within the technical jargon of my FM reference books, and conditional portal's etc. I figure there needs to be som…
-
- 1 reply
- 901 views
-
-
I need to create a performance report to Washington for my grant and they are currently using Access and I'm using Filemaker! I can export my information from Filemaker to send to them via email but I'm confused on how to do the following. I currently have a database that contains student information. In my database I have created radio buttons for the following three items - school, gender, race/ethnicity. What I have to report/export to them is different than the simple x-school/y-school; male/female; White/Hispanic. Washington requires that the number 1 entered for male 2 entered for female and so on. They will not accept male or female; white or hispanic. It ha…
-
- 1 reply
- 863 views
-
-
I know that you specify sort order in the relationship setup of the database but I have a specific problem, that may mean that I do not or can not use a portal. I have created a media database of several video files, with thumbnails in the records for visual identification. I have now created another database to create playlists of the media files. I need to be able to display certain media files through a portal (which I have completed using a repeating playlist ID field in the media database). BUT I need to be able to re-order the displayed order of the media files in the database. Anyone got any bright ideas? Joel
-
- 1 reply
- 914 views
-
-
Hi all I want to Translate selected item in popup-list to another layout? How do i return a value from a value list to a text field or po-up list? Im doing a dokument in swedish in the first layout and a english in the second layout I want to automatize also inputed value
-
- 2 replies
- 890 views
-
-
I would like to know if I can view a value list from another file and use it to insert values into a repeating field in a second file, also keeping the value list editable from the second file. It would be a value list of songs in file (a) which is related to file (: via date ranges/client and is used to create set lists for shows by artists I work for. I originally had numerous fileds in file (: that would contain the songs but I think I have finally found a useful and sensible way to utilise a repeating field for once as this info never needs to be separated. This mod would help me clean up file (: a bit and connect the songs to the artist in a more direct way, allow…
-
- 3 replies
- 869 views
-
-
I'm not sure if this is the right place to ask this question... I'm working on a solution which tracks a student's score on 16 different possible tests taken in elementary school (K-5). I have the following files: Students.fp5 (contains student name, student_id, grad year, race, gender, etc.); Tests.fp5 (contains student_id, test name, test score, schoolyear and various calculated combinations, such as studenttest, testschoolyear, studentschoolyear, etc.) My last file is Reports.fp5 which contains student_id and relationships to Students and Tests. Using portals I can get most of the information I want. However, I would like to create a grid-type layout which has the t…
-
- 3 replies
- 1.1k views
-
-
Hi people. I was wondering if you could help me out with this idea I have been working on and how to implement it on Filemaker 5. I have a Product database where you can assign three 'Keywords' to describe what the Product is. I have three fields in my Product database; one for each keyword. These will be called Keyword1, Keyword2 & Keyword3. What I've done so far is to create a new layout. On this layout I am planning to place a PORTAL (yep, you've guessed it) that will show certain products that have specific keywords. In my Product Database I have two calculation fields. The first is: - Keyword1 & " " & Keyword2 & " " & Keyword3 The other calc…
-
- 2 replies
- 859 views
-
-
Hi After setting up three tiered conditional value lists I have been asked to make the lists modifiable by the user from the master file (similar to as as you would a custom value list). Is there a way to do this? I have two files, the master file and a value list file. Within the master file I have set up two relationships and two value lists to support the conditional system. When Field A in master file equals Field A in value list file show options XYZ in Field B. When Field B in master file equals Field B in value list file show options JKL in Field C. Fairly standard. I have allowed the creation of related records from the master file in the both of the relatio…
-
- 2 replies
- 872 views
-
-
I'm trying to make a pop-up list or equivalent that will let the user select a color (1 of 10)for a record. Any simple ideas?
-
- 1 reply
- 826 views
-
-
Hello I published this question a couple of weeks ago in the Import & Export-forum. But I got no respons, and take it nobody knew what to do. So I take a chance with you portal-guys instead. I am really eager to know if it is possible to solve my problem. I have no experience what so ever with portals. Here is my question: I maintain a list of journals, which are managed by FMPro41 and Web Companion. A part of the list is created by importing an Excel-file provided by a database host. This list contains a lot of journals. For certain reasons I would like to be able to: a) import match, and replace information in a record that in a certain field is identical whereas…
-
- 6 replies
- 977 views
-
-
Help!!! I have a database that uses Radio buttons to mark some pertinent values....my problem is that they make the database pause until they refresh or something...... Anybody got any cool ideas?? Ive tried font usage, widths, etc.... Thanks in advance!!! Billy
-
- 2 replies
- 856 views
-
-
I have Elements listed in a portal on a layout in my Projects file. I want to force the users to use a button I have created called "Create New Element". It is attached to an extremely important script. The users are in the habit with this and other databases of simply going to the last row in a portal and typing to create the related records. Is there any way to hide this row, or lock it, or attach an error message or... something? I even put a large red note on the layout. Oh, and earlier tried a message that appears directly before entering the layout instructing them to do so. They read it and heeded it once and then fell back to old habits. It just doesn't matter how…
-
- 3 replies
- 2k views
-
-
Hey kids. Here's my situation: I have a file called Bookmark Manager.fp5, with two value lists. 1. First value list: Category from field USR_tCategory. USR_tCategory is a text field that the user either picks a category from the value list, or types in a new one. 2. Second value list: ViewAs from field KEY_cViewAs. KEY_cViewAs is a calculation field for the sole purpose of providing a value list to search USR_tCategory (through a relationship). The calculation for KEY_cViewAs is: "all by category" & "
-
- 2 replies
- 929 views
-
-
Does anyone know how to maximize the actual filemaker application window so that it takes up the entire screen area? I'm working in Windows. One can control the size of database windows, but can one control the size of the application window? Thanks
-
- 1 reply
- 2.4k views
-
-
Greetings to all! I wish to access a large collection of medical articles saved in pdf for consultation. Actually, by clicking a row in a portal I call a script which looks the path of the article on the disk (file:///HD:documents: file.pdf) and, in cascade, by opening Explorer, calls Acrobat to view the file. The procedure seems to me not too much elegant, but I cannot do otherwise: e.g. to open the documents directly from FMP without passing through the browser. Is there anybody who can give me a help? Thanks a lot! Antonio Perasole
-
- 2 replies
- 877 views
-
-
Hi people... Here's the scope. I have this little script that goes loops through the portal rows adding up a field to make a total for another field outside the portal. The thing is though that when the loop goes down to the X amount of rows viewable on portal. (as in, the viewable amount of rows in a portal), the script bombs into a uncontrollable loop. Anyone know what's the cause about this? Any tips? Is it me? (probably). Steve Griff
-
- 3 replies
- 1.3k views
-
-
I am new to the web companion and am using FM 5.5. On certain fields, when I create a new record and insert text in some fields, the web companion adds a carriage return to the text automatically. Whenever I even try to edit an existing record, it also adds a carriage return. I've compared the fields for when this happens and when it doesn't and I can't find any difference. I've tested this when the database was hosted by a Mac and a Windows 2000 machine. They both do the same thing. Has anyone else run into this problem? Am I just setting something up wrong?
-
- 0 replies
- 716 views
-
-
Hi, again: In my DB a user needs to copy information to a portal without having see the portal, it is possible to do this with a Script... He needs to copy of three fields towards the portal which contains six fields, the first three fields used, by which I need that he copies in the field 4, 5 and 6.. It is important that they are copied in the empty fields, for example, in my portal(See above) I have 2 records of which 1 do not have descripcion in fields 4, 5 and 6 he begins for the record 2 field 4... PORTAL FIELD1 FIELD2 FIELD3 FIELD4 FIELD5 FIELD6 VALID VALID VALID VALID VALID VALID VALID VALID VALID EMPTY EM…
-
- 3 replies
- 1k views
-
-
I'm building a DB to manage distribution of my clients product into a network of retail agents. To do this I've created two files. File one contains my six clients. File two contains the details for the retail network of 5,000 agents. I've created a relationship between the two by adding a "key" field on both files which auto adds the letter "A" to the field for all clients and agents. This allows me to create a portal on each agent (file two) record which displays a list of the clients from file one. While all the retail agents are used by all clients they categorise them independantly (A, B, C, etc.) based on sales performance. My problem is this. Is there a way to…
-
- 2 replies
- 880 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online