jodibee

Hi, Having some trouble printing an image, all I get is a black box. On screen the image shows in both browse and preview mode, just doesn't print. Have tried as an inserted image on the layout and as a global container field but get the same output both ways. Any thoughts? Oh, it's a jpeg.

Hi all, Am trying to create records in a portal but have been encountering problems when trying to move off the layout that has the portal. I get the following error message: "pk.pt_id is defined to require a value, but it is not available on this layout. Use another layout to assign a value to this field" pk.pt_id is the primary key by which the two tables are related and the privileges are set to allow record creation etc. I am assuming that this is a relationship problem but could of course be wrong. Another user of the system (data-entry level user) then gets the option to revert or cancel, the only way she can get around the problem is to revert the changes and she loses all the records that she has just entered into the portal. Any thoughts anyone? Thanks in advance for the help.

Hi, I have table a, table b and a number of "other" tables. I want table a to relate to the "Other" tables based upon field a (common to both tables), I want table b also to relate to the "Other" tables but based on field b (also common to both tables but not table a). I have successfully created this relationship with one of the "Other" tables but when attempting to create the relationships with the remaining "Other" tables I receive the following message: "There cannot be more than one relational path between any two tables in the graph. Another occurrence of one of the tables must be added to the graph". Can anyone explain why this is the case and how I can structure the required relationships? Thanks

There is an example of this in the extras folder of your filemaker 7 directory, it is in the documents library file.

Hi, I have a pdf file in a container field (not just a file reference). Can I generate a script (maybe through a send event) to print the pdf file?

Hiya Wim, Thanks for the input. I was able to put together a satifactory solution with your suggestion. Jodi

Hi, Am using GTRR script step, open layout in new window. While my issue has probably been addressed previously, I can't put together an adequate solution. I want my new window to open smaller than and in front of the existing window and have the existing window remain maximised. Does anyone know an appropriate script to work around the problem? Thanks

Hi, I'll try to explain my problem though cannot guarantee a clear one. I have a layout on which users will enter results for a questionnaire using radio-buttons, there is a text description of the requirements for each button within the question field next to each field. There is however a more detailed description of the requirements to answer each item on the questionnaire. However, I only want to show the more detailed description if the user were to click a command button. I have the more detailed description for each question in a separate, related table. Upon clicking the command button I would like the following to happen: The primary layout for the questionnaire to stay as and where it is. A new, smaller window to open showing the question specific detailed description, ie. based upon the active field in the primary layout, go to the appropriate detailed description for that field/question item. I have had trouble working out an appropriate script. Please help. Thanks

Thanks Dan, that's exactly what I wanted.

Hi all, I would like to lock the header section of my layout and only have the body part scroll so that I may dispaly static information in the header section of a VERY long layout. Any tips on how to do this or create a similar effect? Thanks

Yes I am using four digit year dates, but it is more than possible, probably more probably than not that the dates were not converted correctly. The majority of them are invalid dates after completing the recommended find. The sometimes works thing implied that the formula works with valid dates but not with invalid dates, this I did not know until I realised that it was a problem with date validity. How do I go about converting them correctly?

I ended up using NumToText(Year(date_diagnosis) - Year(dob) - Case(date_diagnosis< Date(Month(dob), Day(dob), Year(date_diagnosis)), 1, 0)) This works fine if the date field is formatted correctly. The underlying problem that I have found, which has created the inconsistency, is that the "date" fields were originally defined as a text field. I converted them to date fields and the dates display properly, however, there is obviously some underlying problem in the date formatting that makes the calculation result come out as year of the date of birth instead of calculating the difference in years between the two dates. Do you have any ideas about how to change the date field definitions/formats to resolve this problem without having to manually re-enter all the dates?

Hi, Need help with an inconsistent calculation in Filemaker 5.5. I need to calculate age based upon the year difference between two dates. The calculation created before my time was Case(not IsEmpty(Date of Death) and not IsEmpty(Date of Birth), (Round((Date of Death - Date of Birth)/365.25,1)), "") This sometimes works, sometimes doesn't. Can someone please help me out with a nice, neat reproducable calculation? Thanks

Hi, I have an ongoing issue that I would like some advice upon. Firstly, I have nothing to do with the network administration that we run our Filemaker server on so have limited knowledge about our network. I think we are running FMP server 5.5 on a Win2k server, though is not exactly optimal due to its age and size. My databases are setup to run via TCP/IP in a multi-user hidden environment. When I am conducting design changes while at work, ie. I am on a LAN though the server is on a different network thus still accessed via TCP/IP, everything runs well. When I implement design changes from hom, ADSL type dial-up, by changes I mean creating new calculated fields for example, the connection with the host is lost nearly every single time...even though my internet connection is still active and working. This results in the file closing improperly and then cannot be accessed until my network administrators can make the time to go to the server and recover the affected file (this is a bonafide pain in the backside as we are grossly under-resourced and my network admin are very grouchy). What is likely to be the culprit? The server, the software, the network, my internet connection, me? I am going to be working almost exclusively in this mode for the next year and simply cannot afford the down time or stress levels that this repeated problem induces. Any thoughts or suggestions about how to fix this problem would be greatly appreciated. :)

Hi All, Is there any way to recover a damaged file remotely? I am not our server administrator and often work off site, often when I generate new fields or run scripts remotely, the server seems to freeze or my connection with it, this results in the file being closed down. The culprit file can then not be accessed unless I log a call with my IT support to go and restore the "damaged" file locally on the server. It's a real pain in the butt when my IT support takes several days or weeks to respond to a request...this of course results in some serious down time.