FileMaker Interface Features
-
Hi all, I am trying to create a sub navigation for a clients' list by using a portal. Lets say for example I have a table where there is a customer, year, make, and model fields. I would like to implement a way so that from a find result by customer, a self join could be used in such a way to create a navigation but with unique values. For example. Customer Table joined to Main Table via id numbers. Customers: Bob, John, Sally Main Table: Record 1 Customer: John Make: Ford Model: Econoline Year: 2000 Record 2 Customer: John Make: Ford Model: F-150 Year: 1999 Record 3 Customer: Bob Make: Nissan Model: Sentra Year: …
-
- 6 replies
- 945 views
-
-
Hi, Not long ago, rlbryant posted a question that was left unanswered... I have the same concern... Basically, I would like to get rid of the horizontal scroll bar in FileMaker Pro and also in IWP. Is there a way to set the width of the "body" part? Thanks, -GerryGerry
-
- 2 replies
- 1.6k views
-
-
I would like to be able to compare one set of data with the data from the top spender in a market. The problem is I can sum up for a single brand in a row, but how do you combine one brand with another brand in a sub-summary part? Thanks
-
- 2 replies
- 779 views
-
-
I have three tables: Companies, Communications, and Home Page. Companies = list of companies with key_company_ID as the unique field for relationships Communications = list of communications with key_communication_ID. (phone calls, emails, etc). Each communication also records the key_user_ID and the creation_date for the communication. Home Page = global field where key_user_ID is set (after logging in). When a user logs in, I want to present their own "home page" using the Home Page table. I want the home page to list in a portal the last 10 companies they dealt with. The way to determine this would be to look at all the communications a user has mad…
-
- 4 replies
- 708 views
-
-
Hi, I am rebuilding my office DB during XMas break and have several one to many relationships from Customer table. I have various layout views for Customer in which I display related data through various portals (one per layout). Data from old external tables in imported into new tables. All relationships work, one one-to-many relationship My contacts-portal only displays customer related data for one customer record (the very first in alphabetical order) and nothing for other customers. Prior to upgrading to 7.0v3, 2nd-3rd etc records were showing ALL contact record relationships in portals, but not properly recognising foreign key reference to CustomerI…
-
- 1 reply
- 606 views
-
-
I've just moved solution I generated in FMP 6 over to FMP 7 Server, and am now going back to see where I can leverage the new features in 7. Here is one that has me stumped: What is the best way to generate a list of related values? Currently, I have a table of applicable documents. I have another table that contains paragraphs from a Statement of Work. There is a relationship between them based on document ID (actually, its a bit more complicated than that... it's a many to many relationship, so I have a jump table to link the two tables). What I want is a comma-delimited list of paragraph IDs (so I can have a field in the applicable doc record that states "Referenced by…
-
- 2 replies
- 650 views
-
-
hello, I was wondering if this is possible, basically i want to show a specific value list base on the layout the person is in. I have 3 laysout: Inquries, Enrollment, Student Files. The field i am going to be using is call Status which will show in each layout. for Inquiries i want to show: Hot Warm Pending Applied For Enrolled: Funded Enrolled Student files: Graduated Withdrawing can it be done throught scripting? any help would be appreciate it. thanks victor
-
- 4 replies
- 682 views
-
-
I am having trouble getting the option in the Layout Setup: Printing to get the print across section to work. I can print down, but it won;t let me print across? There is plenty of room. Thanks for any help.
-
- 0 replies
- 664 views
-
-
I have an interview which a research nurse completes straight into the computer which is made up of 621 fields. I wanted to be able to pull certain fields from the interviews into another layout for the analyst to view this would be two tables of roughly 300 fields each...I seem to be running into a size problem that I can only display so many fields horizontally in my table then it puts in a carriage return and enters the next set of fields so I end up with my data for each interview being split across 4 lines rather than being on one line. This is not only annoying in fm but also causes problems when I try to export the data to a statisticall package. Is there anyway…
-
- 5 replies
- 1k views
-
-
Daer All, I have an film cue project database I am trying to build. I am new to this (I am a music copyist). I am wondering if this is possible? I have a database of music cues, each cue has an orchestra size (2 Flutes, 2 Oboes etc) related to it. One project will probably have 3 or 4 different orchestra sizes. Can I have one layout that will list cues in each different orchestra, without showing fields that don't exist for that particular orchestra size. For example A orchestra has 3 Flutes and B Orchestra has 2 Flutes, how do I hide the Flute 3 field for B orchestra. I am trying to avoid building dozens of layout,s one for each orchestra size. Any pointers in th…
-
- 1 reply
- 1k views
-
-
Hello, Is it possible to have a value list that allows the user to make multiple selections? I.e., each selection is added onto what already exists in the target field (with a separator like a semi-colon). Thank you, rlbryant
-
- 2 replies
- 681 views
-
-
I am attempting to create a report where records are summarized by month, ie, all records created in January 2004 are grouped together followed by a summary beneath the grouped records. In order to do this, I created a calc field that parses the creation date(auto-enter field) using this formula which returns the value as text... Year ( date_Created ) & " " & Month ( date_Created ) When I insert the sub-summary part into my layout, I specify to sort based on the calc field discussed above. My problem is that when I execute the sort, it groups the records by creation date, not by the calc field I created. In other words, its grouping the re…
-
- 2 replies
- 856 views
-
-
I want to have a layout which will be viewed as a list, but with sub-summary part on the layout. I'm currently using FM 5.5 and it doesn't show the sub-summary part. The sub-summary part is only shown in Form view, or in Preview mode. The problem with these are that in Form view, I can only see 1 record at a time (and not the list I want) and in Preview mode I can't get buttons to work (which means no navigation possibilities). The only way I can think of now is to have button (with script) on my normal form to go to Preview mode, show the status area on the right, pause (a continue/cancel buttons now appears on the status area), and have it go back to my normal form o…
-
- 0 replies
- 691 views
-
-
Is there a way to sort a value list, displaying only one item, other than the alphabetical default? The value list is based on a field from a table. I have the relationship sorting, but it makes no difference in how the list is displayed.
-
- 1 reply
- 662 views
-
-
I have a Quote Form with a portal to the Quote Line Items (FM7). I need to print the finished quote and send to the customer. I understand that printing the portals from the Quote Form is not a good idea. What's the best way to do this keeping in mind that the customer's shipping information and other pertinent data from the Quote Form needs to be printed along with the Quote Line Items? I'm sure there is a common, simple solution from you seasoned developers!
-
- 5 replies
- 729 views
-
-
Hi, i have a portal on one of my layout with few fields in, my question is how can i have one of the field having multiple values while the others reamin the same, exemple: a "part#" have 1 "part name" but could have more than 1 "2Aid" and "tube" Any help would be much appreciated... (if u need a copy of my db u can download it from my post in Value List) Thanks again for all the help we found on this great forum
-
- 3 replies
- 799 views
-
-
Hi, I'm trying to have a changing value lists field by a case calculation based on field "project". Ex. "project 1" has 2 value lists "categories" & "items" from fields in two other related files, as does "project2" and so on. I'm having trouble with one of the resulting "items" value lists - only 5 out of 103 values in the list appear. The calculation for "items_calc" is: Case(project = "00 4086", ValueListItems("main.fp5", "4086_items")) & Case(project = "03 3627", ValueListItems("main.fp5", "3627_items")) The trouble is with the "3627_items" list. In the "items_calc" field all items appear. However, in the "items" field, which is a pop-up menu …
-
- 1 reply
- 630 views
-
-
I have a project to combine several different FMP 6 databases together. They're all basically name & address lists, but of course using wildly different formats. There are tons of duplicates, but of course not exact duplicates. So I have a lot of hand-work to do to dedupe the combined list. I'd like to make a layout that would allow me to show two records on the screen together, side-by-side, so I could compare them both and decide which fields to use, and then delete one of the two records. Can anyone point me towards a technique for a form (not a list) to display two records from a single database at the same time? -Steve
-
- 8 replies
- 1.1k views
-
-
Hi, I'm newbie . I made a database with only pull down lists, but now I' ve a problem: when I change the selection of one pull down list in automatic the cursor goes on next pull down list and so on. So every time I want to change only one pull down list in a record I'm constrained to change all the following pull down list. This is very boring. Someone has an idea to fix this problem ? Thanks
-
- 1 reply
- 800 views
-
-
Hi I'm just a new Filemaker user so I am making my excuses from the outset. I am trying to create a database to handle event scheduling. At the moment I have three databases that talk to each other - 1. Personal contact details 2. Organisation details 3. Program details (we run a festival so this includes fields like session title, start & end times, date, venue, speaker 1, speaker 2, speaker 3, speaker 4 etc.) The speaker 1, 2, 3, 4, fields in "program details" have drop down boxes of all the contacts in the "personal contact details" database. I'd like to be able to create a personal schedule for each speakers (must update automatically when…
-
- 1 reply
- 601 views
-
-
Hi, I have created navigation buttons that I would like to have appear on all layouts in a file (so I don't have to re-create or re-position them in each layout). Is this possible in Version 4? My appologies if there is an obvious solution. Thanks, Chris
-
- 4 replies
- 961 views
-
-
HELP PLEASE. I am using FM6. I want to scroll through entries that correctly display a detailed related entry and also enable me to select the detail entry from a list. Let me describe my structure briefly: I have a CONTACTS file and a VEHICLES file. In CONTACTS, I have a layout that displays contact info, a List portal (multiple rows) that shows a list of related vehicles from VEHICLES and a Detail portal (one row) to display detailed vehicle info. I have no problem using a global field and relationship to select an item from the List portal to be displayed in the Detail portal. The problem is that when I scroll through the contacts, the same Detail port…
-
- 1 reply
- 643 views
-
-
A simple question probably, but I'm stumped. I have two databases linked by an ID number field. DB A has household info, DB B has individual info. I made a portal in DB A which brings in info from DB B just fine. There may be up to 6 related records in DB B for each record in DB A; the number varies. The portal is set up now with 6 rows. That works fine, but I would like the number of rows in the portal to be variable; 6 when needed, 1 when needed, etc. Any suggestions? Right now I have to print a lot of blank rows.
-
- 1 reply
- 673 views
-
-
Hi, I have an inoices summary report i'm trying to put together. I'm very new to reports so put the kid gloves on! I have an invoices table and a InvoiceLineItems table. (1-M) relation. I'd like to order by date the invoices and underneath each invoice, display the lineItems which are associated with that invoice. example: Date: 11/01/2004 Invoice1_InvoiceNumber, Invoice1_Amount InvoiceLI_Description Invoice LI_Amount InvoiceLI_Description Invoice LI_Amount Invoice2_InvoiceNumber, Invoice2_Amount InvoiceLI_Description Invoice LI_Amount InvoiceLI_Description Invoice LI_Amount Da…
-
- 3 replies
- 904 views
-
-
Good Morning. I am trying to find out if it is possible to sum line items donations totals by date in a Portal. I have a portal (Donations) linked to Customers where we enter donations received by a customer in his /her portal lines. I would like to group/total these by date. is this possible? Many thanks. Roger Eg. Customer 1000 29/11/04 Donation - Xmas Appeal
-
- 2 replies
- 762 views
-
-
Hi, I have the same problem in all my Layouts, i set up some fields or a whole portal to be dependant on 1 or 2 or 3 particular fields and for some reason (i suppose my relationships are not correct or something else i don't know) the dependant fields don't refresh automatically (i only need to click on layout mode and back on browse to update them) Example: if i put a value in "Project" then i choose a part from "part#" drop-down list and normally my portal should clear up (if there is no info for this part) and display the info relevant but doesn't another one, i choose a project, i choose a part# and this display my jointId, my 2AId, my TubeId, but not…
-
- 6 replies
- 1.4k views
-
-
I use portal to auto-fill some fields in the database. I also do "allow entry" on those fields so users can change the values of the fields. However, when a value is changed in the form, the value in the related database is also changed, which I do NOT want. I only want the value to be changed in that one record, and not touch the original value in the related database. How do I do that?
-
- 3 replies
- 672 views
-
-
The date fields in my database are requiring me to input dates in the interational format. When I enter a date like 12/23/2004 FMP says the date is not in the right format and should look like 23/12/2004. My operating system is set to use the U.S. format for dates and my date fields are formatted to display dates in the U.S. format. Is there another preference that I'm missing for date input?
-
- 1 reply
- 725 views
-
-
Maybe this question has been asked before but the Google search only gives me 4 results searching on 'theme'. Here's the question, how do you make themes in fmp6? In fmp 5 there was the themes folder with the .fth files but how does it work in fmp6. Where are the theme files and where do I find information about making my own theme. Thank you for reading and eventually answering this question.
-
- 4 replies
- 1k views
-
-
I have a strange situation ... I have a Main Menu which is based upon my Preferences table. It contains only one record. The Main Menu display has NO FIELDS - but only buttons. If the User accidently clicks directly onto the layout (form) where there aren't any buttons, the system goes into 'hour glass' searching!!?? And it searches for a long time!!! Displaying the Status area, it is in Browse mode and unsorted and only one record. It drives me totally nuts. I made sure the layout is based upon Preferences base table. Preferences has many relationships but why does it search if no fields are on the layout? Ideas appreciated ...
-
- 4 replies
- 1.1k views
-
-
You know how some wall calendars have the last Sunday and Monday of the month share squares with the second to last Sunday and Monday? The rectangle is cut in half to create two triangles instead of two rectangles. Well, I downloaded a calendar FileMaker 3.0 file that uses honest-to-goodness triangle buttons to achieve this affect. It works great in FileMaker 6 on both Mac and Windows. I have no idea how this is done, and all my attempts to create a similar button have failed. How the heck do you do this? I could copy the element, but I'm creating a larger calendar layout, and sizing up the element creates "breaks" in the clickable area. I got the file …
-
- 4 replies
- 3.1k views
-
-
Hi everybody I am new to this forum, so here goes. I am a keen to change the colour of fields on a screen on condition of its contents. For example there is a "Copy Date" field that I would like to be black but then red if the system date is the same as the copy date. I would also like objects to be visable or not visable on condition. For example only "Manager" accounts can create new publications. I would like the "New Publication" button to only appear if the account = "Manager". I would really appreciate any help here as I am just at the planning stages of a project and the above two issues could make an enormous difference to the design. …
-
- 1 reply
- 748 views
-
-
Hi , I am trying to get a button that returns to the last layout it does not need to remember the last four layouts just the last one it was on. I am also trying to link to a pdf document through a button im trying OpenURL but to no avail does the pdf document need to be served at the moment im saying openURL pdf_document/about.pdf thanks for your time , DR
-
- 3 replies
- 831 views
-
-
Can't understand why this works in Safari, but not in IE6 (WinXP) over Instant Web Publishing: I have a portal. Over a row, I've laid a transparent button so users can click on the portal row and it executes a script that takes them somewhere else. Works fine when I'm in Safari, but IE6 doesn't "see" the button (no "finger" appears). I do have Javascript enabled in both browsers. This is driving me NUTS. Any ideas? TIA, cooldaze (I'm starting to hate windows again.)
-
- 1 reply
- 865 views
-
-
I'm in the process of making a runtime database and need an icon for it, i have a logo and have been trying to make the first letter into an icon. I've tried 2 different pieces of software and i cant make the border transparent in either. please find attached the icon, i need the white surround making transparent. If anyone has the know-how.
-
- 2 replies
- 1.2k views
-
-
Ive been creating a large database for a warehousing and distribution company. Its nearing completion, but i still want ot give it a name. I know the system PC World uses is called 'Eclipse', which has inspired me to give this sytem a name. Only problem is, i'm stumped for ideas. At the moment ive been calling it 'Mercury', but i thinks its ultimately cheesy and sounds like something out of a sci-fi film. Any ideas, Maybe a Roman/Greek/Norse God.
-
- 14 replies
- 1.9k views
-
-
I just opened one of the pre-existing DB's that comes with filemaker pro "purchase order". there 8 layouts and I noticed that when I ever I do changes to layout 1 will not show up when I try to access the DB on the web browser until I do the change in layout 8 with is the web browser layout. My question is why have so may layouts ? do I need to change both layouts ? or do I only change layout 8 which is the web browser layout ? if so, then why have the extra layout ?. thans in advance for your help.
-
- 0 replies
- 697 views
-
-
I have a data base of members names, addreses, etc, and wish to publish a directory in a half page format in booklet form (8 1/2 by 11 folded and stapled in half). I can set up the layout to print in half page columns but can't get it to sort so that when stapled together the data remains alphabetical. In other words, the data needs to move to the correct half page on the basis of the size of the data base and pages required. I hope I have described this correctly so you can give me some help. Maybe FMP can't do this but I know their are word processing programs that are able to do this for newsletters.
-
- 2 replies
- 745 views
-
-
Hi everyone - I'm making an invoicing system. I want to be able to select items in an invoice from a drop down list in a portal which grabs the items from a related "invoice items" table containing all of the possible invoice items. The selection area in the "invoices" window is set up currently as a portal; the problem with this is that I can only change entries that have already been entered from the "invoice items" table, which works, but I don't want to have to keep switching windows. It would be easier to do things in one step. I was wondering if there's a common way to do this (ie- some settings in the portal I could change so I can select data fro…
-
- 1 reply
- 598 views
-
-
Hi everyone, Is there anyway to have a portal with sub summary fields. I have a solution that is multi tiered. That is to say I have a Job file and a Job Line item file. The line item file is made up of "Descriptors" which in turn have there own line item file. I have a script that breaks down the line items into the Descriptor Line Items and places them in a "BOM" file. I have a portal on the Job file that displays these items. I currently have another file that summarizes these items for display in another Job layout because i couldn't figure out how to display a summary through the portal from the BOM file. Is this possible? The script that I am using now is a ver…
-
- 1 reply
- 676 views
-
-
On the data side: I am building a database that includes hotel information for generating job tickets for service calls. Each hotel has 2-3 ballrooms and 2-3 hotel contacts. On the data extraction side: In a different layout, I need to generate a service ticket for a specific hotel. I want the option of a pop-up value list to display the related ballrooms (so that we may designate which ballroom) and another value list to display the related hotel contacts (so that we may designate which hotel contact). This is what I have done: On the data side: I designed a form to enter the hotel data. For the
-
- 1 reply
- 710 views
-
-
Hello, I'd like to know if it's possible via intranet (a web browser, ie or firefox), to access preview mode.I want to sort and make sub totals, then print. I am using Fm pro 7, Is there any plug in i can use ? Or can i add a script to make the server switch to preview mode and print ?. ( the user's computers and the server are close). Or any other solutions ... Thanks.
-
- 0 replies
- 676 views
-
-
Is it possible to have two bodies, or two dynamic related information listed on a report? For instance, materials (one table) used for this work order (like invoice) listed with the labour hours (another table) as a print report...
-
- 2 replies
- 812 views
-
-
Seemed like a 50-50 chance on which forum to place this in. Suppose that you have a field, which you would like to turn red, if it goes over a specific amount. Is there anyway to change the color of that field with a calculation ?? what is the recommended/preferred way? thanks, J__
-
- 12 replies
- 1.8k views
-
-
I have a portal that doesn't seem to show related records when I share the database using FM7 Server but it works fine when I'm just accessing a copy of the same file on my harddrive using FM7 Pro. I have the database set up so that everyone has access to everything and it doesn't require a password. Other portals on the same layout work fine and the only difference in the non-working one is that the table it's pointing to is a self join table as follows: eg. (Table G 2)-----(Table G)-----(Table A) The Layout I have is of Table A. Inside this layout I have a portal pointing to Table G 2 which is a self join of table G. What's strange is that if I add on…
-
- 3 replies
- 722 views
-
-
Hi, It would be absolutely great if someone could help me with a really tricky matter. Let me explain first of all that I am bound to the database structure I will explain, because there is an existing mysql-database which should be administrated by my filemaker-solution. The tables of interest are: FILMS PERSONS PERSON_TYPES PERSONS and PERSON_TYPES are linked to FILMS by an n:m-relation (X_Films_Persons, with the fields ID, Film_ID, Person_ID, PersonType_ID). Now I want to display all the persons and their personType belonging to type 1,2,3 in one portal in FILMS, all persons belonging to 4 in another one and the rest (5,6,7,8) in the last portal.…
-
- 15 replies
- 1.7k views
-
-
Server: FMP Server 5 hosting on Windows 2000 Server OS Clients: FMP 5.5 on Windows NT and XP Pro I have an application running successfully in the above environment that for end users requires no knowledge of FMP, operating systems, and little knowledge of computers: just follow onscreen instructions, click on buttons, select from menu items, radio buttons, lists, etc. Calculations run in the background, and the end user clicks on a button to print the report. It takes only minutes to train a new user. I am writing a new application with data entry screens and reports that I want to print on 8.5" by 11" paper in portrait mode = no problem. But I also need an a…
-
- 1 reply
- 744 views
-
-
Finding FM's Custom Dialog somewhat, ahh, limiting, here's a way around it: Duplicate your layout - then change all buttons to Do Nothing and kill value lists - make fields not editable. Group All and lock it. Draw your dialog box on top of it. You have full drawing tools and all fields and effects. With some effort you can make it look just like a real dialog box (see attached screenshot), but it is not moveable. Use a Done or OK button to go to your orginal layout. Place a control on the orginal layout to go to your duplicated (d-box) layout. As you flip back and forth, it appears as though the dialog box is opened above your original layout. In my schedu…
-
- 6 replies
- 1.2k views
-
-
When you click on the "Add Relationshp" icon, an Edit Relationship window appears where you define information about the relationship. Once this has been done for a table pair, how do you go in and look at what has been specified and if needed make changes? For example, you want to change how the records are to be sorted in one of the tables or no longer allow creation of records in a table based on this relationship.
-
- 1 reply
- 607 views
-
-
[color:"blue"] Hi2 All Each record in my db may embed no file, 1 file or as many as 5 files. Like *.Doc, *.PDF, *.SWF, *.EXE, *.SXW files. I would like the user to choose which file format to export from the container field via a value list. Now record 1, might have *.SWF, *.EXE and *.DOC Record 2 might only have *.DOC Record 3 may have *.DOC and *.PDF Record 4 may have no file to export. Anyways, the main problem is once a value is a member in the list, if won't go away in the next record, where the values are may be different. The value list seems to inherit the values of all the previous records into the current record. Like record 2 will s…
-
- 6 replies
- 861 views
-
-
Can a pop-up value list using values from a field in another file include "Edit" to add a new value, thereby adding a new record, in that other file or is a portal the only way to add a new record in the other file? I'm using FMP7 and can't seem to pull this off.
-
- 1 reply
- 640 views
-
-
I want to add a button in a row of a portal that will jump to another layout with the current record displayed. TIA
-
- 1 reply
- 591 views
-
-
When using a join file... sorry, LIST (old habits...) to create a many to many relationship between two lists, I have read that you can actually create new records in one file via entering data into a portal on the other. I've tried this and seem to have it set up correctly, but it won't create records. The relationship works fine if I create records manually. Is it a myth that this can work, or am I doing something wrong... or is it only a feature of Developer?
-
- 5 replies
- 759 views
-
-
-
I'm overlooking something. Years with filemaker (Version 3 my first) but never used portals. I'm not a programmer either but have done ok on my own. SSsssooo, I sell books. Each record is a title. I want all titles to show in 1 field so I can copy paste or send in emails of current availble titles. I have tried my relationship but can't seem to get them in there....HELP!!
-
- 2 replies
- 575 views
-
-
Hello, I was wondering if someone can help me out here. I have two databases, one is call Student and the other Attendance. Basically i have a field in Attendance call ARC which is a check box value list of Yes or No. Now, I want to display this ARC field in the Student Database but it is not doing it. it just display a box but not the check mark. The value get check mark in the Attendance database. I am using a relationship base on the ID, StudentID. Thank you victor
-
- 6 replies
- 790 views
-
-
I can't figure out how to add a font to my Filemaker font list. I'm on OS 10.3.6. I have the font I need and I have Extensis Suitcase. I thought I turned the font on through Extensis, but it doesn't show in FMP. Help!
-
- 1 reply
- 776 views
-
-
I've been cruising and perusing the forums for a couple of days now trying to find out how to create a conditional value list in v4. Looks like what I want to do would be a breeze in v7, but alas, that's not in the budget. Can anyone point me in the right direction? ~Courtney
-
- 2 replies
- 708 views
-
-
I am a teacher developing a database for staff use at the school I teach at (Sydney, Australia). Given that sensitive info about students may be stored, I want to limit access to certain layouts. When a teacher clicks a button that would normally take him to another layout but is denied access (via Accounts & Privileges), I would like a dialog box to pop up and say "Access to XXX denied" and to stay on the current layout (and not to a greyed-out screen which shows No Access and leaves techno-shy teachers wondering what to do next). Also, is it possible to modify the above so that a password is called for. If they type in the wrong password, I would like a d…
-
- 7 replies
- 1.3k views
-
-
OK, I have two tables "Staff" and "Computers". I have a value list based on the "Last Name" field of the "Staff" table. On the Computers layout, I want to assign the computer to a staff member by pulling down the "value list of the last name". And when I select the last name, I want the rest of the information from the staff record to fill in as well. So, I create a new record in the computers table. Right now, I have a portal (showing only one record, as the computer can only be assisgned to one person) showing the staff. The Last Name record in the staff portal is a pull down list (with the Last name value list), but will only pull down if there is already a …
-
- 1 reply
- 757 views
-
-
Gang- I'm attempting to create a phone directory from an imported tab-delimined file. The format is as shown in the attached jpeg. (I've blurred the non-fictional entires to respect the privacy of the members.) I have two issues with this. Issue One: As you can see from the non-blurred entries, I'm using the label feature of FMP to create a two column listing of "labels" with a page size that's the size of the directory page that's being printed. Though I'm not actually printing labels, this format seemed the best approach to create a directory listing. Line 1 contains the last name and first names of the adults in the household (this is all one field;…
-
- 2 replies
- 898 views
-
-
-
Greetings, I need the ability to insert a new portal row in between other rows, preferably by using a button on the portal row. I'm sure this is a pretty common need, I just have not been able to find an easy solution. Any advice is greatly appreciated!
-
- 4 replies
- 796 views
-
-
I have a script that loops through a portal to set a field in the parent table with the related fields in a format for printing that cannot be achieved by just printing the portal. When I run the script on a Mac, it takes 32 seconds, which isn't great but passable. When I run the script on a PC, it takes more than 3 minutes. My client is in a PC environment (medical center) and switching to Macintosh isn't an option. Does anyone have an idea why there is such a discrepancy between the PC and Mac and what can be done to resolve the issue? All of the other scripts seem to run equally well on both PC and Mac. Thanks for any advice.
-
- 2 replies
- 611 views
-
-
I have a VL of several initial of workers in the office. Let's say they are: AA, BB, CC, DD, EE, etc.etc. I'm wondering if there is a way to make the field be in a color pertaining to the person's choice of initials. Example: if the users chooses AA for the initials, then the box with the initial would be light blue. If BB initials where chosen, then light green. And so on. Is this something easily done or do I have to go back to the drawing board. Thanks, Kris Kauker
-
- 1 reply
- 639 views
-
-
I have just got the program and am trying to set up something very quickly (and basic). I have 2 databases - 1. a forms database (a list of company forms) 2. an ordering database (to order one of the forms) The 2 databases have 2 related fields which are "Form Ref Number" & "Description". I have populated the forms database with around 7 entries and what i want the ordering database to do is when the user is creating a new order, when they click on the "Form Ref Number" a popup of the form numbers to appear so one can be selected (i have this working and its gets the data from the forms database no problem). However i wa…
-
- 3 replies
- 637 views
-
-
Hello all, I am not new to FM, but there is one thing I could never figure out: How do I create partly transparent graphics for my Layouts? On the Mac, making one colour transparent (in GraphicsConverter) and then pasting the image to the layout seems to work, but when viewed on a Win PC the transparency is gone. However, there are sample databases (from the ISO CD, for example) that contain lots of partly-transparent graphics? Have all these been created using the "native" FM layout tools? Surely not. I tried search, google etc., but to no avail. Grateful for any help. -- Lutz Pietschker Berlin
-
- 3 replies
- 963 views
-
-
Hi, i am quite a Newbie in FM (using FMP7) and i am building a database for design and production validation testing in a Vehicle company. I have many tables (see attached) and i want to use 3 Main Layouts (Lab Data, Projects sheets (parts, test) The way i want it to work is as follows: Engineers will create a new project and feeding the parts No, tube, connectors, etc... Then create a list of Test to be done with all the details Ideally i would like to create a matrix (like Excel spreadsheet) matching which test as to be done on which part or tube or connector And at the other end, i will have the Lab guys feeding the results in the Lab Data layout As…
-
- 0 replies
- 702 views
-
-
We have a contacts database of company employees that we print in a layout using sub summaries for each department. Is there a way to make the 'alternative background fill' work in form mode (which we print from)? I can verify the alternative background fill feature works fine if the layout is viewed in Table or List modes, but not in Form mode. This seems rather strange! Why would this feature not carry through to the one mode that surely most use is made of by the people viewing and printing the database? Is this a bug?
-
- 4 replies
- 1k views
-
-
Good Day I'm creating contribution gathering DB for my church. The DB has basic tables (MemberMain, MemberDetail, ContributionMain, and ContributionDetail)on ContributionMain I have main infomation (such as ConID, Date, Enterby) and Potal using ContributionDetail. Now, on ContributionDetail I have ValueList for Types of Contribution (Such as 1/10th, Give Thanks, Weekly, and Other). I used a Summary field option to gather LineItem Total and it work. but I want to create a Tab(new Layout) for SubTotal Potal for my ValueList. Is there a way to do this? Thankx Kimi at work ~
-
- 4 replies
- 989 views
-
-
FM for some really odd reason does not have a selection list. Not a Pop-Up list, but a multi-line selection list. So I'm trying to imitate this with a portal... I'd like the user to select an item in the list, then click on a button (not in the portal) and run a script. I need to know which portal record is selected so I can do the right thing. So far I can't figure it out. Any suggestion? Thanks, S
-
- 9 replies
- 1.1k views
-
-
I have two tables in a one-to-many relationship. I'm showing the "one" in a layout with a portal for the "many". The "many" table is already populated. I don't want to add records in that table. I just want to select one of the already-existing records to relate to the "one" record I'm currently viewing. I'm hoping someone here can give me a clue as to what approach to take. I'm not making any progress with my experiments so far.
-
- 4 replies
- 736 views
-
-
How to show the record number in a sub-summary layout? I need to show the record number starting with 1 at the beginning of each new category. Example: Colors 1 Red 2 Blue Shapes 1 Oval 2 Circle
-
- 1 reply
- 863 views
-
-
I have a database I use as a point of sale system. It is for keeping track of which zip codes a realtor is assigned to represent. I have 3 tables. 1. Agent Info 2. Orders 3. Order detail. -Agent info is just that. Contact info and the like for that specific agent. -Orders is the parent of order detail and basically is there to allow there to be numerous orders for each agent and still different zip codes per order. -Order detail is the zip code info for that specific order. The problem I'm running into is this: I would like to have a lot of this info on one page. When I select the order on the left, I'd like to display only it's childs records in the…
-
- 1 reply
- 634 views
-
-
I am developing a solution for estimating jobs and I was asked if I could make a layout appear like a spread sheet and keep it interactive like an excel document. I was going to create four tables, one for job info, one for materials, one for trade services, and one for labour costs. There are going to be a max of 10 items per estimate and each item can use any combination of labour, materials, or trade services. I was thinking of doing this with portals, but cannot figure out if it is possible. I will attach a file displaying the type of view they would like. Any input is greatly appreciated Len Worksheet.zip
-
- 0 replies
- 849 views
-
-
I am working on a program that will help the person who does school scheduling layout the master schedule, teacher schedule and student schedule. I have the master schedule and teacher schedule figured out. In the master schedule (table) each room and period is equal to one record hence each room has 50 records in the master schedule table because we have 10 periods in a day and there are 5 days in a week. The teacher schedule (table) is analogous to the master schedule. Each teacher has 50 records the teacher table. 1 record for each period of the week. I have it set up so that when class is entered in the master schedule, the teacher who teaches tha…
-
- 1 reply
- 808 views
-
-
I have 2 fields: a Vendor ID and a related Boolean defining whether that vendor is active or not. I would like to build a value list with only the active vendors. Any ideas? It sounds easy! lol Thanks!
-
- 1 reply
- 696 views
-
-
Wondering if anyone knew if there was a way to specify a specific row and column for printing a label instead of creating a whole sheet of the same label. For example If I wanted to create return address labels, but instead of printing a whole page of labels, I just want to print on the label located in col 2, row 3. Any thoughts??
-
- 2 replies
- 902 views
-
-
Newbie Question: I have a one to many relationship and need to copy a value from the Many to the One. The one is a "project" table and the many is a "team" table. The team table contains two fields that are important. "Responsibility" and "Name". I need to copy the "Name" value from the many into a field in the one based on a calculation of the "Responsibility". I have three fields that I am trying to copy into, "Production", "Trainer" or "Consulting". When I use a calculation, *If ( TEAM::pta.Responsibility="Production" ; TEAM::pta.contact ; "" )* and a similar calculation in the other 2 fields, I am only getting the first record in the many and it ignor…
-
- 1 reply
- 610 views
-
-
Is there a limit to how many lines/characters can be placed in a custom value list?
-
- 1 reply
- 722 views
-
-
Hi, I have a portal ten deep. I want to be able to choose a company name from a drop down list, then in the next column have a company contact automatically fill in. The problem is that when I do it for the first record, it changes the contact name for all ten records to that one company. I used to have the user enter a company number and all the corresponding info would fill in, but my boss wanted to make it easier, hence the drop down box idea. Any ideas? Vandy
-
- 1 reply
- 613 views
-
-
I currently have three tables. Applicants Search Committee Members Search Committee Member Assignments Search Committee Member Assignments is a join table between the other two. I currently have a portal on each Applicant record in which you can assign search committee members. The portal uses a dropdown menu using a value list of the available search committee members that can be assigned. I'd like to make it though so that you can assign search committee members via checkboxes based on that value list. Could someone tell me how to do this ? Note, I need to leave the relationship in tact, because I use information from the Search…
-
- 5 replies
- 899 views
-
-
I have a layout for a quotations form with several repeating fields. In FM 6 I formatted those fields to have a border around each of the repeating fields. In FM 7 the borders do not show up unless I put data in that repitition of the repeating field. It appears that the only the side borders show up but either the top border shows above the repitition with data in it or the bottom border from the rep above the rep with data. Summary - not all of the borders show up even after I tell them to in the Layout Format menu.
-
- 3 replies
- 1k views
-
-
Hello, I have created a report with sub-summaries. Is there a way to create a report with only the sub-summary totals and not any of the individual lines making up the sub-summary? For example, I have an item database that has part numbers, class codes, and quantities. I want to summarize the quantities based on class code, but I only want to see the totals and not all of the individual items that make up the totals. Or, is there a way to show all the sub-summaries totals at the end of the report and not at the end of each class section?
-
- 1 reply
- 879 views
-
-
Is it possible to partition a layout in such a way that the header district is always visible, no matter how far you have scrolled down the page? This is possible in a columnar type layout, but is it possible in a general blank layout? Some of my layouts have many fields and I would like to have button driven scripts always available without having to scroll to find them. Is there a way to do this? Thanks, Jarvis
-
- 3 replies
- 824 views
-
-
I have created two tables with a join table inbetween, I am trying to make a layout which will allow me to enter data in both tables on the same screen. I have tried to use a portal, as described in "using filemaker pro 7" to no avail, I am now attempting to use the "create fields in layout" tool, also as described in "using filemaker pro 7" and I am still not able to enter data.... what am I doing wrong??? I can attach the file if that would help.. Thanks for any help in advance....
-
- 5 replies
- 1.2k views
-
-
I am wondering what happens on layouts when you change the name of the underlying table occurrence. I have noted that if I change the table designation of a layout, I have to go through each of the fields on the layout and update the dictionary link to use the layout's new table occurrence (TO). And so, I have refrained from changing my layouts to use specific, contextually useful TO's. However, I do not know what might happen to these layouts if I change the name or context of an existing TO. My concern is this: I am looking at my initial spaghetti-code Relationship graph that resulted from upgrading to 7 (something like 100 relationships for 18 base tables), …
-
- 2 replies
- 794 views
-
-
I am fairly new to Filemaker and need some help creating a summary report of survey responses. I need to create a report that has a count of each response submitted and what percentage of the total answers that the response represents. IN MySQL i can use a SELECT query i.e. SELECT Count(fieldname) WHERE fieldname = "value". I need to build a report that has each of 53 fields listed with the count of each and the percentage of total for each answer for that field. i.e. Field 1 Answer1 count % Answer2 count % Field 2 Answer1 count % Answer2 count % Etc. I'm sure there has got to be a fairly simp…
-
- 1 reply
- 852 views
-
-
I'm trying to copy a layout, call it layout A, including the records to be copied to another layout, call it layout B. I need to have all the records, fields, content, and everything in layout A to be in layout B. so layout B should be exactly the same as layout A. there are about 4000 records in layout A and i'm not familiar with scripting, what is the best way to duplicate the layouts? i could only copy the layout but none of the contents get copied over. any suggestion is much appreciated! -pokeguy
-
- 41 replies
- 4.5k views
-
-
This isn't a great crisis but having recently written a solution on a laptop and then transferred it to a server in the office running Filemaker Server, everything seems to work fine except that I've found that pictures that I placed (under transparent script buttons) cannot be found (despite placing them in the databases folder) and hence they don't display. There are 5 pics on each of over 60 layouts and I can't face individually re-inserting them. File references only seem to cover related fmp files. Any advice gratefully received.
-
- 0 replies
- 750 views
-
-
Is it possible to make a specific image pop when I chose something in a menu? i.e.: Help > About ..Would make the logo of my company pop-up (GIF image) but I don't want it within a layout, I really want a pop-up. Much like the script Show Message but I want it to "Show Image"
-
- 1 reply
- 1.1k views
-
-
I know this topic has been covered a lot recently but reading the thread left me confused! Sorry! Here is my problem: I have a text field called CHOICE which has three checkboxes called OPTION 1, OPTION 2 and OPTION 3. I would like to see those records where OPTION 2 has been clicked to appear in a separate portal. As an extra, can the results in the portal be further modified to show records where OPTION 2 has been picked between 2 dates? What I have in mind here is a button setup which asks for the first and last date and then shows the found records in a portal. I am a FM newbie so appreciate your responses! Frank Bugeja
-
- 4 replies
- 860 views
-
-
I have an idea of how a join table is supposed to work, I just can't seem to make one work properly. Does anyone have a simple FM7 file that demonstrates how a join table is supposed to work?
-
- 3 replies
- 863 views
-
-
Great forum, been coming for a while and have found lots of goo advice/help, just never had a reason to post - until now. I have a JobInfo table related to a receiving table and shipping table. The receiving and shipping tables both are related to themselves to show a portal in their layout. The portal shows the receiving (or shipping) dates and what was received (or shipped). I would like to show the last date that was entered, but I want to make sure it was the last date received (or shipped). I would also like to do this without a script. Any help will be greatly appreciated. eddie
-
- 2 replies
- 659 views
-
-
I have a simple Point of sale databse with the main file housing customer info and the related file housing the stuff that they bought. I would like to be able to omit certin items they bought from the invoice (printed report). I'm thinking of a simple checkbox on each portal record line. If it is checked, that record is excluded from the report. If it is left alone, it is included like normal. What I'm missing, of course, is the functionality. I'm a intermadiate to filemaker, but new to version 7. Any thoughts are much appreciated. Thanks
-
- 9 replies
- 863 views
-
-
I tried to post this earlier today, but since I don't see it up, I'm assuming it didn't work. Apologies if this is a duplicate. I'm trying to find a way to add up all unique entries in my field "authors," and since its value list is drawn from the field, eliminating duplicates, I wondered if there is a way to just calculate the total number of items on that value list. How would I do that? Or is there a better way? Thanks for any advice, Athena
-
- 5 replies
- 1.3k views
-
-
I created a portal to display related records and chose to sort them by date. However the portal is showing the same record over and over again (significantly, the number of repitions equals the number of related records), rather than showing each unique record. Oddly enough, this problem arose when making a new portal utilizing a copy of a relationship in order to create a new layout with a different portal sort order. The portals using the original relationship work just fine; but the duplicates of the relationship have this problem....
-
- 3 replies
- 698 views
-
-
I have converted a complex FM6 file to FM7 which all appears well until I click any button which then leaves the button with a black outline, ruining the layout's appearance. This only disappears when I move to a different record and the screen refreshes, . Does anyone else encounter this? or have any suggestions? Mike Owen
-
- 1 reply
- 937 views
-
-
I am trying to create reports based on a value list in a bank register. I have a value list with a number of categories listed such as Electrical, Rent, Deposits, ect. I would like to create fields for the above categories (Electrical, Rent, Deposits) that would give me totals for each category. Is this possible? The report would look something like this: Electrical - Electrical total (field) Rent - Rent total (field) Deposits - Deposits total (field) Thanks in advance
-
- 2 replies
- 638 views
-
-
Is anyone able to tell me how to get a portal to display ONLY the current found set of records from the SAME file? I don't want to have to insert / replace a value in the match field to identfy the currently found records each time I've done a find since it would have to be deleted again each time I do a new find / omit any of the found set. Is there any way of creating a dynamic relationship based on the records that are members of the current found set? I've tried self-joins based on calculations of the Get(recordnumber) but they won't work unless the calculation is indexed (which of course defeats the object of the exercise as it won't then change/upda…
-
- 1 reply
- 807 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online