whitemyer

This may be what quill is saying you can't do in 6, so it may not work. In 7, it seems to work for me. In the field phone, select validate by calculation as follows: If(Length ( Filter(Phone;"0123456789"))=10;1;0) Hope that helps.

I'm not positive whether or not this relates. My photo archives are divded into several categories - Client, Category, Subcategory, etc. And they have keywords associated with each image. When a client logs in, he sees only those images marked as belonging to his company. He can search by keyword (which searches the client, category, subcategory, title, document name and keywords field) or he can "browse". Browsing first brings up a list of all his categories, then when he clicks on a category, it brings up a list of subcategories within the category he selected. Clicking on a subcategory brings up all titles within that subcategory. I could think of several approaches using this type of system that would limit what the client sees, making it possible to publish the entire database while making it easy and fast to find the appropriate images. I'd be happy to e-mail a clone of my file to you if you'd like.

To change to a running total, go to Define Fields, find and select the summary field you're changing, click options and look for a checkbox for Running Total. (At least that's how you do it on a Mac) A running total will show up in each summary occurence, and it will always take the last total and add the amount from the summary in which it's displayed. If you're doing this with invoices, you would NOT want a running total, otherwise the running total would include previous invoices (assuming you're doing a subsummary for all invoices). Perhaps you could explain what, exactly, you're trying to show on your report or else post a clone of your database?

cbum, Could you simply display the data in a subsummary sorted by patient?

When you format for sliding, make sure you select "Reduce the size of the enclosing part"

Are you looking for running totals for your subsummaries? If so, make sure your summary field is a Running Total, otherwise, make sure it's not.

I use a method outlined in Filemaker Help. It's kind of hidden in the Help application, but if you go to Contents > Finding, sorting, and replacing data > Finding records > Finding duplicate values and look at the bottom of the page, you'll see a link for identifying duplicate values using a self-join relationship.

What is the relationship between the 2 tables?

I've found a (somewhat cumbersome) workaround for this. The script now copies the contents of Users::Company, enters find mode, pastes into Client, and performs the find. Then it copies the contents of Global Search, modifies the last find, pastes into Keyword Concatenate and performs the find again. Seems like there ought to be an easier way. If anyone knows of anything, please let me know. I'm probably going to end up using this functionality on several projects, so I wouldn't mind an easier, softer way. Thanks!

I've searched the forum and can't find an answer to my question. So hopefully someone out there can shed some light... In my photo archives database (published via IWP), I want my clients to be able to search their photos, but I don't ever want them to see other clients' photos. The "Home" layout is always viewed in Browse mode. The only visable field on it is a global field that is set to "" every time someone goes home. The idea is that the user enters the search term in this field, then clicks the Search button. This button is scripted to copy the contents of my global search field, enter find mode, paste into a Keyword Concatenate field (which is on the layout, but pretty well hidden from the users view), then insert the calculated value Users::Company (from the Users table, which is related if Get(AccountName)=Username) into the Client field (which is a text field in the current table and hidden away in my layout). Finally, the script performs the find, goes to another layout, sorts, etc. Where it appears to be hanging up is when I try to insert the caluclated value. It works in FM, but not in IWP. I've tried to find workarounds - dump Users::Company into a global field and insert from there, copy Users::Company and paste into Company, then insert the Global Search contents into the Keyword Concatenate field, etc. But it just seems that IWP doesn't want to insert any calculated result into a field in find mode. Anyone have any suggestions? PS - FM 7.0.3, Mac OS X 10.3.6 if it helps.

IWP limits you to 5 records on screen at a time in list view. I've seen posts that say viewing as a table will show more (20?), but I've not used them because I can't get them to work the way I want them to. I have the status bar locked off for web users and have buttons for Previous 5 and Next 5 on my list pages. The script for Previous basically says if the current record number>1, go to record by calculation current record number minus 5. For Next it says if Get(FoundCount)>Get(RecordNumber)+4, go to record by calculation Get(RecordNumber)+5.. Again, since I disable the status bar, I would use a Sort script. Keep in mind that when sorting (and doing lots of other script steps) the script will NOT be web compatible unless you have "Perform without dialog" checked. So YOU must specify the sort. You may need several buttons (ie: sort by Last Name, sort by Date, etc) Hope this helps.

Try putting the images in the Web folder that's located within the FileMaker application folder. I read somewhere that anything Filemaker shares over the web must be in this folder. It's inconvenient, but it's working for me.

Probably a bit late for this response, but try putting the images inside the "Web" folder that is located inside the Filemaker folder. All images that Filemaker IWP points to must be placed within this folder.