FileMaker Interface Features
-
Have created a very basic database to keep track of DIY expenses. I've created separate layouts for electrical, plumbing, etc. Each layout is identical except for the receipt number, vendor (a pop-up menu), and the date. Although the other fields are identical they all have unique names, such as: elect_cost, elect_qty vs plumb_cost, plumb_qty and so on. The database works fine except for the following. When viewing, for instance electrical, I do see what I entered into electrical, but I also see partially filled records which are actually from the records of other layouts such as plumbing or other layouts. The fields that appear with data the 'vendor', 'date' an…
-
- 4 replies
- 1.4k views
-
-
Ok, I have a script that creates a new window and takes me to a layout with a portal on it. I want it to also create a new portal row. The portal is formatted to show 1 row at a time. When I go to this layout, how can I have the script create a new portal row so a new row is waiting for the user to enter in data? This seems like it should be simple but I can't find anything on it. Any help would be appreciated. Thanks! John
-
- 4 replies
- 1.1k views
-
-
Hi, I was wondering if someone could explain how something works in the ContactsManagement Fm7 sample. When you do a find on a contact, a list view will appear and display all your matches. You then can click on one of the items in the list view and it will take you to the form view. What makes it do this? How does it know to go to that view? I have tried to somehow select a part of the listview in teh layout mode to determine what is special about it. thanks for your tips in advance, sincerely, J__
-
- 2 replies
- 864 views
-
-
Hey everyone, I hope I can find an answer to this. I have the main layout, which has a few fields. What I'm looking to do is have a specific layout automatically created everytime I enter data into a specific field. IE: I have fields for 10 colors set up. If I fill out 1, I want another layout (will have diff fields and setup than the main layout) to be instantly created & some data taken from the main layout and copied over (except for the diff fields of course). So, if I fill out 10 colors, 10 layouts should be created w/their info. Is this possible? How would I even go about doing this? It's easy in Excel, but I can't seem to figure it out here…
-
- 7 replies
- 1k views
-
-
Attached is a most interesting example, showing that when a field is white, it does not update the relationship. The database has two tables, TimePicker with fields Time, gDate, gUser and cOne. TimePicker has four records each with a different time. The other table, Appts has Time, Date and User. The layout in questions has a portal with TimePicker selfjoined with cOne, TimePickerByTimePickercOne to show all the times and another relationship to Appts, ApptsByTimePickerDateTimeUserByTimePickercOne. One can easily make new appts but when you change the date in gDate, only the blue (transparent) or red fields automatically update, not the white fields. Any suggestions…
-
- 1 reply
- 679 views
-
-
-
I was after some advice on a problem I have. I have a database in which teachers are developing a Unit of Work. Once the Unit has been created, they must input all the activities for that Unit. There may be a small number or there may be many. I decided to have a portal in the main file that relates to another file (activities) sitting off by itself. The relationship allows teachers to input as many activities as they like and I have created a script to print the activities in the activities file. The problem is, the relationship doesn't work properly, the activities go into the portal, but when you go to the activities file and sort, it only prints the first…
-
- 2 replies
- 675 views
-
-
I am looking at a database in browse and layout modes and can't see the layout menu even though each layout is checked in layouts> layout setup and in Layouts> Set layout order. In layout mode > View > show status is greyed out; what gives? What setting needs to be changed for the layout menu to be seen again?
-
- 2 replies
- 1k views
-
-
Not sure where to put this. I have file with many tables. Many layouts are printed from different tables. We have many printers networked. Each script has a Print command but settings are all different. I would like a little tiny window which shows our printers and then staff can select one. Some printers are only for #10 envelopes, one is only for 9x6, some are HP black and white and some are color Tektronics or Laneir. And we are puchasing and trashing printers all the time. People are always printing wrong. I want to help them and myself. I want my Preference (I think) to hold our printer names (or number?). Then I want it to say which reports can use which pr…
-
- 0 replies
- 934 views
-
-
Is there a way to create a new record in a new file for a found set (of records in another file)-- do you use a portal?
-
- 2 replies
- 1.2k views
-
-
Greetings Folks, I'm wondering if anyone has seen the problem I am having with find requests - I have a script with a "Perform Find[Restore]" where the find request consists of Client::ID[1] (ie. Client::ID = 1). The script works fine when initiated from a layout in the file where the Client table is, but doesn't appear to work in a layout based on the same Client table, in another file (I'm getting a 508 error). Aaagh !
-
- 0 replies
- 807 views
-
-
I've got a value list on a layout based on related file that has a record ID field and a text description field. I want to store the record ID after the value list choice is made but only want to show the text description in the value list and after the selection is made. I can get this to work fine showing both the record ID and the text description but haven't been able to find a simple way to hide the record ID and still use it's value. Any help to a frustrated Access programmer trying to learn Filemaker would be most appreciated. Hunter Desportes
-
- 9 replies
- 2.4k views
-
-
In the Access world I come from, a pop-up (or drop-down) list will often show a list of text values to the user, but actually store a list of hidden numeric values. The "hidden" values are "serial numbers" that have no meaning to the user, but are necessary for completing a relationship. I don't see a way to do this in FileMaker. Am I missing something? Am I "going about it all wrong"? thanks
-
- 1 reply
- 731 views
-
-
Is there a way to view more than the first page of a report when in Preview mode if the Status Bar is hidden?
-
- 4 replies
- 1k views
-
-
-
Hi all, My first experience with FM is really good and I was able to work myself without the help of any guide or book towards a solution required by my employer. I just can't figure out something... I have created a layout, a standard letter containing multiple merge fields. However, I would like to edit these letters in BROWSE mode to be more flexible, edit it directly and then print away. I know that this is not possible, but editing in LAYOUT mode gives me a headache since one cannot see the final outcome without switching back and forth with BROWSE or PREVIEW mode. I also tried copying the text in PREVIEW mode to edit in MS Word, but it is copied as an imag…
-
- 1 reply
- 1.2k views
-
-
I'm a newbie ... Have a simple database for submitting entries (IWP) for a gallery showing. Fields are name, title of piece, size and price. Each person can enter five titles (with price and size). The titles, price and size fields are all repeating. I want to create labels for each title (with the artists name,etc.). I've used the get repeating field function to set up layouts for titles 2, 3, 4, & 5. This is ok unless a person has less than five entries; at that point my label layout is creating (wasting) a name label. How do I create labels for only the titles submitted ... and leave out labels if repeating fields 2,3 and 4 are empty (for example)? t…
-
- 3 replies
- 1.1k views
-
-
I have two tables suppliers & purchasing each have their own layout, I have a portal on suppliers which lists all records relating in purchasing, works very nicely. But what I want to do is create a new layout with a portal on it that will list all records from purchasing not just records that are related to suppliers suppliers. Any assistance with this would be greatly appreciated. Many thanks
-
- 4 replies
- 870 views
-
-
Can you have a portal within a portal, having the second portal related to the first.
-
- 2 replies
- 929 views
-
-
I have created a db using many layouts (70 or so). At one time, when you clicked the Layout menu pop-up button, the layout choices would appear in several columns, right to left. The 2nd column would contine with the layout options where the first one stopped at the bottom of the screen. It no longer does this and you have to scroll down to see them all - a pain in the butt...anyone know how to fix this? I am wondering if this was a earlier version of FM(4?) and now 6 does not let you do it?
-
- 1 reply
- 658 views
-
-
What is the easiest way to display the number of records found out of number of records on a layout? Found: 56 Total: 6,789
-
- 2 replies
- 997 views
-
-
Hi everyone, I have a FM7 doc wih 2 layouts. One for editing and one for printing/preview. In the editing menu i have a portal with an unknown number of rows. I want to print into the Printlayout the portal's rows and just after print another lines from another field (not in portal). This problem may be solved by merge fields (<<FieldName>>). When I have a repetition field and another std field, I can print the lines like that: <<RepetitionField[1]>> <<RepetitionField[2]>> <<RepetitionField[3]>> .... <<RepetitionField[100]>> <<OtherField>> In this solution, The empty…
-
- 5 replies
- 1.2k views
-
-
Hi, Is it natively possible ? I'm playing a bit with it. I can have it slide, but not in the background. You know as a Mac OSX drawer...
-
- 2 replies
- 931 views
-
-
I work with normalized data, so when i use Popups, i have a problem and i need help. How is the best tech to make popups selections when the data lists is normalized? I put the field with the ID code on the layout and the related field over it and chenge the behavior, but when i select it, the FM show me the popup correctly (i don
-
- 5 replies
- 879 views
-
-
I want to open a new window to ie. edit or insert new Customers, and i don
-
- 0 replies
- 813 views
-
-
hi - i'm a documentary filmmaker and am developing a database containing very lengthy transcriptions of interviews. Instead of splitting up the 30 page word documents into seperate records within FMP, is there a way to make multiple pages of the lengthy transcription under one record? i'm not sure if this is an easy process, but i just haven't been able to figure it out. what i'm trying to avoid is having a page that's 50 feet long! edgaroso
-
- 4 replies
- 1.2k views
-
-
i'm building a database for touring bands... each record in the database is a specific show date. right now, i have a portal that shows related records by Artist, filtered by Status (whether the show date is confirmed or not confirmed) and by Date. the user enters in the range of dates to be shown here's the tricky part (tricky for me anyway)... as the user tabs through fields in the portal, i would like the new records that are created to auto-enter an increase in the date by a value of one day, using the previous portal row as the reference. for example, if the last portal row being displayed has a date value of 12/04/2004, i want 12/05/2004 to automatically appe…
-
- 2 replies
- 836 views
-
-
I'm trying to get FileMaker to display calculated values in the color I picked through FileMaker's TextColor function when I display those in fields on layouts I created. For some unclear reason, the calculated values appear in black only, and only show color when I click on them. Is there a known workaround to this? I couldn't find information on this anywhere. Any hints will be much appreciated!
-
- 5 replies
- 2.2k views
-
-
I'm new to FileMaker, so this may be basic, but I couldn't find any good documentation on it. I have an application that tracks hours of operations for airports. Some may only be open certain months, days and hours, so within each month I have the days of the week that it's open and the hours during that day. This makes for a lot of fields and could be tedious data entry to update, so I'm trying to speed things up by giving the user checkboxes on global variables so they can check off, for instance: All Months, Mon-Fri, 9-5 and then click an "Apply" button which will perform a script to go into the database fields and, in this case, apply the time of 9-5 to the M…
-
- 0 replies
- 719 views
-
-
Is alternate background fill working in FM7? This is the first time for me to use it and I can't get it to work. The background is grey where there is no data. Ivan
-
- 2 replies
- 736 views
-
-
I'm a little 7 brain twisted! I have 2 tables: People and Groups - I've placed a Groups portal (Cartesian) on the People layout. In groups I have GroupName, PeopleID and cPeopleID. PeopleID is a comma delimited list of group members and cPeopleID is a calc field that shows the person viewed in the parent record is a group member (shown by a check box). PeopleID populated normally via a script but I can't get cPeopleID to calculate as desired. I'm using PatternCount(?;?) and tried a variety of options with and without new TOs but just can't visualize it and am not getting lucky! Thanks in advance.
-
- 0 replies
- 694 views
-
-
I have this old database for some clients who use it for printing stuff like envelopes and badges. I have rebuilt the database and copied most of the layouts over with the exception of the layouts that print envelopes, badges and other non standard paper stuff. My question is: Is there a way that I can copy the layout from one file(call it one.fp5) to another(two.fp5) and save all the printing margins and settings and what not? I have tried the simple copy and paste method but the printing comes out wonky. I would like to get this done since I am 1000 miles away from the paper and don't know the models of the paper or the envelopes. Help out! Andy
-
- 0 replies
- 755 views
-
-
in layout mode, i can't seem to position/size boxes and lines exactly with the size info box. for example, when i type a field width of 1.35 cm, it snaps to 1.341 instead, grid on or off does not matter. the set rulers command also snaps entered values to something else. putting several objects in a row, this creates quite an error, i.e. after 11 objects like this i'm off by an entire field.
-
- 1 reply
- 866 views
-
-
I am having a problem getting checkboxes to work. I have a value list ready to go, I pick checkboxes as an option, but no checkboxes come out. Only the list is showed but no box to click.
-
- 1 reply
- 857 views
-
-
Hi! FileMaker 7, OS X 10.3. I'm new to complex FMP databases. I'm working on a project management solution for my company; it will replace a very heavy Excel file that takes 5-10 minutes to calculate, even when it's empty. I have a projects table, another one for phases and a trio of tables that contain detailed expenses related to each project and phase. The first table is for budget figures, the second keeps track of engaged expenses (for daily expense tracking) and the third is set to import data from the accounting department (to get final numbers). These expenses need to be coded according to their type (4405 for post-production fees, 6208…
-
- 1 reply
- 880 views
-
-
I just learned a neat technique that I've never run across in the Forum. To produce subtotals that run across a page, rotate your total fields to print vertically. Align these vertical fields tightly together, and you can get something like the following without having to use GetSummary Total for April May June Cost 1100 4705 3100 Profit 540 660 225 The labels on the left go in the footer (also rotated vertical) and fields for month/cost/profit (in this made-up case) go in the sub-summary. Obesefeline
-
- 0 replies
- 764 views
-
-
Please help! Is there anyway to "freeze" a column like you can in Excel, so that when I scroll over to the right, my first column will stay put? Thanks
-
- 1 reply
- 1k views
-
-
I always work with object size box displayed (and px size). Occasionally I get two funky problems I can't identify and ask for assistance on it. Text field 175 px wide, font size 13 Verdana. Usually, I can select Format, Line Spacing, Custom and change the left indent to 5.00 px to move the text away from the border but now I get ... 'The left margin cannot exceed the right margin or the object's boundaries." Indent Left 0.00 px, Right 0.00 px, align left and no tabs or anything else set. But when I try to change left or right indent to 5.00 px it refuses - only on occasion like today constantly. The other problem I occasionaly get (and did again toda…
-
- 1 reply
- 963 views
-
-
Hi guys... I'm stuck...again! I have two files - an invoice file and a file containing a list of all possible services. In the service item file I have flagged some of the services as "hot" items and want to display these items as a value list in the Invoice file. I created a value list in the service item file that displays the "hot" items correctly (based on a relationship), but it won't display in the Invoice file... I'm sure I'm being dim, but I can't figure out what I'm doing wrong. Please help... Thanks Dave
-
- 2 replies
- 765 views
-
-
I am creating a new recipe in a portal on the persons layout. Only the name of the recipe is created. From here I want to go to the layout where information is added. I have tried a script attached to button: Commit records/request Go to related record (show only related records) also tried it without show only The script takes me to the correct layout but always to the first record. Seems to me that I may need to do a find, but have failed to create a find that picks up the recipe name and finds itself in the layout. The portal is in the layout of the person creating the recipe and is related through the person key.
-
- 22 replies
- 1.9k views
-
-
Hi, Is there any way to use a "Loop" construct to loop through all repeating field indices and (for instance) set them to "". I am currently doing the following: Clear( Select; Table::RepeatingField ) Clear( Select; Table::RepeatingField[2] ) ... It will be a pain if the repeating field has 100 items in it ! Thanks.
-
- 5 replies
- 1.1k views
-
-
See attached. I have used a technique I found for highlighting a current row but as soon as you go to the row of another portal it lose its focus there. Is there anyway of making these portal stay highlighted as you move across them? Any help would be great Thanks mutilple_portals.zip
-
- 1 reply
- 770 views
-
-
I would like to be able to divide a single layout into four pages for viewing and printing purposes. I envision scripting a button that will navigate the user to each corner of the layout. When they get to the specific corner they want, it should fill the screen as though there was only one layout. Does anybody have an idea how to do this? Thanks, Jarvis
-
- 0 replies
- 712 views
-
-
Hi everybody, i need help please i'm trying to create a simple membership database, where i can store the date when they create their card and when it will expired. and also, maintain the type of membership. if, they choose "family" then they need to fill out the groupInfo portal. Problems: 1. if they choose "family" in their first period of their membership, and renew it as "individual", the groupInfo portal doesn't go empty. 2. if i click on the any of the row (history portal), the groupInfo portal show the same list. what i want is to filter it out (family and individual). (i want it to works like the history layout) What should i change…
-
- 7 replies
- 997 views
-
-
Is there a standard development approach to layouts for dbs? Normally when I design dbs I design layouts to go with each db. For example, on a client db there would be layouts for entering new clients, searching, displaying search results, editing single records and the like. This is a typical FM approach, at least insofar as the books are concerned. Some layouts would have self-joins and/or other relationships and portals other would have subsummary and trailing summary reports. Essentially if the layout items were of direct concern to the information stored in the db it would stay with the db. I've begun to question the logic of this approach. I wonder if it…
-
- 1 reply
- 1.3k views
-
-
hi all~ is it possible to export portal records in FM 7? if so... how? thanks.
-
- 4 replies
- 1.6k views
-
-
Hello there!... I'm quite new to FileMaker and I seem to have a problem with using portals. I'm sort of creating a prototype database system that would handle Fashion and Accessories. 90% of my tables are already interconnected with relationships. For one, I already incorporated a Costing Sheet Form that uses a portal for input, and also made another form to list all my costing sheet data(also using portals). I've used this method from one table to another (e.g. My Costing Sheet data gets used under my Proforma Invoice Form, where it attempts to passively capture related costing sheet records and place the data into corresponding related fields in my PI. What I …
-
- 4 replies
- 794 views
-
-
Hi All, i have a field calculation were if a certain instance occurs it enters a message in to a field and if another instance occurs it enters another message. now id like to if possible make one message text go red and the other green. How can i do this? Thanks in advance.
-
- 4 replies
- 1.3k views
-
-
I'm creating simple subsummary reports including a CounterSum field, to get numbers of items within various groups. Not a big issue. EXCEPT that when I start a new layout, blank, and add the subsummary parts, the printout is leaving somewhere around 5 pages of paper between the first line and the next one... and the next... etc. If I dupe an existing layout and just change the subsummary definition and fields, it prints right. There is no difference between the new one and the existing one, except that one prints right and one doesn't... This may be the first time I've added new layouts since I started using Filemaker 6, so that may be part of this. I've tried recovering …
-
- 1 reply
- 917 views
-
-
My problem is finding a recipe item in a large set of records, 6,600 in total and displaying the found list so that the user, on the web, can select one item. I deem the table and list views to be too limiting. For example a search on chicken will return more than 100 hits. I am wondering if it is possible to: Create a layout that contains a find function and a portal. The find would return a list of portal row numbers and the portal would sort them to the top.
-
- 1 reply
- 735 views
-
-
I would like to do the following and I am not sure it will work (I can't figure it out). I have a checklist of items that the user will click on as done/not done/or N/A. I have this list of items in a portal on a layout, as the layout contains other information and the portal just needs to be there, Now the admin of the system will add to, remove, change, etc., this list of items, and when the user creates a NEW checklist, these admin items will show up in the portal list. For example... List of items admin enters (let's say in a 30 rep text field)... Checklist Item 1 Checklist Item 2 Checklist Item 3 ... Checklist Item NN Now the USE…
-
- 4 replies
- 796 views
-
-
Hello, I am currently updating a number of databases that use many to many relationships. I've made use of the pipelining portal to streamline and simplify data entry, but have run into a snag. I know this should be simple, but I can't figure out what I am missing. I have three files: Courses, Instructors and CourseInstrJoin. Each course can have several instructors, and each instructor can teach many courses, hence the Many to Many reln. Here's where I'm stuck. I need to place data in the join file itself because there are instances where I need to record a piece of data for an instructor for a specific course. Like hours of teaching, for example. How do…
-
- 4 replies
- 818 views
-
-
I have several portals and they all do it. When I'm at the bottom of the portal and then scroll back upwards, it's like FM forgets where it placed its lines and they double-appear all the way up. It's so bad I can't even read the text in the portal. Only clicking down again will it clear itself. Is there anything I can do to solve this problem. It looks terrible. I searched and found similar problems but not this one. Those can't be fixed. Can this one? LindaG DAC
-
- 4 replies
- 787 views
-
-
I created a value list based on the records in a particular relationship. I created a script step that populates a field in the core table with the items in this value list. This field was used as a filter for a second relationship. This script was working fine until recently. I created a few other relationships that are based on the same parent table as the relationship that creates the value list. Now, the script refuses to "Set Field". Any suggestions?
-
- 3 replies
- 1.3k views
-
-
I've seen some solutions that scream amature/newbie when I notice lots of inconsistencies in the interface. I'm at the starting point of a new (huge) project and want to make a choice about some interface issues early on. The project is an Electronic Medical Record system used by many different users and discplines in a hospital. It's likley the users will be flipping between a couple of applications (including DOS type), and typically will interact with the system for 10 or 15 minute intervals throughout the day. OneQuestion is Field Labels... so where do you put your labels? [ ] Above the field [ ] To the Left, and aligned to the LEFT [ ] to the Le…
-
- 5 replies
- 1.4k views
-
-
I have a Patient file displaying data from a Reports table and Evaluation table through their individual portals. Both Reports and Evaluations are related to Patient via PatID field. Evaluation and Report tables are related through Eval#. TempID is a global field accessed via a universal link calculated field _constant=1 Script to create Report record: set field Evaluation:TempID, Eval# go to layout Reports new record request set field Report:Eval#, Evaluation_constant:TempID set field Report:PatID, Evaluation:PatID The Report and Evaluation tables are related through Eval# because data from Eval is merged into the Report record. I know my Pa…
-
- 4 replies
- 694 views
-
-
Hi, I currently have a database with a value list in it. This list gets a client_ID added to it via a relationship with another database. Every time a Client_ID with a type of "PW" gets added to the related DB, the value list in the file I am working on gets that Client_ID added to it. This part works fine. Now, what I would like to happen is have a record created in the database with the value list for each client_ID, with the value auto entered into the CID field. Currently there are 43 client_ID's in the list, so I would need 43 records. However if a 44th gets added via the previously mentioned relationship, it should automatically add a 44th record with …
-
- 0 replies
- 758 views
-
-
I notice that even when using cross-platform typefaces like Georgia and Verdana, some text-intensive layouts do not display the same on both platforms. It seems to focus on line height - a block of text laid out on the Mac, with a number of line breaks in it, lined up niecely with other fixed elements on the page, will not line up when displayed on a Windows machine - the line heights show up as higher, so the text runs longer down the page, not lined up with the fixed elements. Sometimes I can work around this by making each line of text its own text box - but when users are contributing text to a large field, I can't go in there breaking things up into boxes -…
-
- 2 replies
- 1.3k views
-
-
I have a (fairly simple) report that wants to sort alphabetically instead of by the custom sort based on value list I've specified. What are the likely/possible causes of this? Specifics: I'm doing a membership list for an organization with 3 levels of membership: voting, minors, inactive (V, M, I). The list uses a subsummary report that lists the members by category with a count of each category. Subsummary part: fields: status (this is the V, M, I list) & count Body: fields: name, mbrship date, status (V, M, I), serial# The script that runs this first calls a subscript to find and sort the appropriate names (this subscript sorts first by mbrship sta…
-
- 4 replies
- 870 views
-
-
Here is my scenario I have 2 files one containing names of subjects and the other of diffferent tasks the subjects perform. Every time a subject is entered a set of tasks that the subject performed is assigned to them. Because there are a large number of tasks I want to be able to display just various categories of tasks. This I was able to accomplish using techniques for dynamic value lists described in this forum. Each task record in the task file also has a field for category. Then in the subject file the user makes a choice of category to display. Through a relationship I can then show just task names where the categories match. The problem is I also want a choi…
-
- 2 replies
- 824 views
-
-
I have a core table called "Clients". It has related a table called "Fleets" and another table called "Jurisdictions". There is another table that is related to "Fleets" called "Units". "Units" has a table called "trips". Each "Fleet" is authorized to travel in a certain group of "Jurisdictions" (states). Each "Unit" (truck) that belongs to a "Fleet" and travels in a "Jurisdiction" has to keep a "trip" record. I use my database to record these "trip" records. Upon entering the "state" field of a new trip record, a value list appears that is based on the "jurisdictions" that are related to the client. This helps avoid user error by inadvertantly ent…
-
- 8 replies
- 1.1k views
-
-
Newbie here! Hello All! Been using Filemaker for 3 days now so be easy on me.... I have 2 tables: photos and categories. I want photos to be a child of categories in that photos has a category field that I want to be a reference to the category table. I know that this can be done by creating a pop-up in the photos layout that gets its values from categories - but that is a poor solution if I ever wanted to edit the category list. I attempted relating the tables and creating a portal in the photos layout and it almost worked - but one problem still remains. I removed the "category" field from the layout and replaced it with the portal which is a pop-up w…
-
- 10 replies
- 1.1k views
-
-
Hi Everybody! Here's today's issue. I have for one of my customers a database with three tables in it. One table is for all of my contacts, and I have three types of contacts, Customers, Vendors, and Employees. When a contact is created one of those three options (Customers, Vendors, and Employees) is selected from a value list to assign a Contact Type to each Contact. I use that Type in a calculation field along with an auto-entered serial value to assign a Unique ID to each Contact. (the calculation is "Contact Type Code & Contact ID"). For instance my first contact in the lsit is an Employee whose Uinque ID is E1, next record is a vendor (V2), and s…
-
- 11 replies
- 1.2k views
-
-
I have not posted here before but I did not see this topic anywhere else. So, please pardon the question if it has been brought up before. I am creating a file with multiple tables. The primary key for many of the tables is a field containing the employee's id number. There is a a table which will reference the employee id from another table containg employee benefit information. I have created a field in the second table which has a pop-up list referencing a value list in the parent table. The pop-up list works correctly and retrieves all of the employee ids from the parent table. If I add a second field to the value list, such as last name, the pop-up list performs…
-
- 1 reply
- 821 views
-
-
The great thing about value lists is that it automaticly removes multiple instances from the value list. But, now i have a need to keep multiple instances in my value list. Even more, i also want the list to be sorted alphanuerical (not ASCII). Suppose the relation that is used delivers the following records to the valuelist: aaa bbb ccc ddd eee aaa ddd Normaly the valuelist would be aaa bbb ccc ddd eee but now i want to be the value list aaa ddd aaa bbb ccc ddd eee Does anyone know how to achieve this in FMP 5.5 Thanks a lot Jitse Schaafsma
-
- 2 replies
- 669 views
-
-
I have a portal that displays data from a field in another db (of course!) that has "name", "type of activity", "activity group" fields. I want to select data from the "type of activity field" depending on the "activity group", to be displayed in the portal. Do I set up a new calculation field in the source database that matches data to the "type of activity" or can I set up a script to do the same in the master database? TIA The Novice...Stephen K
-
- 10 replies
- 1.2k views
-
-
I'm trying to indent the second half of a line without also indenting the first, so that the end result - doesn't (can't do it here either) ---- look like: Category: datadatadatadatadatadatadatadatadatadatadata datadatadatadatadatadatadatadatadatadatadata datadatadatadatadatadatadatadatadatadatadata So I'd like all the data evenly indented to the right, leaving space below "category." The problem is, every time I indent part of a line (data) the whole line (including the category) is indented. Any ideas?
-
- 8 replies
- 1.3k views
-
-
I modified one of the templates that comes with FMP 7 - I'd like to use it in a different Filemaker database. Is it possible to do that? thanks!
-
- 2 replies
- 1k views
-
-
I have a problem with searching in the portal rows. Some of the values are accepted and i get the result of my search but for some of them i get a fout which says " The difinition says that the field can contain only the numeric values,..." how is that possible? I don't have a field with a numeric value and for some of the words i don't get any errors! Can anybody helps me please? Thanks,
-
- 3 replies
- 645 views
-
-
I want to enter multiple selections from a pop-up list, but find it will only allow single entries into the field. A pop-up menu is no good as it is not friendly to use, and dangerous when browsing, as it is easy to lose previously inserted data.Same goes for check boxes. The pop-up also needs to allow user entry into the field. The ordinary old pop-up list would be ideal if it could be made to accept multiple entries. Any ideas? Rex
-
- 8 replies
- 1.2k views
-
-
Just been using FM for 1 month, so sorry if answer is obvious. (Using FM 7 on WinXP.) I have a DB with two related tables - People and Stuff. They're related through a person_ID field. Each person may have zero or more "stuff" records. I want to create a list report that will give information about a person (e.g., name, address) and then one line under that info for each related "stuff" record. With subsummary I have done that just fine, using the person_ID as the break field. However, my users don't want the order of the report to be by person_ID - they don't know or care what the ID's are. Rather, the report should be sorted by the LastName field of the Peop…
-
- 1 reply
- 835 views
-
-
Hi - I've just installed FM6 on my new machine and I now seem to be missing some of the Avery labels from the labels layout. The full list showed on my old PC, but not on my new one. Can anyone help - this is the first time I have used a forum - hopefully I'm doing it the right way!! Thanks, Brenda
-
- 0 replies
- 975 views
-
-
I am trying to do something that may not be possible. Any help much appreciated. In attached file is a list of cost (in the "data" layout), each assigned to a project and budget line. The layout "summary" allows costs for any one project to be shown in a portal (via a self join relationship) and the total cost for that project displayed below. All OK so far. I want to be able to show costs in a portal for the given search project, but summarised by budget line, ie there should be one line in the portal for each budget line for which that project has costs, and the associated cost value should sum all the cost items for that project under that budget line. ie …
-
- 2 replies
- 998 views
-
-
I've developed some survey questions. Each question has four answers: NA, Not Important,Important and Very Important. All four are a value list which are marked with a radio button. When I do a find and check NA I get what appears to be a true number. I think Not Important is accurate. But when I ask for, click in the box Very Important I get all of the Importants as well. Any idea why just clicking in any one of the boxes does not get me the individual answer?
-
- 2 replies
- 631 views
-
-
Is there a way to prevent portal scrolls back to the top row whenever you click outside the portal? I am using FileMaker 6.0.
-
- 1 reply
- 598 views
-
-
Need a little fundamental help. I've developed a database solution with one master layout file, and 4 data files. The master layout file contains only related fields from the 4 data files. What I'm needing to do is on one of the layouts in the master file, create a list of records from 3 fields out of one of the data files. Can I do this within a portal? Can I script a loop somehow? I'm not too adept yet at ScriptMaker, so be gentle. Thanks!
-
- 6 replies
- 956 views
-
-
I have a set of three radio buttons I am working with. I would like the database to switch to a different layout when one of the three buttons is selected. Each button needs to go to a different layout. Is this possible? How can I make the magic happen?
-
- 6 replies
- 913 views
-
-
I'm creating a layout to print a sheet of Avery 5160 labels. FileMaker Pro 7 can generate this layout for you automatically. But when it prints out, the last row of labels doesn't get printed. It is as though the bottom margin is up too high. Anyone have any experience with this and/or a solution?
-
- 1 reply
- 1.7k views
-
-
I am working on a new solution in v7. Created a portal with create new records property selected. I entered some records for testing, then selected one portal row item and chose Delete Record. At the prompt for "Delete this Record?" I clicked yes and it deleted ALL the rows. Is this the expected behavior? Or am I missing something? I sure did not expect to have all the rows delete. I tried it a couple of times to be sure I did not select delete all records.
-
- 2 replies
- 738 views
-
-
How do I set up my Job Tasks portal so that I can create records from the portal? I've moved from system 5.5 to 7 and don't know if there is something different or if I just forgotten how. My Job Tasks portal contains a job number field which relates to the Jobs Record layout/table that holds the portal. I can create records from the Job Tasks layout/table and see it in the portal on the Jobs Record layout but can't get the portal to give me a new record. Help please
-
- 2 replies
- 661 views
-
-
I have a field that when accessed displays a pop-up list linked to a field in another db. But when clicked it displays the value list across the screen with some long records truncated...the file contains about 130 records Am I able to format the pop-up window...add spaces to the records...I know i can if I type the information using Custom Values in Edit Value List...but I don't know how to if I use Values from a field... Or should I try another solution? Help please
-
- 4 replies
- 798 views
-
-
Hi everyone. I'm having a little trouble creating a layout. Maybe it's just Friday and I'm burnt out :-) ...or maybe I'm going about this all wrong. Either way, I need a little help! Here goes... I have a Notes table containing client notes. This table relates to several other tables including a Clients table and a Users table. We don't need to worry about the Clients table right now. Notes can serve as tasks by adding a due date. If there's no due date, a flag defines the record as a note. If there is a due date, the note becomes a task. When the note becomes a task, it must also have a task owner. This is how the note record relates to the Users table. …
-
- 4 replies
- 903 views
-
-
i was just looking throught the business tracker to get a first look at some filemaker 7 solutions. I'm still not that impressed with the fact that you don't seem to be able to have frames. i.e have a single top menu and a frame below that which you can use to navigate to different layouts to via the menu ...or have I missed something and this is now possible? Does anyone have any good demo files that show off some of the new things it can now do over filemaker 6?: Thanks
-
- 0 replies
- 840 views
-
-
Hi! It's been a while. <sigh> RL can be a pain <lol>! I'm still with the calendar popup problems of always. I was hoping to finally get this resolved. All the good calendar popups seem to be shareware, naturally. And of those freeware ones posted by kind people one or two seem like they'd be almost as good but coding them into a solution has always been a severe problem for me. I have never, in all these years, been able to figure out how to get one to work. Is there any advice anyone can give and a freeware one they can recommend that a newbie can handle? (A URL if known would be really neat, too.) It's a tall order, but one of my so…
-
- 5 replies
- 1.3k views
-
-
I'm having a problem with my portals. It's a total graphical thing. My data is fine, but when I use the vertical scroll bar to scroll down, the fields get messed up. It's hard to explain, but I took some screen grabs I'll attach. It seems the when scrolling down, the rows that appear at the bottom of the portal are getting some ghosting of the fields previously there. And when I get to the bottom of the list, if I continue to hit the down arrow on the scroll bar, all the rows in the portal will get populated with the data in the last row. Was wondering if anyone has had this problem? Archive.zip
-
- 2 replies
- 784 views
-
-
http://www.nightwing.com.au/FileMaker/demos1.html on CobaltSky demo for highlighting it involves basically entry in to a field for the highlight to activate - this makes the record locked - is there a way of doing the highlighting but not locking the record once it is highlighted? Any ideas??? Thanks
-
- 3 replies
- 995 views
-
-
Hi: I have some legacy databases that I am working with and I am trying toa dd some functionality for my office staff. I have a Customer database with all contact info for my customers. I have a Vendors database with all my contact info for my vendors. I also have a Documents database that is related to both of the other databases. I frequently make documents to my customers, and I frequently make documents to Vendors. I use the Documents database to make documents to my customers and my vendors ( which sometimes refers to info from my customer file). However, I have just come upon a request for a new Document which could be directed to either customers or vend…
-
- 11 replies
- 1.1k views
-
-
I am having a devil of a time getting my records to layout in the fashion we require for our proposals. When I use list view it doesn't summarize the records by room but rather lists them individually. I put a portal in the body and it summarizes by room but then only shows one room. I have attached a graphic example of what I'm trying to achieve (.jpg) i would appreciate any ffedback that anyone may be able to offer. This ones been a real headscratcher for me. LOL
-
- 1 reply
- 853 views
-
-
What is the best way to highlight a row in a list view ? I am using FMP 6.0. The records contain 8 fields and when I toggle through them, I would like the entire row(all the fields) to change a color to show that row is highlighted. Thanks for all the help Cheers.
-
- 6 replies
- 1.2k views
-
-
A little nit picky of a detail but how does one add those little arrows on the far right of a pop up menu or list? It's real useful for showing people that there's a dropdown menu there. Sounds way too easy for me to even have to ask this question.
-
- 7 replies
- 1.4k views
-
-
Is there a way to get more than 2 fields in a value list. For example: I have a popup list linked to a value list. That value list is looking up 2 values from another table. When I click on the popup I only see those 2 values. Is there a way to add a third or fourth? Thanks for your time
-
- 5 replies
- 869 views
-
-
HI all, boss wants to set the values on several of our value lists so they change automatically. example: Customer Status field contains 'Active' 'Inactive' 'dead'. He wants to enter a number smewhere (rules) and it be something like this thinking If Customer Invoices = 0 (they never ordered) or haven't ordered within ____ years, call them dead. Between 5 years and 2 years, inactive; and if they have ordered within two years call them active. I have calcs now that do it (unstored) but the determining time-length is set. How would you allow boss to enter these numbers? Would I write onto layout (use text tool) the questions and place fields where he …
-
- 2 replies
- 725 views
-
-
I have been trying to get a subsummary report to work all day long. I want one field to head a group of all the other related records. LIke a heading. I know you have to sort to get it to work but it still isn't. Are there any other suggestions? Stan
-
- 3 replies
- 924 views
-
-
Reproducibly reliable, at least on Panther (10.3) and FM7.0v2: any letter-keystroke in my radio button related-value-list field causes FM to crash (unexpected quit). Background: I'm experimenting with the best kind of quick-select from a related list. I had been using pop-ups because of their easy arrow-or-type navigation, compared to portal rows with buttons, but pop-ups always max out at a dozen items or something like that before scrolling, and you can't see the list until you tab into the field. So, I liked radio button fields because they can show values in my choice of fonts, displaying as many values as exist if the field is made "tall" enough. It was nice: ta…
-
- 1 reply
- 721 views
-
-
Is anyone knows if it's possible to create unsorted value list? I need to create a value list consisting of all time values from another file, but the times are formatted in the text fields. I don't want the times be sorted as text.
-
- 1 reply
- 898 views
-
-
How do you protect a file from being deleted after it is created? This is my configuration: Portal Setup- Allow deletion of portal records (not checked) Edit Relationships- When deleting a record in this file, also delete related records (Not checked) Still allows deletion of files linked to portal.
-
- 1 reply
- 685 views
-
-
Hello all ! I am working on our product's interface design. I would like to know if there is a way to remove the black border when the field is selected ? Also, I am gettting a dotted border on the unselect field, is there a way to remove that ? Cheers, Travis
-
- 3 replies
- 970 views
-
-
Hi all I have a value list which people can choose a certain criteria (Criteria 1). I want another value list (Criteria 2) to appear next to it in another field based on what they have originally chosen. Essentially I want value list 2 to be determined by what has been chosen in value list 1. Hope that makes sense
-
- 3 replies
- 758 views
-
-
Hi all, I have two problems: 1) I am working on a document control DB and was wondering if it is possible to put a link to a document in a portal and make that clickable to open the file? I know you can click to open a file if the link is stored in a container. I was thinking maybe I can put containers inside the portal but when I do this, clicking on the portal row does nothing. Maybe format the portal row as a button and have a script find the link and open it is the way to go? 2) Can I show a report in a container or portal field? Any help would be greatly appreciated, Rich.
-
- 0 replies
- 683 views
-
-
I am using fmp6 with the web server connector to host a website. I am using cdml to process commands to the database. When I search for something on the site I type in what I am looking for and I press submit everything works fine. If I press return then I get the following error:
-
- 1 reply
- 745 views
-
Recently Browsing 0
- No registered users viewing this page.