FileMaker General Discussions
Older discussion forums for previous versions of FileMaker
-
Hi Guys, I've got the following problem: When I make a new Record in my Related Layout "Invoices", it doesn't enter my ID in its ID-Field from the "Customer" Layout, so that it's related. How can I do such a thing? Thanks for you're reply! Ron
-
- 13 replies
- 1.5k views
-
-
I have two relational files, Tech Dept and Functions. A list of functions is created from within a portal in each Tech Dept record. This was working fine, now I'm finding that if I try to delete any record from Tech Dept, the whole thing hangs and I have to force quit FM. If I remove the relational requirment in Functions to delete related records when a TD record is deleted, things work fine. I can delete Function records either way without incident. This works the same on OSX and XP. To my horror, when I tired to compact or optimize Functions, it becomes damaged and cannot be opened. If I try to recover the file (before or after I crash it with compact or optimize), Fil…
-
- 3 replies
- 768 views
-
-
-
I have a summary field totaling up items from a portal. Is there any way to get the summary field to update automatically while editing?
-
- 4 replies
- 833 views
-
-
I have been trying to display the results (report) of a found set in Table 1 while using a layout and portal in Table 2. Using the same layout in Table 2, when displaying all records in Table 2 and all associated records from Table 1 (through a portal), I have no problem. Is there a way I can get the layout in Table 2 to recognize the Find that I did in Table 1? (and thus display a partial of the "all records in Table 2 with portal of all records in Table1"?) The tables are related by "id Rec". Table 1 is indexed on "id item" while Table 2 is indexed on "id Rec". (Table 2 "id Rec is one to Table 1 "id Rec" many). No matter what I have tried, I keep getting "all …
-
- 6 replies
- 882 views
-
-
Let me first say I don't use filemaker - I have just had a request from a user so have downloaded the trial version to see if this is possible. He has received a cd from a supplier and it contains a database.exe plus a couple of *.usr file and a load of dlls. The app was created using filemaker. On running the app, I can search and view a list of retailers plus their addresses. I can also print but no print to file option. My user wants to know if it is possible to export the address info into his own contact database. I have had a look at it and have tried importing the usr files into fm7 but am confronted with an insufficent access privilege message. Is th…
-
- 5 replies
- 853 views
-
-
Hi All, I had to switch out two pc's(Both Win XP Pro). Both PC's had FMP7 (Single User). I uninstalled FMP7 from both PC's (and restarted both) so I could reinstall with the correct user and license Key. I tried to reinstall FMP7 but keep getting the message that the license key is invalid and I know it's not. Any idea's?
-
- 1 reply
- 771 views
-
-
We are using Filemaker Pro server 3.0 with 3.0 runtime versions to access the server. It all worked fine up to Windows 2000 clients. We now have a Windows XP client and are no longer able to specify a host when opening a file (TCP/IP error message -10). The network preferences in the runtime client is correctly set to TCP/IP. Does anyone know this problem? Are the runtime and server version 3.0 now longer compatible with Windows XP?? Regards, Marc Smit
-
- 0 replies
- 973 views
-
-
Thanks for helping out.... I have a series of records, one of the fields being the date the record was entered. I would like to show fields from the previous record, or, the second to most recent record. So when I am looking at a record, I would like to see some data from a field from the last record entered, the second to last date. I have my layout currently set with a portal to show the field, but when I sort, I sort in a decending manner, and it shows me the information for the current record that I am in because that is the most recent field, so I am hoping that it is possible to sort decending in a portal, while skipping the most recent record and show the…
-
- 6 replies
- 798 views
-
-
Does anyone have any fm calander solutions that are free to download?
-
- 1 reply
- 719 views
-
-
Hi all, I have several databases hosted by FM7 Adv server with some global fields in. If I enter text into them, exit the client and reopen the database on the server the text has vanished. Any thoughts?
-
- 10 replies
- 1.3k views
-
-
My clients Filemaker 6 file takes a long time to open now. At least a full 60 seconds. It seems like it's frozen, but if you give it long enough to open, it eventually does. Could this be caused by too many related records? It doesn't seem like there is that much data in her db. She's only got about 500 records but each one has quite a few related records.
-
- 3 replies
- 1.1k views
-
-
I am fairly new to filemaker and I am building a cemetery database for our local geneaolgy department. We have taken pictures of all gravestones in our community and people can access our database online when researching there family history. However, no matter what size the original picture is, when it is viewed online it becomes stretched and skewed alomost like it is made to fit a default frame size. When the pictures are inserted into filemaker they look fine, they onlky appear stretched when viewed online. Can anyone help?
-
- 2 replies
- 796 views
-
-
I have an invoice that needs to be printed out. We have multiple copies that need to be printed out (customer, issuer, and filed copies). Is there an easy way to get 3 different pages to print out from 1 layout. Most of the layout will be the same with slight variations between some of the pages. I could put them on seperate layouts and have the script go to and print each one but I do need to have the print dialog box displayed so the user can select a printer. My concern is if I do it that way, then they will get a print dialog box for each layout being printed. Any one found a good way to get around this or have suggestions?
-
- 0 replies
- 1.2k views
-
-
I just got Using FileMaker 7. I haven't started using it yet, but I had to comment on its size. The thing is 5 inches by 9 inches, and 2 1/4 inches at the spine. Now THAT looks like a reference book! I got dictionaries smaller than that!
-
- 1 reply
- 746 views
-
-
Hi , i would like to show on the top of my screen the current user logged onto the database. Sort of like a Welcome Ivan. Please remember to log off. Does anyone knows how to do it? What field? Merge Field? Global? or Calc? Thank u thank u
-
- 5 replies
- 1.7k views
-
-
Hi Guys, I've got a small problem: Got a Global field giving me an Invoice Nr. now I would like to make it look better, instead of just "1" I would like it to be "0001", "0002"..."0010" etc. I've also got a Date conbined in it, like this: Right( "0000" & Year ( Get ( CurrentDate ) ) & Right ( Month ( Get ( CurrentDate ) ); 2 ); 4 ) & RGNr::RGNr & "-1" its the "RGNr::RGNr" wich is a global field to be formated. The example shown looks like this now: "04111-1" to be: "04110001-1 Is this possible in a calculation? Thanks!
-
- 1 reply
- 739 views
-
-
Hi, I have a script that exports records to a tab-separated textfile. each time when I export a file and the first action after exporting is the exit application function I get this error message ----------------------------------------------- Error in file "<unknown>" This file is damaged. Click continue to continue using this file, or click Exit to exit Filemaker. Consult the Filemaker manual for information on Recovery ----------------------------------------------- The weird thing is that I only get this error message when I exit after exporting the records, when exiting after any other function of my app. there is no problem. …
-
- 2 replies
- 847 views
-
-
I would like to know how I use a script to uncheck a checkbox. Its a simple value list that contains one value "ADD", when checked it allows that record to be viewed in a portal with others that were checked. I know how to write the script that runs through each record, but I don't know how to make it uncheck the checkbox when it finds one thats is checked. Help anyone?
-
- 4 replies
- 893 views
-
-
OK, I'm trying, but I don't get this context thing in relation to calculations. I guess really I don't get the whole relationship model in FM7. Here are my questions: If I have a field that calculates based on fields in the same record, then what's the context? What's the difference between a table and a table occurrence? Isn't a table occurrence exactly what it says, an occurrence of your table in the relationship graph? Then why do the table occurrences have names, each different from the name of the table itself? Aren't relationships between tables, not between table occurrences? If so, why do the table occurrences have names instead of the relationship…
-
- 5 replies
- 1.6k views
-
-
Is this a known bug with the "Go to Related Record" script step in FM 7? Every time I use the script step "Go to Related Record" it shows <unknown> for the layout.: Go to Related Record [ From table: "{Inventory}"; Using layout: <unknown> ] [ Show only related records; New window ] Even though I can set the layout in the "Show record using layout" menu of the script step. I click OK to dismiss the dialog box. It shows <unknown> for the layout, so I click OK and save the script and run it. The script runs fine it goes to the the correct layout. I come back to the script and it still shows <unknown> for the layout. I save all …
-
- 6 replies
- 1k views
-
-
Tonight, I began my first database in FM7. I had started this DB sometime ago in FM6, and thought I should start looking into 7. A few issues that I quickly became stumped by. 1: I wanted to import some sample data into my tables in order to see how it works. From File/Import/File, I could not get it to change what table I was importing to. I even created a new layout that only had fields from that particular table. I would not give any option to import from, except my main DB. I got around this by creating a script, however, I would like to know better how this works. 2: Creating a new record script step. How do I script which table I'm creating the …
-
- 7 replies
- 1.2k views
-
-
So I created a pretty cool object management system in FMP7 for PC's, but Mac's obviously can't view objects, or even insert objects. They can only insert files and then export the file out. Is there any way to open that file up with it's associate program, like word, excel, etc.? Double clicking doesn't work, you can't drag it to the program, it just doesn't seem to work unless you export the field contents out. Thanks!
-
- 1 reply
- 763 views
-
-
Could someone tell me why it might be that my sort script does not execute when it's in the startup script , but when I call the same exact script (after the startup script finishes), then it works perfectly ?
-
- 9 replies
- 1.4k views
-
-
I've seen posts posing questions about importing data from Quark XPress files into FM DBs and formatting text with QXP tags for export to Quark documents, but does anyone know if there is a plug-in for FM or Quark or some trick to export photos (say from FM's snazzy photo catalog template) directly to Quark documents? That is, the original record, not just the preview thumbnail. Man, a drag-and-drop that would direct QXP along the original file path would make life lovely.
-
- 2 replies
- 1.1k views
-
-
Hi, I am trying to make a cool looking splash screen. I have it working now but I don't like the way it looks. Is there a way I can make a layout without any borders, scroll bars, etc? I want it to look like the Filemaker 7 application splash. I tried to script it all... you know.. no scrolls, hide status, etc... but even when I do that it 'flashes' for a second (I guess before the script kicks in). I want to have a true splash, not a splash that looks like a normal layout that opens, then changes (via script.. no status, etc.). Can someone help me out?
-
- 2 replies
- 2.4k views
-
-
Hi, We have a filemaker server 5.5 network and filemaker unlimited connects to that to share certain files to the internet. 1) Is there a maximum number of files I can share out to the web using the web companion? 2) Is there a maximum number of files that a filemaker unlimited client can have open from filemaker server? 3) Is there a maximum number of files that a filemaker pro 5.5/6 client can have open from filemaker server? 4) Is there a maximum number of files that a filemaker unlimited client can have open from their local machine? Ie not files that are served up using filemaker server? As there are certain web-only files we have that aren't…
-
- 2 replies
- 1.2k views
-
-
I'm a newbie to Xserve. I just purchased a single processor Xserve G5 to run my Server 7. Can someone post detailed instruction on how to install and launch Filemaker Server 7 on a Xserve. This will be an internal server only, no need for web access etc. I purchased Apple Remote Desktop 2 and can not figure thi out either. I'm feeling pretty dumb right about now. Thanks!
-
- 1 reply
- 773 views
-
-
Is there a way I can disable hotkeys (ctrl-n)? I've searched but have not found anything yet.
-
- 3 replies
- 857 views
-
-
Greetings all I have this FM6 db that I inherited. On an inconsistant basis, when the db_Reg is opened, records are missing. Example - at the end of the work day I will have 150 records. The next morning there will be 52. I have not been able to replicate the problem. Running the recovery command in FP will recover the missing data. To give you all the complete pictures - here's the entire process: 1) Users enter information online. 2) Employee imports data from an xml sorce into the db_Pending 3) This employee (Emp1) checks for complete information, exports individual records to files, and sends them to email attachments to another employee (say, Emp2) 4…
-
- 6 replies
- 1.3k views
-
-
Hi, I have some issues regarding IWP. I have two files..a) a database file, and : a custom html file. I have set IWP option On for the database file. How do I tell IWP to display the customized html file? In version 6, in the Web Companion Configuration dialog box, in the Web Companion User Interface section, from the Home page drop-down list, i can select the custom html page. How do I do the same thing in Version7? Thanks Srilakshmi
-
- 1 reply
- 859 views
-
-
Help! While FM Pro is far superior in most respects, My associates are making fun of me because their ACT contact manager has time based pop up alarms. I would appreciate any suggestions as to a good free or commercially available solution which would work with an existing To Do file without re-entering the info twice. Regards, Dick Silva
-
- 1 reply
- 1.1k views
-
-
HI, Does FileMaker Pro v 7.0 support Web Styles (I am using Instant Web Publishing)? If so, how do I choose a web style? In 6.0, I could select a Web Style for my database clicking the Set View button and then selecting a style. I am unable to find the same in v7.0 Thanks Srilakshmi
-
- 0 replies
- 721 views
-
-
Hi all, Thanks for your help so far, I'm learning lots from the forums here. I'm not a total dunce but I'm finding I really have to dig to find FM's power. Here is another item I'm trying to wrap my head around. Is it possible to pass the criteria for a find script via the ScriptParameter? Dynamically? As an example from an earlier question ... if I want to find all the companies that start with "A" I do a find with ==A* then create and store a find/restore script. Seems silly to do this for every letter of the alphabet so I was trying to pass the letter via the ScriptParameter. But when I do this it tries to find the text "ScriptParameter". Not what I need…
-
- 3 replies
- 984 views
-
-
Hiya guys, Just a note to introduce myself to the group and to ask a question (first time I had to do that in a very, very long time ). I'm a FMP developer working and living in Sheffield, UK. I have been working with FMP since version 1 and kind of have a black-belt in the subject. I work primarily on the Mac OS X platform but am comfortable with anything with a keyboard My Question: I did something incredibly dumb recently and wrote a script which quits FMP if a condition is not met, then assigned it to be performed on opening the file via File Options There used to be a keyboard shortcut to bypass the startup script but I have tried just …
-
- 2 replies
- 2.2k views
-
-
We have FileMaker Pro 6 Unlimited. We would like to extend our web sites to be database driven, dynamic sites. I am trying to figure out the best way to do it. I used to use ColdFusion Studio as web development/programming tool to connect with SQL database and develop the sites. ColdFusion is pretty user firendly using plain English (programming per say). I am new to FileMaker. I wonder if there is any other programming tool that's similar to ColdFusion but for FileMaker Pro. Our current system -- operating: Win2000 server web hosting: external web site: static information pages (using FrontPage to update text) database: FileMaker Pro (main db), SQ…
-
- 2 replies
- 1.3k views
-
-
Hi, I have a database where we want users to select search criteria using checkboxes but to have those "checked" results displayed as a comma delimited string when browsing records. Seems to me that the older versions of FM used to store checked results as comma separated strings. Now that I'm using version 7 I see the checked results all show on a separate line in the field (When simply dragging the field to a new layout for browsing records). So the items are separated by vertical tabs. Am I crazy or did older versions use commas? Anyway, what to do ... Is there a setting somewhere for changing the delimiter between checked items? Or should I duplicate the fie…
-
- 3 replies
- 1.4k views
-
-
I highlight some text in a text field with scroll bars, apply a script to do things with that highlighted text and want to be able to return to that same location with that same text still highlighted after running that script. HELP !
-
- 3 replies
- 3.7k views
-
-
Hello You all. I am trying to find old (Claris) Filemaker 4 Developer software. (Windows) Does anybody have one to sell? Juha Kurikka juha@(remove)pd.fi
-
- 0 replies
- 1k views
-
-
I have a table with fields that have a yes or no entry. Can I create a new field and write a script that will count all the yes entries and all the no entries separately.
-
- 6 replies
- 1.7k views
-
-
I used to be able to click on a record in table view and go back to the full record in form view . However Filemaker 7 when i click on it, it becomes edit. How does one do it in Fm7 ?? Thanks for helping.
-
- 3 replies
- 704 views
-
-
I know in FM 7 you can manipulate text colour, font, etc. based on the value of the text (such as if status is Open, the text is green, if it is closed, the text is red). BUT, is there a way to manipulate the background colour of a text area the same way? Reason for my asking is that I have a button to submit a record. Over that button I have a text area with a transparent background showing the status (unsubmitted). I want to change the background colour of the text area to match the background of the record/layout when the record is submitted, so the button "disappears".
-
- 2 replies
- 764 views
-
-
I am working on a database to keep track of car maintenance for a fleet of 20 cars. If a car requires being towed in, I have to use a rotating list of three different wrecker services. Currently my dispatcher has to look on the current wrecker list to see which service was used last. Then he knows to use the next wrecker service on the list. Say I have three wrecker services, Service One, Service Two, and Service Three. I need to be able to create an unlimited number of records regarding car maintenance and if I need a wrecker for one of my cars, I want the dispatcher to be able to look at the screen and see the next service to be used automatically displayed.
-
- 3 replies
- 1.9k views
-
-
hey guys, this list of questions may seem daunting, but i have only 2 months experience with FMPro 7 and need some answers. here goes.... I believe i am accessing 20% of what FMpro7 has to offer me, i work for a professional/global photographer and we are using FMPro7 to catalogue his photos into some cohesive database. I have over 2000 photos as of today, but this number is going to exceed 10,000... There is an internet site for the artist, and at some point we'd like to integrate our database with the website for eventual sales of the photos......(That is some background) 1. Has FMP been adapted for website photo searches? 2. What databases are devoloped for museu…
-
- 2 replies
- 809 views
-
-
I installed Pro 7 on a PC, but when I try to connect to Pro 6 Mac server (we currently used), it always cause the server no response. No body else can connect to FileMaker server. What is the problem? Can FileMaker Pro PC work with FileMaker Pro Mac? And how to do it? Thanks.
-
- 1 reply
- 734 views
-
-
Hi, I have a database where the main page includes a portal of a sub-set of the fields in another table. What my boss wants to be able to do is click on that line in the portal and go to the full record in the other table. How can I do this?
-
- 2 replies
- 778 views
-
-
Hi, Does someone know if it is possible to create a script to force Filemaker to run in low priority (like putting the priority to "below normal" in the task manager) My application is doing statiscical calculations and can run up to 30 minutes before finishing. Filemaker uses 100% of the processor, so when I try to keep working in other progs. while the Filemaker is calculating I have to put Filemaker's priority to "below normal" manually each time.
-
- 4 replies
- 1.1k views
-
-
Hi all, I'm trying to create a clickable alphabet line such that clicking "A" will return all the company names that begin with "A", "B", "C" etc. What I can't figure out is how to perform such a search. According to the manual the =char* format does this but only for Japanese fields. Surely there is another way. Or do I have to develop my own function that loops through all records and flag the ones that begin with "A" using a text function, then perform a find on the flag? Thanks, RandyS
-
- 5 replies
- 2k views
-
-
Hi, I'm running a script in filemaker6 where I hide the performed actions with the freeze window command. I only refresh the window at certain points in the script. This works quite well, but each time the window is refreshed there is an annoying flicker. I noticed this gets worse when there are a lot of fields on screen. Does anyone know a solution to make the window refresh smoother ? Thanks,
-
- 5 replies
- 1.4k views
-
-
Hi All, I am working on new layouts and every now & then fields seem to vanish from them. As this happened to anyone else?? I am working on a layout that has a portal, but the vanishing fields are NOT on the portal (i would of explained that as a deleted relation). i was testing a suppliers value list & voila my sales tax field is gone from the layout. Any ideas?? Thanks --Dan
-
- 5 replies
- 736 views
-
-
In reference to the following solution given to me to help create totals of financial records for the previous week, month and year: --------------- Fields: Key_Week = Get( CurrentDate ) >= d_Date and Get( CurrentDate ) - 7 <= d_Date Key_Month = Get( CurrentDate ) >= d_Date and Date( Month( Get( CurrentDate ) ) - 1 ; Day( Get( CurrentDate ) ) ; Year( Get( CurrentDate ) ) ) <= d_Date Key_Year = Get( CurrentDate ) >= d_Date and Date( Month( Get( CurrentDate ) ) ; Day( Get( CurrentDate ) ) ; Year( Get( CurrentDate ) ) - 1 ) <= d_Date These calculations will return a boolean value to match a Key_1 constant field. Table Occuran…
-
- 1 reply
- 828 views
-
-
I am trying to create a Contact Management database that also contains a purchase history for each record. I used the Contact Management template and I eliminated the "similars" field. I want to keep a running spreadsheet on each customer in a more elegant way than just a text field. Any suggestions?
-
- 1 reply
- 659 views
-
-
To all you Filemaker experts. Here is a technical question that I have been wondering about. Explaination: I have two files. File1: has a field "graphic_og" which is a repeating global container field. It contains different graphics in each repetition of the field. File2: has an unstored calculation container field "status_ou". The calculation that is evalutated is: Case( blah = 1; GetRepetition(File1::graphic_og; 1); blahblah = 1; GetRepetition(File1::graphic_og; 2); blahblahblah = 1; GetRepetition(File1::graphic_og; 3); something = 1; GetRepetition(File1::graphic_og; 4); "") So I am displaying a different graphic, from the repetitio…
-
- 0 replies
- 815 views
-
-
Hi, I am a fairly new user coming from MS Access. In Access I have to have everyone log off and turn off the program in order to back up and / or make changes to the primary file. Is it the same with Filemaker? I will have a pretty large database at multiple sites (about 100 miles away). Will I have to have everyone log off to make mass changes to tables, layouts, etc. and to performa weekly back up? Thanks Vandy.
-
- 1 reply
- 799 views
-
-
Hi Guys, I'm trying to create a summary layout report with the attached file. The layout summary is on Layout#3. Want I would like to do is have the summary field count a total of all the yes checks and a total of all the no checks. Can I Do This, with a Check Set Field Please help, The Newbe
-
- 2 replies
- 847 views
-
-
I have a list of keywords. They are in a field with check boxes. An average record could have anywhere from 2-4 check boxes checked. What I'm trying to do is; if a certain keyword is selected(checked) I want to increase the value of a numeric field. This(below) doesn't seem to work. Case (Keywords = "Apples";+3) Since most records have multiple Keywords selected I need a way to increase or decrease the numeric value for each Keyword checked. What am I doing wrong? Any help you can give is much appreciated. Heathbo
-
- 1 reply
- 683 views
-
-
I'd like to know if there is a way to hide a certain field on a certain record from view on a report. (ie. create a "do not print this field on this record" button.) (not every occurrence of the field, just maybe on a handful of records)
-
- 1 reply
- 694 views
-
-
Essentially I have a calculation field with the calculation below on it. Def, Aver A1, and Aver A2 are all number fields with values in them. What I want to happen is when ((Def - Aver A1) + (Def - Aver A2)) / 2 = 3 I want the number 100 to show up in the field. Is there an easier way of doing this? Am I going about this all wrong? Case (((Def - Aver A1) + (Def - Aver A2)) / 2 = "3"; "100"; ((Def - Aver A1) + (Def - Aver A2)) / 2 = "4"; "99.54"; ((Def - Aver A1) + (Def - Aver A2)) / 2 = "5"; "98.15"; ((Def - Aver A1) + (Def - Aver A2)) / 2 = "6"; "95.37"; ((Def - Aver A1) + (Def - Aver A2)) / 2 = "7"; "90.74"; ((Def - Aver A1) + (Def …
-
- 3 replies
- 1.5k views
-
-
I'll try to make this short... I'm trying to make a mailing list database with FMP 7 where users on the internet or web can enter their name and email in a form and click submit to save the data to the FMP 7 database. Is it possible to make an HTML form that will do this - that when the person fills out the HTML form and clicks submit, the data is sent to the filemaker database sitting on another server at another IP address and saved? The other solution I've been trying to get work is the Instant Web Publishing feature to perhaps solve this problem. Well, I've set it up so I can access the database from the web, but I don't want users to be able to browse …
-
- 0 replies
- 839 views
-
-
-
I have several tables that I would like to copy into another file to create a new application. I cannot seem to find anything in the docs that address this. Anyone know how?
-
- 5 replies
- 1.2k views
-
-
Hi- Is there a way to "lock" a field so that it can't be edited without first performing an action (pressing a button/clicking checkbox). I want to be able to have users enter data into a field, then once it is in there, lock it so that it can't accidently be edited. If they want to edit it later, they would first have to push an "edit field" button or something similar. Can this be done? Thanks for any help, I value all the brains on this site! Dave
-
- 1 reply
- 820 views
-
-
I'm designing a database and am still slogging through understanding the new approach of FM7 tables. I've created a database with a second table with a group of fields, but have changed my mind and want to have the fields be a part of the main table. Can I move or copy the fields from the second table to the main table or do I have to recreate all the fields in the main table? Would sure save me some time!
-
- 3 replies
- 939 views
-
-
What is the meaning of the "text operator" that looks like a backward P ?
-
- 2 replies
- 873 views
-
-
I can see that I am just a rookie at this and most everyone on here are experts. I could use some help with a database I am working on. Here is what I am trying to do: One table has a client list, names, add, phone, etc etc second table has a product list, product, price third table is for invoicing, What I want to be able to do is to go into the invoice layout, pull up the clients name from a menu, and add if neccesary. Then in the product field the same thing. I do not want the user to have to know the ID number of the client or the ID of the product. I have these fields, but I don't see why I can't start typing in the field and let FM find it for me. I st…
-
- 83 replies
- 9.8k views
-
-
Hello All...... I am looking to take some training classes on FileMaker 7 before converting my solution to it. Does anyone have an opinion about Soliant Consulting out of Chicago? They offer the standard Professional Training Foundation Series. Any opinions? Thanks in advance! Donna
-
- 2 replies
- 762 views
-
-
Using FMPro 7.2, I need to create a table that will log in AND OUT all of my 38 users each time they access the database. My database has 9 tables with a main menu that directs my users to their area. I have created a table (tblLogFile) and fields LogID, User Name (calc - Get(Account Name)), LoginTimeStamp, LogIPAddress (calc - Get(SystemIPAddress), LogPrivileges (calc- Get(PrivilegeSetName), LogoffDate (date field), LogoffTime (time field) and LogoffTimestamp that puts the date and time in the logoff date and time field. A script to open a new record in tblLogFile works great and the user name and all information is generated like it should. My problem is t…
-
- 7 replies
- 1.1k views
-
-
Hello, After doing a find to reduce a database of several hundred items to 5 shown records, I would like to sort them in an order that is unrelated to any of their properties... just what I think looks good. How to do this? Andrew
-
- 2 replies
- 802 views
-
-
Hi, I have a database full of food products that we sell, prices and descriptions. We often need to create personalized menus for the restaurants to which we sell food. Right now I have a menu layout that works fine, the main problem is that it's kind of tedious to go through and omit each of the hundreds of products that aren't on the menu until I have only the ten or so that I want on the menu. I'd like to set up an easy kind of "find" where I'm presented with a checkbox for each product name, and then the database finds all the checked products. What's the easiest way to do this? Thanks! Andrew
-
- 1 reply
- 876 views
-
-
I am trying to create a database for signups in limited capacity activities; once the 25 seats are filled, the activity no longer appears as a choice. I understand that this is possible is FM7. Can it be done in FM5.5? If so, how? Thanks for your attention.
-
- 1 reply
- 868 views
-
-
I currently use my db to record responses from patients taking part in research projects. i often ask questions about medical history and patients can either tellme that they had a particular treatment either when they were X years old orthey may give the year of the treatment. i wantt o have two fielsd one iwth age and one with year so either piece of information can be enetered and the other one is auto calculated useing DOB. I can get it to calculate age from year, but then it wont allow me to overide it and enter a n age without the year...can anone help
-
- 1 reply
- 1k views
-
-
I have a self join setup that is of a parent-child relationship. With some of the records, there are multiple level parent-child relationships. What I'm trying to achieve is to get a list of parent-child-grandchild, etc. Using a portal I can achieve the first relationship but haven't been able to figure out a good way to get the entire tree of relationships. Eventually I will need to get a count based on a quanity field of the children and grandchildren but first things first. I used FileMaker fairly extensively with 5.5 but haven't in several years and am new to 7 so I haven't worked all the news features out yet.
-
- 1 reply
- 1.9k views
-
-
because i want to test a filemaker application tat is based on sharing files through my network i need two different license packages. well i do have filemkaer 5.5 developer for OS X. i also have a Filemaker 5 pro for classic. Now i want to upgrade this 5 pro for classic to 5.5 for OS X. I really have no idea if that would be a free upgrade. so what i wanted to do was to locate an upgrader form 5 to 5.5 or the 5.5 imstaller. My problem is that i can not find an upgrade installer nor the 5.5. my Q is can i upgrade my 5 pro for classic to 5.5 for OX. where can i find the installer ? Thanks Jitse
-
- 2 replies
- 909 views
-
-
I have a pricing model where 1 - 6 units cost $ XX, and then further units then cost $ YY. How can I split the value of the field OrderQty into two fields, BillUnits@XX and BillUnits@YY ? Obviously I need two calculations,one to return a value of 1 - 6, and the other to show the remaining quantity ordered (if any).... Help! Thanks in advance, Ben.
-
- 4 replies
- 952 views
-
-
I have a field that is a calculation with Average (Life) on it. The field "Life" is a field in 312 records with numbers from 4 to 32 in it. There maybe some records that don't have a number in the field. Because of that I have the "Do not evaluate if all referenced fields are empty" checked. It is also a global. My problem is its blank. No value shows up at all. Any thoughts? Heathbo
-
- 7 replies
- 1.2k views
-
-
I'm trying to teach myself about permissions/groups and I mistakenly set my file to auto-open with the guest account, and now I have no way to modify anything. Is there a way to re-login to the file or re-set the permissions? Right now I have no access to layout mode or script-maker. I scoured the online help, and came up with nothing. I tried saving a copy, but my copy did the same thing. HELP!
-
- 2 replies
- 961 views
-
-
Hi, Can we create groups in FM 7.0? If so, how do we create them in v7.0? Thanks Srilakshmi
-
- 1 reply
- 871 views
-
-
The solution i'm working on right now will have two main windows: A navigation window - this is not only the nav menu for the system, but also the nav / functionality window per each table. the data window. At any given time, other windows may be open as well, to view a quick list, select from a list, etc etc. I would like to include a button that goes back to the original state of the solution which is having only the main navigation window open on the system navigation layout. Potentially, there could be 5 or 6 windows open at any given time. I would hope not, but it would be possible. I was thinking i can use an unstored calc set to [windownames]. Fr…
-
- 1 reply
- 2.1k views
-
-
Hello, I am a new Filemaker Pro 7 user with the task of building a photography DB for my pathology department. I am having difficulty with the relationships portion. Ultimately in the final DB I want to select an item in a field by a pull down menu. Then depending upon my selection, this will give me one of several different pull down menus in the next field. IE: OrganSys = Female Genital, Then Tissue = Uterus Organ System = Cardiovascular, THen Tissue = Heart.
-
- 4 replies
- 791 views
-
-
Hi, I am using 6, but in the process of upgrading to 7 so If it is not possible in 6, then let me know about 7. I would like to be able to have a patient's last vitals show up. May sound simple, but I have tried a lot of things. Lets say that I have person a, b, and c. They are stored in "Main" database. Their vital signs are stored in vital signs database. The two are related by serial number. The vitals are shown through a portal and for a new visit, they just enter the vitals at the bottom of a portal. In a Visit database, which is related by serial number also from main, I would like to be able to look at say date 5/25/2004 and have the last vi…
-
- 6 replies
- 931 views
-
-
I've been running FM Pro 5 with no trouble until recently. we lost power while I was in one of my databases and now I get the following error when I do ANYTHING in FM. Instruction at 0x77805a10 reference memory at 0x00212000. Memory could not be "read". Click OK to terminate. I have reinstalled the program under several user configurations and the only one that runs is when I log into the computer as Administrator. Strange since I have administrator rights under all my id's. Other computers open the files just fine, so the problem isn't the database, it is specific to my computer. Any ideas? I'm normally a Mac user and I'm being forced to use this PC at wor…
-
- 8 replies
- 1.1k views
-
-
a user decided to copy a record and change a few things instead of creating a new record and retyping the info. now my "last name" field doesnt change with the records, and on other layouts calculated fields are showing #s where its supposed to be a calculation of first and last names. plus, on other layouts fields from the main db dont change with their related record...they all show the same data in the field, but if you check the original records they are mostly different. pretty much all hell broke lose with the copying of a record was selected....what should i do, other than shoot the user....i dont see what changed. please, give me any sort of advice! thanx trav…
-
- 9 replies
- 995 views
-
-
Has anyone else noticed a small circle appearing at the top left of the layout when you insert a GIF file onto the layout. The circle disappears when moving to a layout without the GIF or when you restart the solution!! Is there a fix for this?
-
- 1 reply
- 938 views
-
-
I have purchased filemaker and filemaker 7 server advanced, and after playing around with it a bit I was wondering if anyone had heard of it being used to create a sort of CRM of sorts, I haven't gone to much indepth development on it yet but from what im thinking I could catal. all of my clients and my other partner could log into the db from the field thru a browser and pull up any info that would be pertaining to the clients at hand and also relay info back via the db. Any thoughts or suggestions would be helpful as to a possible yay or nay on my thinking here. Thanks.
-
- 7 replies
- 1.6k views
-
-
a beginner's question? what are good methods to force a ###-##-#### for SSN and ###-###-#### for phone numbers on layout display i'm sure you all have a bunch of answers, but i am a beginner, forgive me i thank you in advance
-
- 1 reply
- 1k views
-
-
In earlier versions of filemaker, you could only find by one field in a portal. In fm7, portals seem to be smarter and I have tested finds using multiple fields in a portal---it works correctly! Are there any gotchas to this new feature? I am still leary.
-
- 0 replies
- 676 views
-
-
I have some Dbs I've had on the web for a number of years. Completely stable under 4.1, not quite as good under 5.0 Unlimited. Just upgraded to 5.5v2 Web Companion 5.5 v4 on a dual CPU G4 running OS X 10.2.2. Some of the Dbs are local, some are opened from Server v5.5 also running on a dual G4 under OS X 10.2.2. Every few days FMU just unexpectedly quits. Just pops up a dialog box that says that, no other hints or anything else in any of the logs. Anyone have any hints?
-
- 65 replies
- 14.1k views
-
-
We are using 4.1 on 98 and it takes up to 10 mins to load. Now, before we upgraded PCs its was more like 1 min. We have also been told that we cannot upgrade our database to a new version. Any tips? =) THanks!
-
- 3 replies
- 1.2k views
-
-
I've been working on a db that has a file for client information, a file for job information for each client, and a file for the financial info for each client and/or job. On the financial file I want to show the total income from jobs for all and particular clients for the past week, month, year, and financial year to date. Each job has an automated date entered when the record is created. Does anyone have any models of counting back 7days? So far I've got it taking 7 away from the day of the date field. But if the day of the date is say "04", then the result is -3. In this case I have made it take the minus amount away from the total days in the current month, the…
-
- 3 replies
- 940 views
-
-
Is there any way of importing files from v5.5 to v6? I'v just upgraded to Mac OS X Panther, and while I can open files in v6 from v5.5, they don't look right. I would have to redo all the layouts to have them readable. I've looked through all the FAQs, etc.,but it seems that there is no information on converting files. Thanks!
-
- 7 replies
- 1.1k views
-
-
I'm having a strange problem with my opener files. For 95% of the users/computers it works fine. There is a seperate copy of the file on each desktop, it's not shared in any way. When some users open the file is gives them the following error: "FileMaker Pro: FileMaker Pro.exe - Application Error : The instruction at "0x77805a10" referenced memory at "0x0021f000". The memory could not be "read". Click on OK to terminate the program " It's not a faulty install of FM Pro because different users logged in under the same PC can use it fine. It's not a privelage issue because one of the Admins here is having problems with it on his machine. I have tried…
-
- 5 replies
- 1.6k views
-
-
Long time developer just about to move a product to version 7 and am not happy Jan. First problem... I have value list that are sorted via a secondary field, in V6 you could just type the first letter of the first field and it would jump to it. V7 uses the second field as the jump to . Understand?? any ideas please help Is this a known bug.
-
- 1 reply
- 752 views
-
-
I am using the design function Getnextserialvalue to place the next serial number from the field serial number in another field. The function is in a set field script step GetNextSerialValue ( Get ( FileName ) ; test::Serial No ). The field Serial no is an auto enter number. The script returns no value! Any ideas? Thanks in advance. Stephen.
-
- 6 replies
- 2.8k views
-
-
when a portal is related to the master record with the "allow creation..." relationship, as the user enters the portal, the cursor automatically goes to a new portal row, in a blank record. how do u get rid of that, and a new record can only be created and "seen" when "new record" command is executed?
-
- 2 replies
- 820 views
-
-
Hi, i want to write a small script that assigns Persons from a Table to different jobs of a task: E.G: Task "create design" Operator: ________ ASSIGN Assistent: ________ ASSIGN Therefor I wrote a small script of two Steps. In the first step is executed whan clicking on ASSIGN. I store the current layout, current record and current table as globals fields into another table. Then I change to a List-View of all persons with a "assign"-Button next to it. This button calls the second part of the script, which should set the appropriate person-field in the TASK-Record. (Set the current id to the field I script was called from.) The problem is th…
-
- 9 replies
- 1.8k views
-
-
I'm experienced with other flat-file databases but a rank novice with Filemaker. Iv'e dusted off my copy of FMv4.1 and I am trying to get to know FileMakers features by working with the sample files that are included with the program. Several of the example template files include a "container" field, and the context suggests they are designed to accept data entry in the form of a photograghic image file. Here's my problem: When I attempt to drag and drop a small jpeg image file from elsewhere on my system, I always get a pop-up window inviting me to "Record Sound" and I can go no further? Is this because of the way my program is set up -or is there a bug in my program?…
-
- 6 replies
- 1.5k views
-
-
I love the fact that FileMaker 7 allows for defining a field to Auto-enter by calculation and using that field in the calculation. I used to create two fields for every date field in my solution. One text field for the entry of the date without slashes like "01012004" and one calculation field whose result would return a formatted date like "1/1/2004". I thought I would be able to just define a date field(Date), tell it to auto-enter by calculation using: Date ( Left(Date;2); Middle(Date;3;2) ; Middle(Date;5;9999)) and be done with it. However, every time you enter a date like "01012004" into the date field, the invalid date dialog box comes up instead …
-
- 2 replies
- 871 views
-
-
Has anyone ever developed a MARC record decoder database? I found one possible solution at http://www.sumware.co.nz/athenaeum/marc.php but the download is not working. I would be HIGHLY interested if anyone knows of any developments.
-
- 0 replies
- 1.2k views
-
-
Hi! This is probably a very stupid question, but how can I Auto Enter a value in one record based on the value of a previous record. What I'm trying to do is produce a milage book, where the end milage on one record (Day) is the start milage on the next. Look Up's seem to only work with other tables and I'm less than useless with scripts.... Any suggestions would be greatly appreciated, Ben.
-
- 9 replies
- 4.5k views
-
-
I have just recently purchased Filemaker Server 7 to run on my companies network. I have about 15 workstations that are going to access the databases at a given time. My question is, does each workstation have to have Filemker Pro installed on them, or can I install the Filemaker Pro on the server only and have all the workstation access the datbases through that. Any help on this would be appreciated as I am looking to have this rectified by the middle of the week.
-
- 8 replies
- 960 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online