FileMaker Pro v7 – v11

I'm very concerned about how FileMaker 7.0v3 handles a go to related record command when there are no records in the child table which satisfy the conditions of the relation. (This is related to the changes which FileMaker made in how a constrain find works if there are no records found.) If I do a go to RR in a script, and there ARE records which satisfy the relation, the target layout becomes active, and the found set of related records are shown (I thought this was only supposed to happen with a specific show window command, so color me confused.) If I do a go to RR in a script, and there ARE NO records which satisfy the relation, NOTHING HAPPENS. Instead of …

Hello, I'm new here and fairly new to Filemaker. I'm stumped right now on what I assumed to be a very basic function (and I'm sure it is and I just don't know what I'm doing)! ;-) I have a database for a conference registration form. Outside of all the normal contact info, payment info, meals requested etc... there was a section where folks could sign up for workshops. There are 8 total workshop 'slots' over 3 days (workshop sessions A-F) and for each session time there are 8 possible workshops someone could attend. For each of these we've asked for their first, second and third choices (in case the room capacities get filled) which we will fill on a registrati…

Here's my problem of the week: I have a text field that the user typically pastes a block of text into, and I would like to reset the font/size of the text so that it shows up properly on different layouts. But Filemaker 7 now retains formatting information with the pasted text, so even though it should be displayed in Verdana 14 pt on one layout and Verdana 11 pt on a different layout, it now displays in the pasted font/size on both layouts. In Filemaker 6, this could be cured in a script using Set Field (field, field), but this trick no longer works. I can use an auto-enter calculation to reset the font/size, but this doesn't "get rid" of the formatting, and…

I have created an application which contains a portal on a particular screen. The portal contains a large number of records and it would be helpful to be able to search the portal to find a particular record, make some changes and then return to the original portal showing all of the data. Any suggestions as to how this could be done. Thanks in advance for any help.

I am making a cross platform Medical Scheduler. I did a cumborsome calendar in the older FM5 version of my DB. I am recoding the whole think in FM7. I was looking for a technique or a plug in that allows me to create a fast, easy, calendar that will work in Mac OS X and in Windows XP/2000. The calendar should be easy to include, have dates that I can click to jump to that date and the ability to color code days that I flag as OR Day, On Call day, Office Day etc... Thanks in advance for your advice...

My goal was to redo my solution with multi tables in one file. I created new tables in 7 with fields indentical to 6. converted each 6 file into a 7 one at a time then imported the records from the individual 7 tables into my multi table solution All of the tables imported except one table. The progress bar showed records were being imported. The dialog box says 32802 records imported, but when I go to the layout no records are there. I did this 3 times, once I created a new layout Same results. I did make sure the found set included all records. I am using 7.03

Cat -- I can assure you that setting a field to "" WILL uncheck the checkbox. It will be an empty field. You may be seeing (or not seeing) the portal not being refreshed. Try this: clear the field, then change into Preview mode, then back into browse mode to force the screen and portal to refresh completely. Make sure you are upgraded to FMP 7.0v3 as it has an option in the Refresh Window step to refresh relationships. -------------------- Vaughan Bromfield Sydney, Australia I am not looking at a portal, just straight records. And you're solution does not work. This is very frustrating to me coz it seems like such a simple thing. Is there …

Hi We have an extensive school based system with hundreds of scripts etc, however there seems to be one thing I cant do ( I wish it was only 1 ), - I want to use a button that when pressed will insert a number into a field - simple, but I want the count to increase by 1 each time the button is pressed. It must be easy but can someone help please Jim

Could someone tell me whether I can create an .ics file directly from Filemaker on a mac (I searched the the XSLT library and didn't see anything) ? OR ---- does someone know of an app out there that will allow me to create an .ics file directly from ical or using some other app (on a mac) ? (other than Outlook or Entourage hopefully!!!)

I am looking to create a script to enable the modification of any of 12 fields labeled category 1.....through category 12 on the same layout. Instead of creating 12 scripts I'm thinking that I should be able to use one script with a parameter that would define the specific field but can't figure it out. Is this possible?

Right now my application allows the user to perform a search on one window then show the results onto a new window. The problem that I am having is that when they keep the results window open and go back to the window where they perform the search and conduct a different search I can't get the new results to show in the existing results windo. The existing open results window always retains its current found set. Does anyone know how I might refresh the existing results window with the new found set. Thanks.

Hi, I want to create a patient report and have no idea how to do it. I've attached the file. There are 4 tables. Patient Chart, Encounters, Scans, and Medications. The ideal report would print the chart first, which is just one page of demographics. Then it would print the related encounters, but here's the tricky part. Each encounter may have a scan attached to it. They're related. This is nice because it's easier to just snap a picture of the injury then spend all night describing it. Anyways, the ideal report would print each encounter with all the related scans. Finally, it would spit out the related medications that I've given. I've broken the databas…

Is it possible to create a field in a Timecode format and calculate it? I want a user to enter in timecode in and out in this format ( 00:00:00:00 ) It has to calculate (hours:minutes:seconds:frames) and output the total to give the user the duration of the clip. I haven't been able to figure it out a formula or anything else to get this to calculate properly... Also, how would I create an Imput mask for this? Sorry, I am really new at this part of Filemaker.

Is is possible to create a scrolling area that would contain all of my fields? I have a simple db with about 35 fields that I would like to put in a smaller scrolling area so my record is not so long. Thanks!

Well here comes one that will test even JT and Fenton, The file is attached, and Admin, password = Admin will get you in. This file for some reason is not modifiable, at least that is what it says. I am logged in as Admin and yet it tells me to stick it. I can't even change my password. What's up with that? Is Filemaker trying to see if I will throw my computer? Alrighty then, here goes: The current database is set up for a hairstylist to be able to invoice and keep track of things. I have an items table, some products(taxable) and some services(non-taxable). I also have an inventory table, this was for the hairstylists own stuff, not stuff she would sell. (…

hi- I have an urgent need for some calculation help. I have a book title field in my records. I need to create a calulation field that removes all the spaces and puncuation in the titles and combines all the words. For instance, I have a title of: U.S. Communication services market : overview and future outlook. NEED CONVERTED TO: USCommunicationservicesmarketoverviewandfutureoutlook Is this possible? I need it to function the same no matter what the title or punctuation.

A trailing grand summary part will only appear in preview mode or when printed. Try using a Footer part instead. -bd

Can someone recommend a filemaker web host. thanks!

I have created an application in Filemaker. It uses one file and has several tables. In one place the user clicks a button which should open a small Window for new product information to be entered. When the window opens at the small size, the original layout in the background disappears completely and then when the small window is closed the original large layout appers in the small window. Any suggestions as to what I am doing wrong. To help another funny thing appears to happen when I first open the application. A small window appers very quickly and then goes and is replaced by the opening layout. The little one cannot be accesses or seen in any way and I h…

I have a FM7 server served solution that uses quite a few drop down lists that are derived from relationships.. but there's a problem....when connecting over our network, it takes a few seconds for the pop-up list to populate once clicked into.. Is there some way I can prepopulate the value list so that the user doesn't have to wait a few seconds after clicking into the field ? ANY advice would be greatly appreciated, because I'm finding my users click in, and then start typing something before it populates, and then end up with a bit of typed text that doesn't type-toward anything. A pop-up menu isn't really an option because you can't type-to your selec…

OK, so maybe I'm asking too much of Filemaker here but is it possible to have two text fields auto-fill a third field? I've got a database for the user community that I support and there user-name/authenticator is always going to be their first initial and their last name (i.e, David Jones - "djones".) Ao I have a last-name field, a first-name field, and a user-name field - is it possible to create a script or calculation to autofill the user-name field with just the first letter from the first name-field and the contents of the last-name field to auto-fill the user-name field? Thanks for any help...

I currently have a field which appears like a radio button yes/no format and have been useing a script which when the field is yes then it goes to a new layout or if no it fills in the no and lets you go on to the next field. I want to be able to adapt this so if the field is yes it goes to one layout and if no it goes to another. However the way i have it set up the field is blank to start with and when you first click on it , it will go to no then you click a second time it goes to yes...the problem is that when it first goes to no it follows the script and takes you to te no layout, so you have to then go back amnd click a second time...not very neat. the script…

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

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…

Hi all: I have a table,

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?

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 …

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…

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?

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…

Does anyone have any fm calander solutions that are free to download?

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?

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?

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?

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!

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

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!

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?

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…

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 …

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 …

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!

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 ?

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?

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!

Is there a way I can disable hotkeys (ctrl-n)? I've searched but have not found anything yet.

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

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

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…

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 …

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…

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 !

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.

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.

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".

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.

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…

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.

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?

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

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

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…

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?

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…

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.

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

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

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)

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 …

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 …

Good Point. I hadn't considered the NDA

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?

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

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!

What is the meaning of the "text operator" that looks like a backward P ?

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…

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

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…

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

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

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

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.

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.

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

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!

Hi, Can we create groups in FM 7.0? If so, how do we create them in v7.0? Thanks Srilakshmi

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…

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.

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…

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…

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?

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.

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

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.

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…

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.

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.

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?

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…

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 …