FileMaker Interface Features

I'm trying to create a daily invoice report laid out like this: Page Header -- Invoice 1 customer information ---- Line Item 1 ---- Line Item 2 ---- Line Item 3 -- Invoice 2 customer information ---- Line Item 1 ---- Line Item 2 -- Invoice 3 customer information -- Invoice 4 customer information ---- Line Item 1 ---- Line Item 2 Page Footer I've tried the inside-out approach of using LineItems as the master file, sorting them by Invoice_ID, and displaying them on a layout as follows: Header Sub-summary by Invoice_ID (Leading) [contains Invoice cust. info] Body [contains line item info] After Viewing as List in Preview Mode, …

• 8 replies
• 1k views

Mandu

January 15, 200521 yr

Greetings All! I have a database that I use to keep a journal. Some entries (records) can be as little as 100 words, some can be as verbose as 5000. The layout I use to add to the journal has a 'main-body' text-box of about 30 lines, complete with scroll bars. That's fine when I add to the journal, but what about when I want to print? How can I set up a layout so a 100 word entry prints on one page, but a 5000 word entry prints on multiple pages? Thanks, Sydneytim

• 5 replies
• 1.5k views

-Queue-

January 14, 200521 yr

I'm stumped. I have two tables. Pricelines and PriceMatrix. I've always used the Pricelines "code" field as my look up reference. I then could bring the field value into my quotes, invoice, jobs etc. Now I'm trying to create a matrix to simplify the creation of new records in Pricelines with a improved interface. I don't know how to get all of the needed data in Pricelines from Pricematrix. I need the matrix to be dynamic and I would need several matrix with different price schedules. How can I make "number of colors", and "quantities" dynamic? Would it be possible for the user to choose how many price points and colors they would like available on their matr…

• 2 replies
• 973 views

transpower

January 14, 200521 yr

I'm setting up a contact db for a community organization using FMP7. I have a field "Category" that is defined as a value list containing Member Officer Resource And I have value lists for each of those Categories. I want to have field ("Role") next to it on the layout whose content is chosen from a drop down list. The drop down list that is displayed in the Role field should be conditional upon the the contents of the Category field. Assuming the appropriate drop down field is displayed, the user would the choose one of those values. My question is, what script would cause the appropriate drop down list to appear in "Role". Sh…

• 7 replies
• 1.4k views

Søren Dyhr

January 14, 200521 yr

Hi all. And happy new year. I can't figure out how to properly get a calculated percentage in a subsummary part. Let's say I have records consisting of People, with data consisting of QuantA and QuantB and a QuantTotal for each record. I can run a subsummary showing the assigned subtotals for each record easily by placing a summary field defined to look at each QuantA, QuantB, and QuantTotal. Easy! What I can't do is show in the same subsummary, a proper ratio (expressed as a percentage) of QuantA to QuantB for the records summarized under that Person. What I'd like to see in the subsummary would be: PersonA QuantA QuantB ABRatio QuantT…

• 2 replies
• 875 views

bdarch

January 13, 200521 yr

I'm an FMP novice, moving up from Appleworks. I like it! I've inherited a database, one of whose layouts has non-field objects in the header part. When I look at the layout in preview mode the objects are invisible. If I create my own layout and put objects in the header, they are always visible in preview no matter how I view the layout. If I copy the objects from the first layout into mine, they disappear in preview. I can't find any explanation of this behaviour anywhere, even in the Filemaker Bible. Can anyone explain by what alchemy these objects can be made to vanish in preview mode? (PS: this post should be in the layouts forum, but there's no obviou…

• 2 replies
• 845 views

Ezlxq

January 13, 200521 yr

I sended this post in Fmpro.it forum, but this is in Italian:

• 24 replies
• 2.4k views

-Queue-

January 13, 200521 yr

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

• 44 replies
• 5k views

Joseph31

January 13, 200521 yr

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

• 2 replies
• 829 views

ChasCH

January 13, 200521 yr

Hello- I am new both to this forum and to FMP. I am having problems limiting some value list dropdowns depending on a selection made in a different field, but same layout. I am hoping someone will be able to help me out. I am making a database to keep track of orthopaedic surgeries and I would like to have the dropdown list of component sizes to be dependent on the brand of implant used. I have a separate calculation field (using ValueListItems) which shows the correct sizes for each brand used. Then I have a field with value lists from this calculation field that allows the user to select the size. The problem is, all the values show from the different brands, a…

