Hiroshi

Thanks Jeff, Sorry if I wasn't clear in my initial posting. Yes, it does show up in preview "mode" as in command-U. The only reason I brought up the topic of the preview "button" in the print dialog -- the dialog that comes up upon pressing command-P -- was because this seemed to be related to the problem where this file would not print. Thanks again, Hipsig

Hi Matt, Thanks for your help. It works know. I'll keep a mental note of this so I don't mess up in the future. Hope you have a good week. Hiroshi

Hi tv_kid, Thanks for your offer. Here are the two files. You might see some garbled text (Japanese) in the interface and script comments, but otherwise I think it's pretty straightforward. Sorry if I'm missing something really basic here! Current file: Main PT Database Related file: Statuses Match field: PT_ID On the current file, the related fields are shown with red borders on the "Background layout" and "Main list" layouts. The relationship seems to be working fine. Value changes that I make on the current file are instantly reflected on the related file and vice versa. However, I am unable to perform a find (even "*" "!" or "=") on the related fields from the current file. The other relationships for this current file are also behaving the same. Thanks for your help. Hiroshi Main_PT_Database_Clone.fp7.zip Statuses_Clone.fp7.zip

Hello, I was wondering if someone could help me out with something that might be very elementary. I have a database of teachers each with unique IDs which I regularly delete and repopulate from data on our server. There are a couple of flags that I place on my end on FMP which I want to store on a related file with the IDs as the matching field. I pretty sure I've set up the relationship properly because I can click on the checkboxes on the main file and the related checkbox in the related file checks on. But, when I try to find records with the related checkbox checked "on" on the main file, I get a message telling me that "one or more of the relationships are invalid." What could this be? Thank you in advance for your help. Hiroshi PS I posted this earlier in the relationships forum, but perhaps it was off topic there.

Hello, I was wondering if someone could help me out with something that might be very elementary. I have a database of teachers each with unique IDs which I regularly delete and repopulate from data on our server. There are a couple of flags that I place on my end on FMP which I want to store on a related file with the IDs as the matching field. I pretty sure I've set up the relationship properly because I can click on the checkboxes on the main file and the related checkbox in the related file checks on. But, when I try to find records with the related checkbox checked "on" on the main file, I get a message telling me that "one or more of the relationships are invalid." What could this be? Thank you in advance for your help. Hiroshi

Hello, I was wondering if someone can help me with an import I do daily. I currently import records from a web page (that I've been given access to as a courtesy). What I've been doing is "Select All" on the web page and paste this into a text file which then turns into a tab-separated text file. All I had to do then was set the "First row is a header row" option and import using the "Update Matching (add new)" option. This has worked fine until the number of records started to grow. It seems to take almost a minute per 100 records (I use FMP8 on a 667MHz G4 PB). I don't have the "perform auto-enter options during import" option selected. I've turned indexing off for all of the fields I import to, but I do have calcs that are based on some of the imported fields. What I wanted ask are: a) How can I speed up the "update matching" import process? What is the best way to get the data from the web page without bothering the owner? Is there some kind of plug-in that I can use to make FMP go read the page? I have some scripting experience. Thank you in advance for your help. Cheers, Hiroshi