MacDigger

Hi! I really need help on this issue.. Will try to explain the problem short and clear. I have a database of documents. Documents are organized into categories. Documents can be categorized by types (just normal text titles, like "Archive", "Accounting", etc). Any document can belong to multiple types at the same time. List of possible document types can be extended dynamically by a user. So, I have soemthing like that: Categories -> Document(s) -> Document type(s) What I need, is for any category, to be able to get list of types of documents which are located in this category. Well, if for any other problem I could at least think of a way to solve it, in this current case I can't think of anything that makes sense.. Well, I can store list of Types for each document in a text field, and during gathering stats operation just create a bigger global text field containing all the types values of all documents in current category. But in this case, how do I sort out distinct values? I'm confused.. Any advices are greatly appriceated! TIA, Mike. [ November 19, 2001: Message edited by: MacDigger ]

Oh! Thanks alot!! I think this solves my problem! Mike.

Hi! sorry for posting this here - I didn't find an adequate section for such kind of probs.. So, the problem is the following.. My database has 2 levels of access - guest and full. And there are fields on my layout which can contain lots of text, and therefore be scrollable. Scroll bar is functional when a field is editable (full access mode), but as soon as I turn the editable flag off (for guest mode), the field can't be scrolled anymore, so in guest mode the information is just cropped, and this is definitely not good.. I have my own access system, so per-field access feature of FileMaker can't be used in my case I'm afraid.. Anybody faced this problem? Please share any ideas how to fix it? All I can think of is to have global editable fields in guest mode, which duplicate contents of real non-editable fields from full access mode (so that even if guests make changes to these fields, they are not recorded). But that'll be MAJOR pain.. I'll be greateful for any suggestions! TIA, Mike [ November 08, 2001: Message edited by: MacDigger ]

Thanks for all the replies! Looks like I don' t have much choice I was trying to do most of the testing at home (where I only have 1 machine). And localhost testing looked fine for me. At least I was doing the same with many web-sites I have programmed for. But now at least I know that what I wanted to do it impossible, and this knowledge saved me lots of time and nerves Thanks all!

So, the only way to test client-server functionality is to setup 2 different machines, one running client, the other running server? Probably, there are some workarounds? It seems as a strange decision from FileMaker Inc..

Hi, I need to run FMP client and server on the same computer - to host files using FM Server and access them using FM Client (this is for testing purposes, to test functionality before deploying everything on a LAN). The problem is that FM client doesn't see files hosted on FM Server. At all.. I tried Local host, and Specified host (was using 127.0.0.1). No success. Honestly, I'm a bit puzzled, because I never had such problems on LANs.. Any help or advices are greatly appreciated! I use FM Client and Server 5.5 for Mac OS X. Thanks, Mike [ September 17, 2001: Message edited by: MacDigger ]

Oh my god!! It works! Thank alot! I never knew such an operation is possible with FM! Mucho gracias!

Hi! Here's the description: I have a library database, and I need to perform search on book titles. The problem is that some books contain articles inside themselves (implemented with related records). When a search is performed, I need to search for a "title" either in main book info, or inside articles which belong to that book. Currently, it is implemented so that user can either enter search string into "main title" field, or "related title" field in the search form. What I'm trying to do is to unify this search, so that in search form I have a single "title" field and the script would find books which either have corresponding "main" titles or "article" titles. Currently, I'm thinking about having the "main" title search string to be copied into "article" title field before the search is actually performed. BUT! In this case search is performed using logical "AND". Is there a way to make it use "OR"? I mean "search for books where (main_title="title" OR article_title="title")" Any suggestions are very welcomed!! TIA, Mike

quote: Originally posted by LiveOak: Buttons work in a portal in the header of a form view, but not a list view. Probably something about the context of which record the portal belongs to. If you need to show both records in a portal and a list view, you will probably have to use two portals, one to show records in the current file and another to show records in the related file. -bd Thanks alot! The portal is indeed in the header of list view layout. Sorry I didn't mention it.. So I'll just make 2 portals, with several external scripts each.. Not as elegant solution as the current one, but I guess I have no choice.. But oh well Thanks alot for help!!

quote: Originally posted by wirehaed: If you are trying to perform a script in the related file (the one you are viewing throught the portal) you have to execute an external script. you first have to create a script in the related file, than create a script in the paren file callin on the external script This should work, give it a try Thanks for reply, but the problem a bit different. The script attached to the button is indeed external, but the problem is that button just doesn't work. I'm talking not about script executed wrong - the problem is that button is not "pushable". When I try to push the buttom clicking the mouse on it, it doesn't push. Actually, it acts like no script is attached to it at all. So, that is the problem. Any ideas? TIA, Mike

There is a weird problem.. I have a portal, which I need to be located in the header part of my layout. Every portal line has a button with an attached script. These buttons are located inside the portal box. The problem is that these buttons don't work! When I click on a button, it doesn't activate. If I move the button outside the portal box, but leave it in the header part, it begins to work. Also, if I move the whole portal to the body part of layout, buttons start working too. So, the problem is clearly related to some "incompatibilities" between portals and the header part of layout.. I would appreciate any help on this issue!! Specifically - what is wrong with buttons, and portals in header part of layout? Is it fixable at all? TIA, Mike

Hi, I'm trying to implement an unlimited depth directory-tree structure in FM, and faced a pretty annoying problem: Directory structure is defined as: id - number parent_id - number dir_name - text there is also a relationship which links current directory with its parent directory: parent_id->id and a calculation field targeted to recursively construct full path: fullPath = id_to_parent_id_rel::fullPath & "/" & dir_name As a result I expect to get full path to a directory tree's "leaf", in the form of: "/Level1/Level2/Level3/..." logically, there shouldn't be any loops (of course, if dir structure is intact), but FileMaker tells me that this is a circular definition. Anyone have any idea how to solve this problem? Or probably this is a limitation of FileMaker which can not be got around? Any suggestions are welcome! TIA, Mike

I set 2 password to access a file. One for full access, and one for guest access, and in preferences I set the file to use guest access by default. But when I open that file, I get "Access denied" layout, and not way to enter admin password!!! =8-0 The "Change password" menu item is not active!! What do I do? Please help!

Here's a problem: I have 2 databases, one main, and other supporting database. Main database holds information on different "things", supporting database is supposed to hold history about each "thing" in main database. In a simplified way - supporting database contains fields: id, date, place (the meaning is where each "thing" with 'id' was at a 'date') What I need to do is, while browsing the main database, create a new record in supporting database with specified info (date, place), for selected "thing" with 'id'. I just started learning FM, so I'm a big curious if it is possible at all to do this kind of thing (I do believe it IS possible). So, any ideas or suggestions are greatly appreciated! Thanks in advance, Mike

Thanks alot!! I'll try this approach.