• 4 replies
• 1k views

niessen

January 13, 200521 yr

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

• 0 replies
• 618 views

MarvinJ920

January 13, 200521 yr

I have read many of the existing posts regarding "dynamic value lists", but despite my best efforts, I am yet to achieve the goal as outlined below. I would be grateful for your instruction. Step-by-step would be great, a functioning sample database as an attachment would be ideal, but I'll take any help I can get! Information relating to various aspects of my life is kept in a single database. I currently organise the files in the database using a field (editable pull down menu) named 'category'. The main categories of my database are: CLIENTS, FAMILY and RESOURCES. Basically, I would like to improve the functionality of the database by introducing …

• 4 replies
• 867 views

sydneytim

January 13, 200521 yr

Hello, I have a layout with four pages which are accessed via "tab" buttons. For some reason, in "Browse" mode the first page jumps out to full screen (horizontally) showing a huge expanse of white space while the other pages remain at their defined horizontal size. I can't figure out what is different about this first page. Does anyone have suggestions as to where I should look to find the problem? TIA, rlbryant

• 6 replies
• 1.3k views

Oldfogey

January 13, 200521 yr

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

• 7 replies
• 718 views

QuinTech

January 12, 200521 yr

I have inherited a database that somehow lost the FM-generated list and table views for the main data entry form. How can I recreate new list and table views that will be used by FM when the user selects "View As Table" or "View As List" from the View menu? Or how can I get access to the forms FM is currently using for these Views (totally discombobulated!!) and change them? Thank you, rlbryant

• 0 replies
• 652 views

rlbryant

January 12, 200521 yr

Problem: I tab into a pop-up list field. I hit the down arrow until the selection I want is highlighted. I hit tab to go onto the next field. But the value I selected is not saved in the field, unless I hit 'return' instead of 'tab'. Anyone know of a way to force Filemaker to keep the selected pop-up list value when you tab out of the field? I'd like to eliminate the extra 'enter' you have to type. Thanks to everyone who posts on this forum, it's extremely helpful. Hopefully soon I'll have enough experience to contribute back more.

• 3 replies
• 918 views

eJK

January 12, 200521 yr

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

• 12 replies
• 993 views

Ugo DI LUCA

January 12, 200521 yr

I work in the print industry and I am in the process of creating an estimation database. What I would like to do is have two drop down menus for specifying the type of paper depending on the type of printing. Here is what I mean: If I choose color printing in the first field then the second field will show the paper choices for color printing. If I choose B/W printing in the first field then the second field will show the paper choices for B/W printing. I understand how to create value lists but i am unsure of how to set the second field so it will change depending on what is entered in the first field. Thanks to anyone who can help me with this.

• 15 replies
• 1.2k views

-Queue-

January 12, 200521 yr

Does anyone know of a way I can get my portal windows to scroll with the mouse wheel?

• 0 replies
• 714 views

Papabjoe

January 12, 200521 yr

How can I number my records so that the numbering starts over with each Sub-Summary occurrence? In other words, I am looking for a way for the record numbering to restart after each occurence the same way page numbers restart when that option is checked. Thanks, Par

• 1 reply
• 784 views

-Queue-

January 11, 200521 yr

I have a db which has multiple tables which are all linked via a unique number When I create a new record in the contact layout and then want to go a second layout which contains data from another table I cant get into that layout useing the script GTRR as there is no related record in this table. How do I set it so when I create a new record in one table it creates a record in all the tables? Kirsty

• 3 replies
• 885 views

-Queue-

January 11, 200521 yr

I have a set of information that looks like this: last first option1 option2 option3 total jobitz, larry 22.00 41.01 33.05 96.06 largin, marv 14.03 12.22 21.20 47.45 how do i make it so that i can total every column and show up as if it were the final entry in the list? like this: last first option1 option2 option3 total jobitz, larry 22.00 41.01 33.05 96.06 largin, marv 14.03 12.22 22.20 48.45 -------------------------------------------- totals: 36.03 53.23 54.25 144.51 instead of like this: last first option1 option2 option3 total jobitz, larry 22.00 41.01 33.05 96.06 totals: 36.03 53.23 54.25 144.51 largin, marv …

