FileMaker Interface Features
-
I want to break some fingers. I want to be sure they have filled out a record right before they are allowed to leave it. I have script to check their entries. But instead of using my button to Close, they x on the dumb window and leave things undone. How can I stop them? Does 7 have ability to let me keep control and not let them close it until I let them? I didn't notice it before because I never used windows like I am in 7. Not sure how to control our staff. Pete
-
- 24 replies
- 3.3k views
-
-
We often place multiple buttons along the top of our headers to launch specific scripts. On some of our layouts thre is now quite a bit of buttons collecting up top. Are we able to create a value list which upon selecting an item launches a particular script : This is similar to what we find in Microsoft Access drop down menus. I am a newbiw with many of the new features in FM7 and passing parametrs around. Any help is greatly appreciated. It would eliminate a lot of button clutter.
-
- 16 replies
- 1.9k views
-
-
newbie. i need to make a checkbox in one of my layouts. i want ot have a box that has a small, blank box named "conventions". when a particular file is convention "worth", i want to be able to take my mouse and click on the box and an "x" will appear. how can i do this?
-
- 2 replies
- 891 views
-
-
This is a followup to a post I placed in the "define fields" forum. I still have not been able to get a workable solution to my problem described below: In the database that I've created, i have a Table of Samples related to a table of Labs via the Lab Field. Each sample is collected in one of 6 container types that I have listed in a container field with a value list. The containers are supplied by the Labs. I would like to sum how many containers of each type I have in my sample table and have that value reported on my Labs table. In other words, Lab X needs to send me Y 1-gallon jugs. I could not find an easy calculation to do this. Is there a way to do a con…
-
- 1 reply
- 700 views
-
-
I have created a button (that performs a sort script), and have placed it on the layout. Now, what I want it to do next is that, when that page is printed, I don't want the button to appear on the printout. How do I do this?
-
- 2 replies
- 998 views
-
-
I feel a bit embarassed asking such experts - but I've used FM Pro for years and it's about time I REALLY used it (If you know what I mean) I want to get percentages from value lists - ie: how many times someone chose an item on a list. I can see the results from a find, but what calculation or formula should I be using? Thanks very much.
-
- 5 replies
- 923 views
-
-
I have always used the following technique to jump to the related file from a portal record. In the Portal is a hidden field that is the serial number of the portal record. Serial Numbers are automatically assigned. There is a button in each portal line so that it selects the portal row and does the following Script: Enter Browse Mode Copy Serial Number Perform External Script in the Related File The script in the Related file is as follows Go To Layout that has the serial number in the layout Enter Find Mode(No Options Checked) Paste Serial Number Perform Find(No Options Checked) In all of my development I have used this technique in a…
-
- 3 replies
- 1k views
-
-
I currently have a portal that is sorted by last modified/creation date/time which is fine for most cases as the most accessed files get high ranking etc. But I want to set it up so that the order stays the same unless the user specifics one to go to top? What is the simplest way to sort a portal Thanks
-
- 2 replies
- 698 views
-
-
I want to use a table for a lookup field on a data entry layout. My problem is that when I select an item from the popup list, a new record is created in the table from which the popup list derives. I want it to enter the original id from the lookup table into the main table. Example: I have a database with Recipe as the main table and several related one-to-many tables: Source, Course, and Ingredient. E.g.: Source has a unique IdSo_pk serial primary key, related to IdSo_fk in Recipes and so on. On a data entry layout based on Recipes, I have lookup fields for each of the related tables. For example for the Source field, what I want is to select
-
- 1 reply
- 672 views
-
-
I have a portal which reveals only 20 of 100's of records. When I move from this layout to another AND back, the portal always starts with the first sorted match. I would like to scroll through the portal, select a record, say #500, go to another layout and then upon return have those 20 records still be in view. Good Day, All
-
- 3 replies
- 619 views
-
-
In the invoicing system I'm working on I'd like to have a portal on a customer record that shows what products they buy. There should be one line for every product code they've purchased, and a sum of the number of units bought, and total cost. Is this even possible in a portal? The only way I know how to do it now is with Summary fields in preview mode?
-
- 0 replies
- 751 views
-
-
Hi, I am trying to automate the printing process. I have a form where I need to make a button that will allow you to perform a find first, and then take those results and print a report. I'm not really used to the layout system yet (coming over from MS Access). I make my printing layout so it looks right, but it looks goofy as a form view... only having showing one record. I don't want to confuse the user, so how can I make it so a certain layout (the final printing one) is ONLY in list view? I would like to do that and have a button to perform the search, then take those results and send them to the LIST ONLY layout... is this possible? Thanks Vandy
-
- 1 reply
- 906 views
-
-
Hi guys, I have a portal that is supposed to display surveys that a Contact (individual) has taken. I dont track individual surveys the users have taken instead I track the answers for the questions on the surveys. The User Answers table has a questionId, an answerId, a surveyId, a contactId, and a date taken field. Now what i want to display in the portal are records with distinct surveyId and date taken pairs. In SQL this is easily accomplished, but I am having trouble getting it done in FileMaker. Thanks in advance for the help.
-
- 3 replies
- 699 views
-
-
Is there a way to get field borders to be non-printing? Whether I use borders, baselines or embossing, etc. the borders always print. For my interface I'd like each editable field to have a light gray box around it, but so far in order for it not to print I have to draw a box around the space or duplicate the field and make it non-printing. Is there a workaround for this? Thanks! Espen
-
- 1 reply
- 891 views
-
-
In a calculation field that simply concatenates text from several fields is it possible to maintain the text format from each of the fields. That is, some fields have some italicised and some bold text in them but the calculation field only returns plain text. I can not get this to work in a single file but the follow up question is whether the solution will work when the calculation field is in a portal to another file. Regards, Ian
-
- 3 replies
- 705 views
-
-
I have a layout containing 2 subsummary parts in a database containing different products. The first should sort on a broad type (for ex: cables) the second should take the cables and sort them by cable type (ex: audio, video, etc.) and display the information for the 1st item in the list. Then under that subsummary it would show a list of all of the Cables that were audio. But for some reason it is losing it on the 2nd subsummary. It should be Cables __Audio ____Audio 1 ____Audio 2 __Video ____Video A ____Video B But what it is doing is Cables __Audio ____Audio 1 ____Audio 2 ____Video A ____Video B Any idea what I am doing wrong…
-
- 4 replies
- 956 views
-
-
Is it possible to make filemaker start a new page when the data within the body tag exceeds its own part size and page boundaries.I am currently creating a studio manager for an advertising company and am currently restricted to one page for all my layouts and reports. Any ideas people?: Oh yeah and im new here, hello everyone
-
- 5 replies
- 1.3k views
-
-
I'm not sure if I should post here on on the wish list. I don't see a way to customize text presentation in value lists, such as having some values italics, subscript or superscript, or mixing fonts. Is there a way to do it that I'm not seeing? Does anyone else have this need? Ed
-
- 1 reply
- 705 views
-
-
Hola everyone, Anyone know of a way of getting the FM graphic ruler to begin at position 0? If I go into layout mode and enable the graphic ruler, it begins at the "true edge" of the page according to my current printer configuration. So, the first x number of pixels on the left (could be 8, could be 18, could be anything) are considered to be the gutter and usable area of the layout doesn't begin there. It makes it tougher to position items if I can't rely on even numbers. I.E. if I want to make a 500 pixel wide window and my printer def is currently an Epson Stylus Photo printer, I have to wrap my thinking around an 8 by 508 working area. If I change to…
-
- 2 replies
- 1k views
-
-
Hi I hope I'm in the right forum. Does anyone know what might cause sliding fields to stop short of the bottom of the text in the field - by about half a line of text(in preview mode)? it's a mystery to me why it is happening, and causing printing problems at page breaks. thanks!
-
- 4 replies
- 1k views
-
-
I can't seem to make the ToggleWindow[zoom] script step work the way I want it to. The doc says that zoom resizes the window to the last previous defined window size. I thought that the way to "define window size" was to go to layout mode, resize the window by dragging the lower-right corner of the window, and then go to browse mode. However, the ToggleWindow[zoom] step still resizes the window to something else. I obviously haven't found the magic sequence. Can someone offer a recipe for creating a script that goes to a layout and resizes the window to a specific, fixed, window size? Thank you, Chap
-
- 2 replies
- 995 views
-
-
This problem is mostly a relationship issue, but the main problem I am having is that I am trying to use IWP to publish my database, and I was told that using a portal would eliminate the problems of commiting each time you edit a record. I want these records to be in list view, so that someone online can just click on a field in a particular record, edit it, then click another field in another record. The problem is, in FMP 7 and IWP, you cannot do that. You must click on a button that commits the record you just edited before clicking on another field in another record. So, if I use a portal that shows all the records in a particular table, based on the zk.constant o…
-
- 0 replies
- 916 views
-
-
I've thrown this out there before but got WAY sidetracked with a million other projects. Now I'm ready to revisit it and I'm not that much smarter this go around! Currently we use Excel spreadsheets - one file for each of the 10 employees. These spreadsheets have one line for each 30-minute increment - Sunday to Saturday. Each week a new spreadsheet is created via a Macro for the following week for each employee. As a temporary solution, I have a "holding" database that imports these spreadsheets each week, cleans up blank records, validates job numbers and spits out all sorts of reports. Then all records get dumped into a "history" db and that's that. …
-
- 3 replies
- 886 views
-
-
Part of my solution has a contacts portion. There are two distinct type of contacts that MUST be entered and managed in separate layouts (eq Students, and Teachers). The common fields are feed into shared tables. (contact, locations, numbers) and keyed with either a Student_ID or Teacher_ID. TABLES: Students Teachers Contact Location Numbers Teams RELATIONSHIPS: Student -> ContactInfo -> LocationInfo -> NumberInfo Teacher -> ContactInfo -> LocationInfo -> NumberInfo MY CHALLENGE: The DB now has a table called TEAMS which will pull information from the contact table, since teacher student status is irrelevant. But the loca…
-
- 1 reply
- 1k views
-
-
Anyone know if it is possible to make a portal appear and disappear based on a relationship? What I would like to do is have 2 portals one on top of the other, but only one active and visible at a time, based on a global field that has the 2 related choices. I know one workaround would be to have virtually identical layouts, one with each portal, and when the user toggles, they don't even know they have changed layouts, but I would rather not do that. Any thoughts / ideas are greatly appreciated...
-
- 0 replies
- 767 views
-
-
I'm trying to create a salutation field which will be populated from a value list. The options should be Mr. and Mrs. Smith, Mr. Smith, Ann and Mike, Mr. and Mrs. Mike Smith, etc. What I have now is a value list from a field, which is a calculation based on the name and title fields. How can I make that value list more than one item long? I guess this is asking, if I'm doing this correctly, how do I make the field have several values? If I'm not doing this correctly, what can I do instead?
-
- 3 replies
- 884 views
-
-
Say i had 2 fields one field was TYPE and there was 2 options A or B and the second field was Spec (for instance) and for TYPE A the options were either 1 2 3 4 5 and for B there was 6 7 8 9 ok! How do i set it so that if TYPE was A and not have the options for B (ie 6 7 8 9) appearing the second field? You get what im saying?
-
- 10 replies
- 1.2k views
-
-
Working with Win XP, FMP 6.0v4 Example: 1.08, 1.08, 1.08, 1.09, 1.09, 1.11, 2.01 the aveage of these = 1.22 Peoples names in my data base, each name has 10 different fields, each with data in them from 1.00 to 16.12. (all whole numbers will be between 1-16 and all my decimals will be between .00 and .12) Question is how can create an 11th field and add up the other 10 fields finding the avage of the 10 fields with special regaurd to the decmials (Ave, the Whole numbers/and ave the decimals by themself)? Currently when I ave; I get a result of 1.22, because it ave all the numbers with no regaud of keeping the whole numbers seperate from the decimals. Wh…
-
- 27 replies
- 2.4k views
-
-
Hi all, I am a beginner FileMaker user and I am a little bit lost. Any help will be apreciated. I have two tables: software and versions. Software table has two fields: sw_name, sw_description. Versions table has 5 fields: Name, description, date, file and sw_name. I have created a simple relationship between this two tables with sw_name as matched field: 1 version is related to a specific one software and a specific software has N versions. Then, I have a layout with 2 value lists: Software value list, and versions value list. Software list is defined with "include all values", and versions value list is defined with "include only relat…
-
- 0 replies
- 782 views
-
-
I entered a label on a layout and put a border around it. Now FM won't let me back into the border function to remove it. Strange. Any ideas. TIA Ivan
-
- 5 replies
- 1.3k views
-
-
See attached I want to be able to highlight specific people in specific companies. The problem is if a person belongs to more than 1 company it falls to bits. Anyone got any ideas on how I can make this work? Basically if the number in gSortFirst is the number of the contact for the specific company which should be at the top (sorted) and highlighted? Thanks highl.zip
-
- 2 replies
- 877 views
-
-
ok.. I have some value lists that are based off of fields. the problem is that any value in the field that is over a certain length, doesn't seem to want to show up in the value list. If I put these same values in a regular value list it works fine.. very odd problem.
-
- 10 replies
- 1.6k views
-
-
Hello, I'm making a database using portals. My Problem is 'I can't see anything in a portal' sometimes! But, this is not a problem of connecting or finding DB data. When I create a constant letter field (which you can make by clicking the button which face has 'A') and move into the area of portal(the portal container) Then , I can't see this 'Constant field' in the Browse mode Of course when I move the 'constant field' out of the portal container I can see it clearly. But when I try to put this field into another portal in the same layout , I can see it in Browse mode. I tried rearranging many times by moving back and forth, but obviously this i…
-
- 2 replies
- 878 views
-
-
Hi, Sorry for asking something so trivial, but I don't figure out how to rename a button in a layout. It is often useful to do a copy/paste, but the new button has the same name than the button that has been copied. How to change this name? Thanks for your help, Pierre
-
- 2 replies
- 931 views
-
-
I don't know if anyone has tried this before, but I'll throw it out there... In my never-ending quest to save layout space, it hit me that I could really squeeze a lot more on a layout if I could only do away with pesky labels. This is so basic I can't believe I didn't think of it before. I create a calculation label_FieldA = case(isempty(FieldA),"Field A") On the layout I then place label_FieldA directly on top of FieldA as a merge field. I center it and make the text light grey. So if the field is empty the user sees the label. Once it is filled in, it is obvious what the text is. (I'd only use this in cases where it really is obvious what the data …
-
- 9 replies
- 1.5k views
-
-
Hi I've created a value list "Photo Size" containing values such as 2 x 35 2 x 45 2 x 55 How do I relate the value selected to a numerical field For instance if someone selects 2 x 45 from the value list I would like 100 to appear in the numerical field. cheers Dave
-
- 2 replies
- 691 views
-
-
i have a drop down list that wants to stay open even after you make a selection. ussually they close after i make my selection, this one just wants to hangout there, until i click somewhere else.
-
- 2 replies
- 962 views
-
-
I have a file called "sales" showing sales for different companies for two products - A and B. The two products have to be in separate detail files as they have different pricings and definitions. I want to produce an invoice in "sales" showing all sales for both products. I can make invoices separately in files A and B but I can't produce a combined invoice in "sales". I currently have a layout in "sales" with portals for A and B, but when I come to show the results on an invoice the layout doesn't work. I have tried the sliding/printing but some of the portal results for product B are over 200 and my layout cant cope! Is there a way I can have two body and tw…
-
- 0 replies
- 889 views
-
-
I have a portal with 5 entry, for example, how can I get all the ID's for all 5 entries in to one field. Can anyone help? Thanks
-
- 2 replies
- 680 views
-
-
I have a basic fundraising database for a non-profit org I'm helping. I have a set of fields defining bio info, contact info, etc. They want to have info on the spouse (in the same record), if there is one, but not to show the fields for this is there is no spouse. My thought on the way to do this was to have two layouts, and change between the single layout and the married layout based on the content of the marital status field. I created a script that does this, but I want it to run automatically. Is there any way to trigger a script on the changing of a field? I don't think there is. If not, is there any way to have my fields only show up if someone's marri…
-
- 3 replies
- 1.1k views
-
-
I'm a newbie to FMP6, so I hope I haven't missed the answer when searching! I want a field that holds a serial number but displays as a text string. For example, the field Students:course contains an ID number relating to a record in Courses:courseID, but displays as Courses:courseName. [Hopefully my pseudo-syntax is clear? Database:fieldName] In edit mode, Student:course should produce a pop-up list or menu of all Courses:courseName, and plug the corresponding Courses:courseID. In display mode, it should display Courses:courseName based on the courseID that's actually stored. I know about creating dynamic value lists for formatting that would display ID …
-
- 0 replies
- 836 views
-
-
Hi ! I am a newbie about filemaker,. I have 1 database (drawings.fp5) with drawingnr 100-110. And i have 1 database (Releases.fp5) related with drawingnr. This database contain multiple 100, 101, ... drawings. In drawings.fp5 i have a portal showing releases 01,02, and so on. When user press new release in drawing.fp5 i want filemaker to autoenter release 03 in portal. I can
-
- 1 reply
- 683 views
-
-
I've got a radio button field displaying a value list. The formatting on the field is set so that "Other" is allowd. When I click on the other entry (in the radio button) I get a dialog that pops up and I enter some text and if I look inside the field the value is there...however the radio button display does not add this new entry to the list....and that's what I want. I suspect that if I define the value list (which is displayed as the radio button field) as getting it's value from a field ...that it would allow me to dynamically add to the radio button. I've played some with that approach but nothing quite works..anyone got a solution to this?? thanks..Sandy
-
- 1 reply
- 784 views
-
-
I am attempting to create layouts in a FileMaker database to print CD and Cassette labels. I have a background graphic created in Photoshop that consists of a photograph and a logo. This design prints very nicely on an Epson R300 printer from PhotoShop or Preview, but prints at a totally unacceptable resolution from FileMaker. I've inserted the picture in my layout in every file format that FileMaker supports, but all of them print equally poorly. Surely FileMaker will allow me to print good quality graphics on a layout, Right? What am I doing wrong? Thanks for any help you might provide.
-
- 2 replies
- 1.1k views
-
-
Not sure if this is related to layouts or printing but... I have been asked to fix a FileMaker Pro database that contains cassette labels. Each has an A and B side and a unique catalog number. Generally we need to print out the A and B side of one cassette at a time and we want to fill the page with the repeating labels--twelve to a page total. So we do a "find" on the catalog number which brings up the A and B records. We have a label layout for printing which we choose. When we preview, we only see two labels filled in--the A and the B side just once on the page. What we want is to have the page fill with six of each to fill the full 12 slots on the page. Do I…
-
- 1 reply
- 1.1k views
-
-
I'm trying to print a muiti-page form (with merge fields). Each has different fields, etc. Anyway right now I have each page in it's own Layout. is there a way to combine all the layouts into one? Is there like a "page break" function in FM that I'm missing? Also the curly line that's supposed to tell you the dimensions of the page is off. How can I change it? I tried page Setup, but the page is set to the correct size (81/2 x 11). I have no margins and the bottom line is sitting at 9 1/2. Thanks...
-
- 2 replies
- 1.3k views
-
-
All the hoopla about FM7, and I still can't create a darned transparent graphic. I've tried creating them in PaintShop8, Corel Draw10, and PhotoShop.. I export them as PNG or GIF, but when I put them on the FM7 layout, I always get the white background. I need the step by step guide on just how to do this. I know the old rotate trick in version 6, but I also know that if I can create the correct graphic, it will work... I've used someone else's PNG file and it worked just fine. I'm on a Windoze machine... pleeeeaaaaasssee help..... FileMaker Version: 7 Platform: Windows XP
-
- 9 replies
- 2k views
-
-
Hi all, Hope you can help me out on this one. I have a portal set up based on 2 databases: Parts Replaced New Jobs This is setup for PC repairs. As a part inside a PC is replaced, a new record is added to the parts replaced database - Serial number of PC, Part replaced, Date replaced - this works out the new warranty on that part (Part replaced + 12 months) Now, when a new job is added onto the New Jobs database, the serial number of the PC is entered into the DB. The portal is designed to show all parts that have been replaced that are still in warranty, obviouslt getting this information from the parts replaced DB. I setup a field in Parts …
-
- 1 reply
- 837 views
-
-
Aaahhh! I've just spend days creating this relational database that has an portal on an "invoice" table showing what employees (and their hours and rates), as pulled from a timesheet table, comprise this invoice. What I need to do now is print invoices that show this employee/hours/rate/subtotal portal. It works fine unless I have more employees on a job than will display on one page. In that case, only the records that fit in the portal display. I found a tech note on filemakers site (104457) that talks about multiple page portal printing, but it's really really cumbersome, scary, and old (six years old). I've also read something about printing from portals i…
-
- 9 replies
- 1.4k views
-
-
I've seen a few people frustrated by this, as I have been, without any really clear answers. So I sat down and figured this out this morning. Hope this helps anyone else who has been stuck on this. The behavior of drop down lists has changed in FM 7. In FM 6 if you set up a drop down list from a value list, and the value list was set to also show another value, and sort by that 2nd value, then typing in a field would take you to the 2nd value. For example, if you have a list of ID numbers and Animals, where the value list is sorted by the animal name rather than the ID number: 1 Ape 6 Bat 3 Cat 2 Dog 5 Elephant 4 Frog Type A and Ape is hig…
-
- 5 replies
- 1.5k views
-
-
I'm new to filemaker but I worked MS Access and bDase before. I'm a little stuck on the conversion from one program to the other. In Access you have a query tool. I guess in filemaker the query tool is replaced by the valuelist. My problem: I have a table "COMPANIES" and another ""INTERVENTIONS" In the table "COMPANIES" I have a field "company" and a field "relation" (relation is a valuelist wich could hold many values (dealer, client, relationtype3, relationtype4, and so on) In the table "INTERVENTIONS" I made a field "dealer". In access I would create a query that shows only the records from "INTERVENTIONS":"company" where the "relation" of the company…
-
- 5 replies
- 798 views
-
-
What I want to do seems so simple I can't bring myself to believe that FileMaker can't do it. I have a report with a header and a footer and subsummary parts that I want to print out to look like a table. the problem is, the table part consists of four columns per record that vary in length. I can set field borders, and if all four are one line each it looks right. But if one of the columns is two lines, then it alone expands, and the other three show a line at the one line point - meaning there isn't a continuous line between that record and the next. How can I create a table that will expand the borders for all four columns (fields) based on the largest field in th…
-
- 2 replies
- 1.1k views
-
-
I have created multi page invoices and am having problems showing the totals. If I put them in the footer they show on every page which is wring because the total of the line items will be ALL items not just those on the page. If I put them in subsummary or Grand Summary they plonk themselves directly under the Body and I want them to always be at the bottom of the page. I am clearly missing something fundamental but do not know what! To summarise I want one total per invoice on the last page of the invoice AND at the bottom of that page. Thanks all I am learning loads from this forum just by reading
-
- 1 reply
- 1.4k views
-
-
Is there a way to get filemaker to update an image every second (or more frequently)? The image in question would be on a local server. The purpose would be to allow (all be it slowly) all clients on a network to view CCTV cameras. Many thanks.
-
- 0 replies
- 779 views
-
-
Is there a way to get two-columned Value Lists to be neatly vertically-aligned (in FM7)?___ The second column should be vertically aligned, rather than zig-zag'd. They look messy, and are harder to 'read' .
-
- 4 replies
- 793 views
-
-
I just got Filemaker and this is the first time I'm trying the portal capability. I have a table Dogs, with one entry for each dog. I have one table for Vet Visits and one table for Shot Records. The linkage between these tables is Dog Name. On the Dogs layout, I created a portal to Vet Visits to show date of visit and reason of visit. I created another portal on the Dogs layout to Shot records to show shot and next due date (calculated in the Shot record). On the Dogs layout, no data is displayed from either of those 2 tables. Seemed pretty simple to setup, but there must be something simple I am missing. I'm stumped. If someone wants I can send …
-
- 4 replies
- 816 views
-
-
Okay what I basically want to do is be able to assign 1 row in a portal a different colour and make it stay at the top of all the other portal entries? Does anyone know how this is possible? Thanks
-
- 3 replies
- 841 views
-
-
Ok this is my problem I have a database with a portal for topics in which a actual schools class will cover. So lets say the main database is "descriptionOfClass" and the database in which the portal comes from is "topics" (there are only 8 at most topics in this portal) I want the person to be able to create a new class which means they will have to add topics to the "topics" database(the portal) as well as add the information to the "descriptionOfClass" database hopefully on the same page and form. Also when they go to edit this information i want the topics to indiviually or in one box be able to be outputed in a text box, many text boxes, or whatever it will be abl…
-
- 0 replies
- 632 views
-
-
I want to go to the last row in a portal and copy a field to the layout where the portal resides. I have a quote file that stores quotes by date. I want to display the latest quote on the master inventory layout where the quote portal resides. This will give at a glance the latest quoted price for this part no., even thou it is in the portal. The portal is sorted by date, therefore the latest quote will always be in the last row of the portal.
-
- 3 replies
- 847 views
-
-
I have a simple one-to-many bibliography db: one author, many titles. I am unable to recreate in FileMaker what seemed transparent in MS Access. I created with no problem a layout with a title portal for data entry. I am unable to create a report that includes more than the first title from each author (columnar layout with title sub-summary). I understand from one of the other Forum discussions that portals are not intended for reports. Likewise, if I do a find for any of the title fields, it returns the first title only (although the second or third title holds the searched for information). Obviously I am doing something wrong and would appreciate any suggestions…
-
- 0 replies
- 869 views
-
-
I am writing a database to generate pupil reports for my school. The structure includes a database file editable by a department that is the source of pup-up lists for the separate report generating file. However, I seem to have a problem that text longer than 254 characters is cut off when I do a look up using a pop-up list in the report generating file to grab data from the other file. Is there a limit to text fields when using look-ups or is there a way around this? Thanks.
-
- 4 replies
- 728 views
-
-
I want to be able set up my current database so that when you view a file you don't lock that file. I was thinking that I could have it switch between Preview and Browse. So intially it would take it to the record and be in preview mode and then once clicking on "edit" button would take it in to browse. However... 1. Does previewing a layout mean that a record isn't locked and someone else can edit? 2. Can preview be increase as the preview of A4 isn't big enough for my layout? The only other solution I know is to duplicate the record and have it so that the fields are editable - but I didn't really want to duplicate layouts as this is tedious if subtle cha…
-
- 1 reply
- 1.1k views
-
-
Hello to all portal masters! I have a portal in FILE-A that displays the related records from FILE-B. The portal shows the field "Tenant_Name". I also have a "Receipt_Num" field in FILE-A. "What I can't figure out is how to make a script that auto-creates New Records in FILE-C depending on the number of Customer Names shown in the portal, and with the same "Receipt_Num". For example, The current value of "Receipt_Num" is 0808 and the portal shows the following names: Mark Jackson Joe Smith Henry Thomas The script should make 3 new records in FILE C, one for Mark Jackson, one for Joe Smith and one for Henry Thomas with all having the same Receipt Num 0808.…
-
- 1 reply
- 763 views
-
-
ok, so here I go: 1. Is it possible to have a portal with several rows display its information on different reports... I will give you an example. Say I have a portal with 3 rows of information 3 different people. I would like to be able to insert each row of information on a diferent page. Sort of like a mail merge in word... I have a letter and I would like to insert row 1 of my portal in this letter...and then do it with row 2 and 3... All seperate sheets. Is this possible? Brahim
-
- 0 replies
- 667 views
-
-
I have a value list that is based on a repeating field. What I want is to get the values in the list in the same order as they are in the repeating field. Rep 1 comes first in the list, then rep 2 and so on. I'd prefer only to have the values from the repeating field in the VL. Is there a way?
-
- 1 reply
- 713 views
-
-
Hello all.. Stuck again this time with a layout/report have a db careproerties that a layout with a portals relating to housedetails db. This is so a careproperties be given details to what rooms it has , what surfaces etc. set up a portal for each room eg Kitchen # Floor counters apliances Cabinets Notes 1 wood marble oven oak dont clean 2 tile tile microwave oak Livingroom # Floor counters apliances furnishings Notes 1 carpet oak tv silk each type of room has its own fields kitchenfloor, livingroomfloor etc this looks great as a layout cept for the usual problems of pri…
-
- 2 replies
- 1.3k views
-
-
I have a layout that sorts cabinet parts by size. These parts are sorted first by crossgrain width. The widest ones should show up at the top of the list. The second sort is by length, from longest to shortest. The list should read: widest, (longest to shortest) next widest (longest to shortest) etc. I have this layout set up to display in TABLE VIEW. I would like to be have this re-sort occur without any additional keystrokes by me. Is there a way for this table to automatically update and resort itself as i add parts? Thanks for your help. Jarvis [color:"red"]
-
- 1 reply
- 1k views
-
-
New to FM (only been using for six months)... Is there a way to create/design a Summarized Report (i.e., a report with subtotals or "sections" of information -- WITHOUT including the field that's being used as the Summary delineator? For example, I might have a field named "color" and want to sort the report BY color (in sections)... all the blue ones, then the green ones. Can the report be displayed (on screen or print) without showing "blue" and "green" as the section dividers? FM "compels" you to choose the summary field(s) during the layout wizard -- I just don't want them to be displayed on the output. Any clues are appreciated.
-
- 2 replies
- 1.1k views
-
-
I have a portal which display contacts within companies. Ideally what I want is to lock the portal so that the current related contact records are editable but new rows are not able to be added with out click a script. Is there to do this? If not and I have to lock the entire portal in which I assume I would need to duplicate the layout and have one with a portal with fields that allow entry and one that doesn't? Any help would be great thanks
-
- 1 reply
- 702 views
-
-
Has anyone else run across this oddness? If so, do you know what's actually happening? The case: I have a master table and a slave table, with a defining relationship of Master:Field1 <--> Slave:constant (where constant = 1). This is set to allow creation of related records in slave, so if field1 is 1, all records in slave are related to the master record. Each table also has a key, set to auto-enter serial, but this doesn't play into the relationship. Now the odd bit: If the relationship is currently valid (i.e., master:field1 = 1), I get an error when I try to create a related record via the portal by filling in a slave:text field in the portal.…
-
- 3 replies
- 785 views
-
-
Hi all: I had thought this would be very simple, but once I realized I'd never done it before, I just ran into a mental wall. Instead of beating my head against that wall, I've moved on to the next problem and am posting the question here: I just want each row in a portal to show an item number, starting from 1 and going to how ever many rows are currently being shown in the portal. This is a formatting issue requested by the client, like this: 1. (Item description, Item price) 2. (Item description, Item price) 3. (Item description, Item price) etc., but if there's only 3 items showing in a six-row portal, I want the numbers to stop at 3. It's…
-
- 9 replies
- 1.7k views
-
-
Hello~ I am the newbie of newbies. I am making a database with three tables(which is in two files) I am making kind of photo album. Tables: Data contains data of images Data-Image :a table contains relationship between data and image Image : contains images Relationship between three tables are Data Id <-> Data-Image_D (one : many) Image Id <-> Data-Image_I (one : many) Data and Data-Image is in the same file and Image is in another file table <Data> and <Image> has own serial numbers(which is IDs) and <Data-Image> table has connecting data between <Data> and <Image> i…
-
- 4 replies
- 858 views
-
-
I have a popup menu for inventory items, the value that must be inserted into the line item table is the INVENTORY_ID, but I would like the user to see in the popup menu the INVENTORY_NAME to make it more user-friendly. INV_id is a unique value, but INV_name might not be unique, that is why I cannot key to the INV_name. So I need the value list to display one value but enter into the field another value. Help! :-) Thanks.
-
- 15 replies
- 1.4k views
-
-
I have a fairly simple portal that displays the title date and time of a related record, I simply want the user to be able to sort the records by either field dynamically. (I would rather avoid multiple layouts) Is there a way to accomplish this? Thanks! D
-
- 1 reply
- 690 views
-
-
Is it possible to have a pop up menu with links to records, layouts etc. It is not a website, but because of real estate (lack of it) I would like to have some sort of drop down menu with certain links instead of buttons. Is this possible, and if so how can I do it? many thanks Trevors
-
- 4 replies
- 1.2k views
-
-
Am using a modified template from FM solutions and have the following problem. Setting tab order works in the application, but fails when using web sharing. This problem was supposedly fixed in release 7.2, but still occurs after applying the update. Tabbing moves randomly from field to field, not in the order set.
-
- 1 reply
- 1.1k views
-
-
This is difficult to describe, but here's a simplified version of my question: I'm developing a teacher and student database for a school. In the teacherjobs file, there are fields for each teaching position (1st_homeroom, 2nd_homeroom, 6th_math, 7th_math
-
- 2 replies
- 828 views
-
-
Hello everyone. Im in a bit of a pickle at the moment and I'd love any assistance. Heres the situation. I have 3 tables in one Filemaker Pro 7 database. This database is designed to manage an inventory, deduct products sold off of sales invoices from the inventory, and calculate comission given to employees. I have 3 tables. One table is the inventory outlining prouduct information, reference numbers, quantity on hand and price, another table called sales which I lay out a sales form to be used as an electronic invoice outlining the salesman or saleswoman, the method of payment, and then a product information fields (quantity, vendor, reference number, description, c…
-
- 3 replies
- 982 views
-
-
I will do my best to explain my problem. Database "Proposal.FP5" houses a portal to database "pInvoice.FP5". "pInvoice.FP5 contains a relationship to "ProductPriceList.FP5". The "ProductPriceList.FP5" database contains several fields including a category. What I want to do is create a filter in the "Proposal.FP5" database that will only show items in the value list related to the filter. ie: if filter = display ads, then every product who's category has display ads choosen will show up. Does this make sense!
-
- 1 reply
- 730 views
-
-
To accomplish this in FMP 6, I created a calculation in each database with the value 1. (User can't edit without much effort and all records match.) Table 1: global_join = 1 Table 2: global_join = 1 I then set up a relationship between the tables using the "global_join"s and used that relationship for the portal. In FMP 7 this relationship set up isn't working. In 7 I have an instance of "Customers" called Global Join connected to an instance of "Party" using the "global_join"s in each table. The part that is confusing me is the portal shows one record but that record isn't the first record like one would expect. It only shows the SECOND record. …
-
- 1 reply
- 671 views
-
-
I thought FM7 said that when you browse through a portal and then click out that it wouldn't jump back up to the top, it was supposed to leave the portal where you scrolled it to. Am I doing something wrong here? The one's I've tried it on so far aren't sorted portals or sorted relationships... FileMaker Version: 7 Platform: Windows XP
-
- 3 replies
- 1.1k views
-
-
I hope someone can help me out, I designed a Extended columnar report that is approx. 20 pages long. It is set up like a test. I pasted MS Word text on the left side of the layout and an answer field corresponding each question on the right side of the page. My problem comes when I print the form, the fields do not line up properly with the lines of text on the left. It looks fine in Print Preview, but does not print properly. I even tried pasting the test from NotePad and got the same results. Your help would be greatly appreciated. Steve
-
- 0 replies
- 867 views
-
-
Hi, I'm new to FM and haven't been able to find an answer to what I assume is a trivial task. Any help is greately appreciated. I'm trying to create a report based on two (three) tables e.g. Table 1: Contract contractId clientName contractDate Table 2: Performer performerId firstName lastName Table 3: ContractPerformer contractId performerId Based on this table structure I'm able to assign a number of performers to each contract. I achieve this using a portal to the Performer table while entering data into Contracts table. I can create a report using the report wizard that generates a list of all contracts grouped by a…
-
- 3 replies
- 1k views
-
-
I use the word trashing because it has changed all my files. I opened my original solution in vs. 6 on a new installed copy of FileMaker. All of the fonts on every layout changed. I am out of town and can't access my files at home or at work. Of course, I already switched to Browse - unlike vs. 7, it automatically saved this mess. Does this mean I can't continue the design on it - and globally reassign the fonts when I get home. I use Verdana but this current system doesn't have verdana loaded in FM fonts. I hope I'm making sense .. pretty upset ... I can't believe FM would just change fonts! It should come up with "this font doesn't exist. Would you like …
-
- 1 reply
- 1.5k views
-
-
-
How do you narrow a find within a portal? I've related a student table to a class table and the middle table is enrollment. So enrollment contains all the classes each student is taking. Very simple. So, I have a portal in the student table which views all their classes. But, when I try to find just some of those classes (just one quarter's classes), I still get them all. Any clues?
-
- 3 replies
- 721 views
-
-
Hi, I have a table "tour" with a "car_no", a "driver", a "co_driver" and some more fields. Because "driver" and "co_driver" mostly use the same car I want to ease the entry of a new "tour" by building a value list of previous drivers of that car. I defined a self-relation of "tour" with "car_no" as connector and a value list of driver_no and driver_name with only related values. Everything works fine, but the list of a car grows with every new tour of that car. How can I suppress duplicate entries, though the list shows only different previous drivers of a car. How can I filter the list values to use only tours of a given time period? Maybe this a…
-
- 7 replies
- 1.1k views
-
-
I have a layout that allows users to enter in reports - the layout is based on the table "report" and has a portal to the table "issues" which holds all the line items. So the user fills out the report header information once and then fills out all the line items in the portal. One of the fields for each line item is discipline (mechanical, electrical, etc.) and one issue can have multiple disciplines. I have it set up with two more tables. The first table, "discipline", just has the eight disciplines, an ID number and a graphic for each one. The other table, "discipline join," contains a foreign key for each issue (IssueID) and a foreign key for each discipline …
-
- 6 replies
- 1.1k views
-
-
-
Gang- I've checked the postings and don't see a query quite similar enough to mine to help with my problem. If I've missed a duplicate posting, please forgive my redundancy. I have a Billing record that has two related fields (billing rate A, billing rate : that are successfully retrieved through a Client ID relationship with the Client record. (One enters two possible billing rates when defining a client.) What I would like to do now is create a value list (to access via menu, radio button, whatever) from which the user selects a billing rate to employ in calculting a billable amount. Ideally, the value list would contain "billing rate A," "billing rate B…
-
- 5 replies
- 814 views
-
-
I can't recall if this happened in 6, but in 7 I've noticed that a conditional value list will not update until you exit the record (if you've changed the contents of the field on which the condition is based for example). I guess this makes sense, since the change hasn't been comitted yet, but you'd think they'd write a workaround for something so obviously useful. Any comments? is this a bug? or a feature?
-
- 25 replies
- 2.5k views
-
-
Does anybode know if there is a way to create a value list of dates?:.. I have a field called "Due date" which get's its value from the user. I would like to based on that field create a value list "pull down menu" that contains the calendar days from the current date up to 5 days before the due date. for example, If the due date is set to 7/15/04 then I would like the pull down menu to display 6/29/04, 6/30/04, 7/1/04, 7/2/04, 7/3/04, 7/5/04 ...... 7/10/04. Anybody know how I can acomplish this??? is there a way to define value list using a loop or something like it??? I really apreciate any input
-
- 10 replies
- 1.5k views
-
-
losing all my data? I read the other posts and I am not sure if they answered my question or not as I did not really understand them :-( I have several value lists that contain course names for my school's classes. One value list is Reading in that list is 6/1 Advanced Remedial you get the idea. These are shown on a layout as a radio button since they can only have one of each. In order to do our scheduling in an easy to use format I really need the course numers in that list instead of the course name. When I changed 6/1 to 10000010 all my records that had the radio button 6/1 selected were no longer there. The choice was blank. Is …
-
- 2 replies
- 872 views
-
-
I guess my question is related to the precedent message, but here I go: Is it possible to make (via a calculation field) a list of related portal rows for a given record ? I tried : "First item : " & RelationName::Field.0 & "Second item : " & RelationName::Field.1, etc but it is not accepted by FMP 6...
-
- 4 replies
- 846 views
-
-
I have an inventory table joined to a line item table through an ingredient name field. The inventory table contains a list of ingredients used in my restaurant. It also contains a category field which allows me to to assign categories such as seafood, fruit, vegetables, meat, dairy, etc. to different ingredients. I created a value list based on the ingredient name field in the inventory table and attached it to the ingredient name field in the line item table which gives me a pop-up list of 1300 ingredient names. That's a lot of scrolling to do each time I need to find and enter an ingredient name. Data entry would be much easier if I could limit the names in the pop-u…
-
- 9 replies
- 1.6k views
-
-
Hi, this seems to be an easy question but it has caused me to rack my brains over the weekend. I want to have a layout which display only certain records from a particular table. How do i go about doing it? I have a table called employees. This table has a field called UserType which store either "Manager" or "User". I want a layout which only display those records with usertype "Manager". I have tried creating table occurrence and performing find but they don't seems to work. Maybe i did not do them the right way. Pls advise.
-
- 2 replies
- 987 views
-
-
I have a layout with a portal that displays 10 items. I want to add a field called rank with a number 1-10 and the portal will display 1-10. This is no problem to setup as you simply add it to the relation sort of the portal... The problem is if someone changes a new entry to "1" I would like the current 1 to become 2 and 2 to 3 etc...and like wise if number 10 is changed to 2 then 9 becomes 10 etc. Has anyone got any examples of something like this??? (The only thing I have seen which is similiar-ish (but not what I really want) is one which allows you to swap 2 portal rows). Thanks
-
- 1 reply
- 805 views
-
-
Big solution built from ground up with v7. I discovered how to use PNG images and photoshop.. now I'm going hog wild with the buttons and such. Are these PNG images gonna turn around to bite me in the #@!# when I go to host this with Server7 over a LAN?
-
- 2 replies
- 1.1k views
-
-
A portal inside a portal. I tried this with no success. Does anyone know a workaround to achieve the same result? An example of what I might be trying to achieve could be; A compny record with a portal of staff members and then list of telephone numbers for each staff member.
-
- 2 replies
- 851 views
-
-
Hello. I have a self join portal in a "staff" database that lists all records in the DB that I've created as a sort of constant "side bar" on my browse layouts. They're listed in what appears to be a random order, can I get these to show up in ABC order? Thanks!
-
- 1 reply
- 699 views
-
Recently Browsing 0
- No registered users viewing this page.