• 2 replies
• 688 views

-Queue-

January 11, 200521 yr

I have just created a database for my birding life list. (I know, sounds like a code unless you are into birds.) I would like to be able to indicate on each record (if needed) whether the bird's name is recently changed/updated or not, and if there are other factors listed or not. With HyperCard I could easily create and script a check box (click once and an "X" appears, click again and it disappears...for each individual record). Or, similarly, create a clickable radio-type button (click once to indicate it's been clicked, or click again to remove the indication). If it were only 1 button or box, then I could easily create an alternate button graphic for a 2nd othe…

• 1 reply
• 995 views

comment

January 11, 200521 yr

Hello, I have a form containing 3 fields as categorization called "

• 3 replies
• 741 views

-Queue-

January 11, 200521 yr

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

• 2 replies
• 636 views

joki1975

January 11, 200521 yr

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

• 0 replies
• 813 views

silhougal

January 11, 200521 yr

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

• 0 replies
• 728 views

Questions King

January 11, 200521 yr

Hi, I have a layout which has a global field, i use this for searching. and it's been decided it should be a button to keep user simply typing something and not pressing the find button - yes an option is to write code to say "You didn't click lookup!! or display the dialog" for now, i'm interested in having the field be a button. I set it to a button, but I can still tab into it and type anything I want. what option did I miss? I unchecked just about everything in field behaviors. what's the solution? thanks, Sincerely, J__

• 3 replies
• 787 views

J__

January 10, 200521 yr

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

• 3 replies
• 660 views

Joseph31

January 10, 200521 yr

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

• 2 replies
• 609 views

Papabjoe

January 10, 200521 yr

I am currently using the one script to go to certain layouts and changing the script parameter of each button to the name of the layout to go to. The script then gets the script parameter to determine which layout to go to. Easy. What if I want to have two script parameters. One holds the layout name to jump to and another determines whether a new window is opened when going to that layout. So, ScriptParameter = a = staff ; b = new_window and then in the script: If b = "new_window" go to layout "a" in a new window else go to layout "a" end if How can I do that? Widey

• 5 replies
• 1.3k views

-Queue-

January 10, 200521 yr

Hi! I have one table company and related tables employees, computers, vehicles, etc. I know how to create report to show data separately for each table for example computers: Company name Computers - Computer 1 - Computer 2 ... How can I create report that show all the data for one company like: Company name Employees - Employee 1 - Employee 2 ... Computers - Computer 1 - Computer 2 ... Vehicles ... Thanks

• 1 reply
• 696 views

-Queue-

January 10, 200521 yr

I've created a report using a few subsummary sorts. It sorts by category then by code. So my lines look like this: Category 7 Records $2100 Code 1 3 records $900 Code 2 4 records $1200 Catgory 2 3 Records Code 1 1 Record Code 2 2 Record I need to find out how I can put a formula into the subsummary without it calculating all records instead of records shown. I'm not sure if I understand my own question but any help would be greatly appreciated. Thanks

• 1 reply
• 680 views

-Queue-

January 10, 200521 yr

Hi. I have tree tables vendor, model and category i try to make a rapport where the data is grouped by the vendorname. under each vendorname the models is listet, and i need a field where the number of models under each vendor i counted. Thanks

• 1 reply
• 746 views

-Queue-

January 10, 200521 yr

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

• 7 replies
• 849 views

-Queue-

January 10, 200521 yr

Question 1: I have a variety of Avery labels (they are at work and I'm not, so I don't have the numbers). None of them appear in the FileMaker label list. Most of them are not on 8.5 X 11 sheets but are on smaller sheets (like 4X6 or so). Is there a way to set this custom size? I can put the label size in the custom area but FileMaker will assume that they are on bigger sheets. Question 2: Most of the time I don't need a full (8.5 X 11) sheet of labels printed. In fact, I might only need 5-10 at a time. This seems like a very wasteful way to operate. How do I re-use the sheets and get the labels to print where there are still labels left on the sheet? (I know there …

• 2 replies
• 915 views

DeborahW

January 10, 200521 yr

Hi, I was wondering what the SOP on disabling the layout drop down list on the palette/navigation view of filemaker? I have many layouts right now, which are test layouts that I plan to delete, I really don't want people to go in there. Thre is an option which says "No access" in privledge set, but then they cant even get to the first layout. I know i can disable all the layouts - but i'm wondering (hoping) there is a better approach. I look forward to your input. thanks sincerely, J__

• 9 replies
• 1.1k views

J__

January 9, 200521 yr

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

• 6 replies
• 892 views

dailo

January 9, 200521 yr

Hello Together, contrary to check boxes where you can select more than one box I thought that radio buttons work in a way that you can only choose just one. I have added 3 radio buttons in my db and I can check all three of them, better: when I check them I can't turn them off anymore. Then what I did was write a script and create a button for it. I now used 3 check boxes instead of 3 radio buttons. I made the button invisible placed the button/script ontop of a check box. The effect was that my script did clear the other two boxes but I can't select the one I want. Is there a trick to it?? How can I use the radio buttons that if I selct one the other tw…

• 1 reply
• 733 views

RalphL

January 9, 200521 yr

I'm trying to create a simple list/report of certain names in my data base, but after doing a find and sorting the resulting list, I'd like the names on the list to be numbered. I can't use serial numbers because they're not sequential. Any thoughts???

• 1 reply
• 645 views

Ender

January 8, 200521 yr

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

• 9 replies
• 824 views

Ugo DI LUCA

January 7, 200521 yr

Dear FM People, I have a field which is defined by a value list with different abbreviations for locations in the US. Also I have created a calculation for this field which goes like =If(Tour Name = "Route_66" , "ORD" , If(Tour Name = "California_Dreaming" , "LAX" , 0)... Now I have one Tour Name which requires a manual input of the abbreviation because it varies. This input shall be selected from the value list. Problem: I can't choose from the value list and get a message "field cannot be modified". What can I do? Thanks, Andy

• 2 replies
• 760 views

***ANDY***

January 7, 200521 yr

I have a database with three related tables: assets, troubles, and changes. I would like to create a "summary" layout that will show me the 10 most recent records from each of the three tables so I can see, at a glance, the most recent entries into the database. Does anyone have an idea of the best way to go about this? Thanks for any help you can offer.

• 5 replies
• 847 views

spiggott

January 7, 200521 yr

Hello all, This is my first post here, so I apologize if this has been covered before. Also, pardon my terminology, I haven't done active FMP development for a few years. Being that I like to keep data links nice and arbitrary, I'm in the habit of using integer ID's (auto-generated serial numbers in FM) as primary and foreign keys. This is generally good DB design practice as far as I know, and I'm trying to do this in FM. However, this makes choosing a value from a related table (for example, Category) in a popup menu difficult. I want to insert the ID in the many table, not the name, but I want the name to be what the user sees and selects. What I'm do no…

• 2 replies
• 741 views

Quagmire

January 7, 200521 yr

This probally has been asked before, but how does one create an url link in FM Pro. This is for our internal FM Pro database (not online) so one can click on a link in the database browse mode and the IE browser will open up and go to the specified url.

• 2 replies
• 813 views

appleapple

January 7, 200521 yr

Hi all, I have what is probably a common question, but my searches in the forums yielded no results. I'm using FMP 7 (mac), and I have a pretty simple invoices table in my database. I also have several other tables in the same database, including labor line items ("li_labor"), taxable item line items ("li_item_tax"), and non-taxable line items ("li_item_no_tax"). Each of these three tables contains a different type of line item (i.e. different fields/descriptions in each table), which feeds into my invoices database, with the invoice number acting as the match field. As far as entering and organizing data, this structure works fine for me. The problem come…

• 1 reply
• 861 views

Ender

January 7, 200521 yr

I have a feeling this just ain't going to be possible, but you never know. I want to join 2 (or more) value lists together. In a typical situation I want to create a value list of Consultant IDs with "All Consultants" at the top, and preferable a divider. For example: All Consultants ------- REP001 Cameron REP004 Sandra REP005 Angelina The name is from a second field. I know of some very "unelegant" ways to achieve this, so currently I have to create custom lists (which need to be updated for rep changes) and then extract the RepID from that. Seems very amateurish. Any ideas? Any plug-ins? Thanks - Peter

• 2 replies
• 710 views

Brian C

January 7, 200521 yr

I am creating a page with a series of checklists of "to-do" tasks, i.e.: Opening Spread: x manuscript received x text poured x art received x art placed Lesson pages x design completed x design approved etc... The checklists are based on value lists for each field. I tried basing the value lists on related tables, but in the end I did it just using custom values so they can display in custom order. I would like the user be able to add checklist items. I can do this by setting up a separate popup menu that includes "edit..." which brings up a tidy little dialog box with the value list easily modifiable. But it's a little clunky to get to …

• 1 reply
• 1.9k views

Brian C

January 7, 200521 yr

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

• 6 replies
• 1.2k views

Ender

January 7, 200521 yr

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

• 10 replies
• 1.2k views

Ender

January 6, 200521 yr

Hi, I hope this is the right place to post, i didn't see a 'reports' forum. I'm wanting to have a reports_main layout, which displays a portral or list of script names in a table. I want to display a nice description of the report, then allow my user to click on the row. Once they click it i want to run a script, something like Launch_Report() and do a performScript on the field name in that row - and the contents of that field contain the script name which is in the current file. doesn't look like I can set PerformScript's parameter on the fly.... is this possible? Is there a design pattern for this kind of 'Report Main View' where your user can pick fr…

• 5 replies
• 954 views

Jodin

January 6, 200521 yr

Ok, this just might be a total noob question. What I'm trying to do is print the Layout view and showing all the fields and their labels. I'm used to FileMaker 3 on a Mac and now I'm using 7 on Windows. I seem to remember doing it, but just can't find the right buttons to press and online Help just didn't. I can print the layout with blank boxes or with underlines, but not with field labels.

• 2 replies
• 904 views

ayurgal

January 6, 200521 yr

I wrote earlier for help in finding out why my field borders around repeating fields disappear. I have worked with it long enough now to determine that the borders disappear when I use Sliding fields on the same layout. Does anyone know why this happens?

• 1 reply
• 708 views

transpower

January 6, 200521 yr

Hi, I'm having a problem getting text in some of my fields to properly center. for example, the text "My Enormously Big House" is displaying like this in my field: My Enormously Big House If I insert a line break between "Enormously" and "Big" it corrects itself, My Enormously Big House But I shouldn't have to do that, right? I don't have any leading or trailing spaces, not sure what's wrong. Thanks! Andrew

• 2 replies
• 721 views

picnichouse

January 6, 200521 yr

Hi Is there a way to let a user choose what he wants to see in a table and what not? (dynamicaly, not to create a layout for each possible set fo fields...) Is it possible in a portal? Is it possible to save these settings for each user? (including the order of the columns)

• 8 replies
• 1.2k views

xtrim

January 6, 200521 yr

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

• 1 reply
• 588 views

fbugeja

January 6, 200521 yr

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

• 12 replies
• 1.7k views

fbugeja

January 6, 200521 yr

I have one table which has: TableA: classID classSubTypeID Another (related table): TableB: classTypeID classSubTypeID I am creating a layout based on tableA. On that layout I'd like to place 3 separate checkboxes populated by a value list of classSubTypeID, where each set of checkboxes is for a different classTypeID. What is the simplest way to do this? thanks for any help.

• 20 replies
• 2.7k views

jjb

January 5, 200521 yr

I've just installed 7.0v3, and discovered that if you expand a part (header, body, footer, etc.) temporarily to work with something in the part, then try to reduce the part back to its original size, it makes the part one pixel larger than it originally was. The great majority of my layouts have objects that appear to continue across multiple parts. This new system creates a one-pixel-wide horizontal white line between parts, which obviously is a huge problem. Does anyone know if there is an easy way to get FM to act like it used to? If not, what other methods are there to solve the problem without going through a ton of laborious single-pixel moving of object…

• 5 replies
• 856 views

Peter1

January 5, 200521 yr

I have an inventory file that has multiple same part nos., the only difference is the serial nos. The pop up list only shows the first occurance of the part no. Is this a problem in FM7, or is this the way it works. TIA Ivan

• 2 replies
• 676 views

IEW

January 5, 200521 yr

Here's the problem: One table full of items, each assigned to a category. Another which has (20+) fields that get populated by items from the first table (via a value list). That is, each record has 20+ slots for these items. Each of these 20+ fields is paired individually with a category field. I'd like to use these category fields to limit the value list that appears in the popup menu for each of the 20+ item fields. So far, I can't figure out a way to use a second field (the value in the category field that corresponds to each of the 20+ fields) to limit a value list drawn from another table. If instead of 20+ fields (each with a different cat…

• 1 reply
• 769 views

Charles Henebry

January 4, 200521 yr

Is there anyway to create a grapg in a layout. I have created a report that shows sales by customer and I want to have it display as a graph. Anyone know if this is possible?

• 1 reply
• 702 views

Ender

January 3, 200521 yr

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

• 1 reply
• 589 views

Joseph31

January 3, 200521 yr

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

• 2 replies
• 740 views

J__

January 3, 200521 yr

Hi; Here is my problem: I have a text type field (It is used for description of a product and has a vertical scroll bar checked) that i would like my DB users to be able to read not edit. So i populated the field and selected vertical scroll bar (no entry allowed) and set the field borders. It looks great but the Vertical Scroll bar will not scroll. The only way I have been able to get the Vertical Scroll bar associated with this field to scroll is when i allow entry into this field (which i donot want to do for db users). Can someone explain this feature to me. I am relatively new at this, but I fear i am misunderstanding some fundamental fe…

• 3 replies
• 1k views

DMilbrath

January 3, 200521 yr

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

• 6 replies
• 909 views

Ender

January 2, 200521 yr

Hi all, my problem is when I have two records in the same numbering, how I calculation the pages number? like: number field(INV0001---2 records)Page 1 to 2 and Page 2 to 2. Thank for your reply.

• 2 replies
• 693 views

Questions King

January 2, 200521 yr

We need a FileMaker 7 plugin or another way of displaying the current window without scrollbars, and without FileMaker 7 zoom/mode/status area controls in the lower left corner.

• 3 replies
• 939 views

RalphL

January 1, 200521 yr

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

• 2 replies
• 743 views

rlbryant

January 1, 200521 yr

I'm trying to create a lengthy and complex report that combines research data from about 10 tables and places it into user-defined text templates stored in their own separate table. The report would look like the following (sans blue text): [color:"blue"] template text Category 1.0 [color:"blue"] research data Two boxes and three crates show damage. [color:"blue"] template text Category 2.0 [color:"blue"] research data One lamp was broken in box #44786 etc., etc., etc. My very general question is this - what would be the best approach to assembling/generating the reports? Via each child table that corresponds to the research data found in a…

• 3 replies
• 796 views

Kent Searight

December 31, 200421 yr

Hello Together, I just signed up in this forum, formerly working with EXCEL I'm new to FM and have following question: how can I define the sequence/order of fields? I have created several fields in my layout which basically looks like two colums. When I use the TAB key I'd first like the curser jump all the fields down in the left column (lets call it column A) and then all fields in the right column (let's call it :. What it does right now is I'm in field #1 column A, then pressing TAB it jumps to #1 column B, then #2 column A etc etc. How can I make it first go all the way down A and then B?? Thanks in advance, Andy

• 2 replies
• 789 views

***ANDY***

December 31, 200421 yr

Hello, I created a form to print labels but in order for it to print, when the Print Dialog appears I have to select "Filemaker Pro" from the pulldown that displays "Standards & Copies" and then I have to select "Records being browsed". A similar layout in Filemaker 5 prints just by clicking the Print icon or selecting Print from the File menu. Does anyone have any idea as to why these labels won't just print? Thanks, rlbryant

• 0 replies
• 670 views

rlbryant

December 31, 200421 yr

Anybody have any ideas on how to make a horizontal non printing navigation bar above a header/body on a layout. I want to put my record commands up there but I do not want it to print or affect spacing.

• 13 replies
• 1.4k views

RalphL

December 31, 200421 yr

Hopefully I am in the right forum. A simple, I'm sure relationship/layout problem: I want to print a repair report on equipment. One table has information on the equipment. The other has the information on the service work. There is a one (equipment) to many (service) relationship. I utilized a key field for equipment and one for service, so equipmentID in equipment table connects to equipmentID field in service. Layout is to be grouped by item name The layout is set up selecting :item name (from equipment table) date, problem, service company (all from Service table) The report will not show the related field "item name" Layout is base…

• 5 replies
• 956 views

-Queue-

December 30, 200421 yr

Hehe, Sorry everything is evil to me. I am asking if there is any pluggin to make the right and bottom scroll bars disappear. Also, make the zoom and toggle between modes to disappear. Any thoughts or suggestions ? Travis Ferreira

• 9 replies
• 2.1k views

savage

December 30, 200421 yr

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

• 10 replies
• 1.1k views

Heathbo

December 30, 200421 yr

Does anyone know if I can setup buttons to show a name when you mouse over them. In other applications if you mouse over a button it will tell you what it does. Thanks

• 2 replies
• 874 views

Chris Good

December 30, 200421 yr

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

• 7 replies
• 820 views

MrRage

December 29, 200421 yr

Hi, I have a tester who is testing a little program i wrote. She reported that she tabbed over to a popup menu, which normally drops down a list when you tab into it and today it didn't work. She tabs into the popup and no drop down appears. Has anyone seen a case where when you tabbed to the value list, the list did not drop down? I did discover that they are running Fm7 v1 but in the fix list, i didn't see this listed as a bug. they are also running from a server, the server is mac OS X fm7 Server. and her machine is a windowsXp. I cannot duplicate this problem... and now it has appeared to have gone away... weird. anyone ever seen this kind o…

• 2 replies
• 693 views

J__

December 29, 200421 yr

I can not remember how to set a checkbox value in a script. I need to be able to make a checkbox be (checked) within the script. Any ideas that can jog my memory would be much appreciated.

• 3 replies
• 681 views

Bell Boy

December 29, 200421 yr

Hi, Gang! I'm working on an address book layout that begins with an imported tab delimited file and creates a phone directory-type layout. I'm using the label feature and I'm hung up on two problems: -when the name is too long, I want the phone number (the phone number resides to the right of the name on the first line of the label) to become the second line of the label and not line break in mid phone number. It seems that if I can define a non-breaking hyphen (similar to a non-breaking space) and use that in the phone number, that would work. I'm not sure if this is possible on the Mac FMP, however. -And how do I tell FMP to include the first record in th…

• 3 replies
• 886 views

-Queue-

December 29, 200421 yr

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

• 3 replies
• 1.3k views

dscottsw

December 28, 200421 yr

Hello All! This is my first post and I'm only a 4-week user of FM, so please be gentle with me... :-) My database is for Candle & Candle Accesssory order entry, with the need for (3) related cascading value lists. I have been playing with the popular sample solution "Boggle.fp7" ( http://www.fmforums.com/threads/download.php?Number=134828 ). The end result of the Boggle logic would give me what I need, however I'd like to maintain my main data table a tad differently. The Boggle product list has items related based on the <Belongs To> field. However, my product list is an import of an Excel spreadsheet that is updated every-so-of…

• 0 replies
• 742 views

Andrea S

December 28, 200421 yr

I am using a PC, Windows 2003, Filemaker 7. I have a report with two sub-summary parts , one for clients and another one for jobs. There is a body part that lists all the people that worked on that job. In the body part I have the persons name, how many hours that person worked , how many dolars the person gets per hour and the total that person should receive, that is multiplying the hours worked and the dolars per hour for each person. I would like to have a report with the totals for each client and the arithmetic mean. I managed to get the totals per client by creating a summary field with "total of" the dolar field and putting this field in the sub-summary pa…

• 0 replies
• 724 views

LVA

December 28, 200421 yr

I have a layout which really looks and works best in Table View, but it requires a Trailing Grand Summary Part with summary fields. I can only get it to print in the Footer which makes it appear on the first page, too. Is there some way to get the summary on the last page only? On the first page it is confusing because the Sum = more than the parts on the page.

• 2 replies
• 827 views

esegal

December 28, 200421 yr

I would like my users to populate estimate line items by marking checkboxes from a value list. The problem is the value list contains about 75 items. Is there an easy way to have the functionality of checkboxes but also the scroll bar functionality?

• 8 replies
• 1.2k views

John Novotny

December 28, 200421 yr

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

• 2 replies
• 751 views

jtice

December 28, 200421 yr

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

• 6 replies
• 791 views

Ender

December 28, 200421 yr

Is there any way to make a value list populated by the file system? i.e. to browse directories and select entries from them to be placed into fields. The equivalent in Visual Basic are the Drive, Directory and File list boxes. Any help would be much appreciated.

• 3 replies
• 794 views

QuinTech

December 27, 200421 yr

In the database ive created i set each button to change the mouse pointer to a finger when the user hovers over it, this is especially useful when i use fields to perform a script because it is not so obvious that they are buttons. Problem being that when i use developer to convert the database into a runtime solution this doesnt happen anymore, everything else seems to work ok, and its no big deal, but it would be nice if it still worked. Anyone got any ideas why or how i can stop it?

• 1 reply
• 766 views

Oldsneekers

December 26, 200421 yr

What is the correct placement of fields in portal lines to make embossed fields all appear next to eachother in browse mode? I have portals with multiple rows. My portal is without lines or color and not engraved or embossed but set to have scrol bar at right. The fields are placed one per portal row and are embossed. The problem is that I can't get the top and bottom field edges to line up against eachother. I've tried making each row 1,2, 3, 4 pixels lager then the field, and either the space between the fields is overlapping, too wide or there is a patter of good placement once every 3-4 rows . I've tried scootting the field up and down but without success. …

• 0 replies
• 753 views

Oldsneekers

December 26, 200421 yr

In FM7 when formatting a field for value list , when formatted as popup list the response is extremely slow but when formatted as a pop up menu the reponse is as fast a fm6. Why the slowdown... anything to do with the anti-aliasing.. Anyone else experiance this problem?? Stu FileMaker Version: 7 Platform: Windows XP

• 4 replies
• 1.1k views

PoweredbyFm7

December 26, 200421 yr

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

• 9 replies
• 797 views

-Queue-

December 26, 200421 yr

i was wondering if anyone knew how to make the layout part label (where it says 'header' or 'body' etc) to be vertical? the templates in fm7 have them going vertically, but when i create a new layout, they're horizontal and i can't seem to figure out how to change it. any help would be appreciated.

• 2 replies
• 968 views

shatterproof

December 25, 200421 yr

I am at a lost in how to even approach the solution to this issue: FMP 7 Mac OS X Have the following Fields in one table (Shift Table): Employee S1 (Employee that works 1st shift) Employee S2 (Employee that works 2nd shift) Employee S3 (Employee that works 3rd shift) Employee S4 (Employee that works 4th shift) ((Employee fields are populated via a Pop up list that uses values from a related table (Employee Table)). (The Employee field can be blank if day had less then 4 shifts) Balance 1 (1st Shift Employee balance (number)) Balance 2 (2nd Shift Employee balance (number)) Balance 3 (3rd Shift Employee balance (number)) Balance 4 (4th Sh…

• 2 replies
• 973 views

Ender

December 23, 200421 yr

Is it possible?

• 7 replies
• 2.2k views

bruceR

December 23, 200421 yr

Hello all, I was wondering how I can auto-select a checkbox upon new record creation, i.e., upon Create New Record, a particular checkbox is selected upon default. It seems simple, but I am unsure on how to do it. Thanks! Courtney

• 1 reply
• 736 views

-Queue-

December 22, 200421 yr

Hi All I have three layouts containing a Contract. First layout contains pages 1-6, second layout contains pages 7-11 and third layout contains page 12 Question: Can I create a field that will display page numbers between the three layouts. I need the layouts to print continuously without restarting page numbers. Can this be done? I want the field to display just the page number not "Page 1 of 12" Thanks in advance for any assistance! Sheryl

• 5 replies
• 926 views

-Queue-

December 22, 200421 yr

I know that the topic of dynamic value lists is a frequent one, but I haven't been able to find an answer to my specific situation: I have a table called "MainContactInfo" that contains names and contact information for individuals. Each individual can be assigned an employer that the user selects from a pop-up list via a value list generated from the contents of a field in a related "Employers" table. (The tables are related by a PersonID.) The "Employers" table in turn is related to an "Offices" table (by an EmployerID). Each record in the "Employers" table can have multiple offices. What I want to happen is for the user, while entering a record in the "MainCo…

• 3 replies
• 914 views

transpower

December 22, 200421 yr

Here is a simple question, but I'm stumped. I have a list of contract records on a summary page, each contract record has a value list check-box which indicates the contract has been signed. The value list has only one entry which is a space (" ") as I don't need the text, only the check box. So, on this summary page (list view) I have a trailing grand summary part of the total of contract amounts (contract_total), but want a total of only signed (contract_total_signed) contracts as well. How do I perform this calculation?

• 4 replies
• 908 views

esegal

December 22, 200421 yr