kseidule

And here is what I see on Windows...

I thought for clarification, here is what I see on the Mac...

I have been playing around with different fonts in Mac OS X and Windows. I am currently using Verdana, which seems to look OK. The fonts on the Mac look great (because of the font smoothing) and when I run on Windows (remote desktop connection), it looks pretty jaggy. I get the same effect on my Mac IF I turn font smoothing OFF on the Mac. The point is, I know MANY of you have done both Mac and Windows versions and played the "what font should I use" game. Has anyone come up with a font compatible for both OS's that look good on both? Many Regards In Advance, Kevin

Maybe I don't understand completely, but wouldn't a lookup fit the bill? I know you can use a lookup field to fill in other fields (as in type in customer name and it fills in the address, etc.). You did say the user knows the ProjectName. Just a thought... Kevin

Holly Smokes! Thanks Chuck. That worked just beautifully! Many Regards, Kevin

I have a layout which shows a home arrived on a lot, and then a number of items in a portal that the user clicks on having completed. The following is a simplified example of a layout... Layout 1 Home: New Mercury Home Date Accepted: 12 Jan 2004 Done? Description --------------------------------- () Yes () No () N/A Damage noted () Yes () No () N/A Doors Locked () Yes () No () N/A Hitch Attached etc... The portal items table and the home table are associated with the field KEY. I also have another layout which just shows the homes from the home table, as in... Layout 2 Home: Date Accepted: New Mercury Home 12 Jan 2004 New Uranus Home 12 Feb 2004 New Pluto Home 12 Mar 2004 What I want to do on Layout 2 above is add a COMPLETED field which shows which homes have had their items list completed. An item list would be considered to be completed when ALL items in the associated portal done column (radio buttons) are either set to "Yes" or "N/A". In other words, there are no "No" items in the portal list DONE field. So the above list of homes would show as follows... Home: Date Accepted: Completed: New Mercury Home 12 Jan 2004 Y New Uranus Home 12 Feb 2004 N New Pluto Home 12 Mar 2004 Y Pseudo-code wise, I want to say "If the associated portal list for the home contains no items set to "No" then the list has been completed, so set the COMPLETED field to "Y". The tables are set up as follows... Table: t_Home_Arrival_Main Fields: KEY (Indexed, Auto-enter Serial) DESCRIPTION (Text, description of home) DATE_ACCEPTED (Date) Table: t_Home_Arrival_Items Fields: KEY DESCRIPTION (Text, description of task) DONE (Text, contains "Yes", "No, "N/A") I hope that is enough explanation. I know there is some self-join table relationship and calc field magic I need to do here, but I just can't figure the bloody thing out. Any help, as always, is greatly appreciated. Regards, Kevin

Basically, I have a layout that shows the portal of related records to the master record. I go to that layout, then using the goto first/next on the portal, I loop and concatenate the strings together, separating them with a <CR>. Then I go to the layout with the target portal I want to copy the records over to, create a new record, then using the portal row last, walk the string with the <CR>'s backwards and set the field in the portal to each string. Took some doing and debugging on my part to get it all to work right, but it works like a charm. Hope that helps. Kevin

OK, I actually figured this out. It was a bit obtuse, but I got it. Kevin

I would like to copy data from one table to another table. I have the following tables... t_Manage_Procedure_List ----------------------------------- KEY (auto) Name Description t_Manage_Procedure_Items ----------------------------------- KEY ( = t_Manage_Procedure_List KEY) Description t_Manage_Procedure_List = t_Manage_Procedure_Items (allow creation/deletion of records) t_User_Procedure_List ----------------------------------- KEY (auto) Name Description t_User_Procedure_Items ----------------------------------- KEY ( = t_User_Procedure_List KEY) Description t_User_Procedure_List = t_User_Procedure_Items (allow creation/deletion of records) Also, relation t_Manage_Procedure_List = t_User_Procedure_List In case you're wondering, the relation allows me to show the List and a portal of records (items). I want to create a script to do the following (psuedocode)... #1.) Create a new t_User_Procedure_List record. #2.) Copy t_Manage_Procedure_List's "Name" and "Description" fields to t_User_Procedure_List's. #3.) Copy all associated items from t_Manage_Procedure_Items (i.e. belonging to t_Manage_Procedure_List = KEY) to t_User_Procedure_Items now associated with the new record created in #1. Pictorially, here is what would happen... t_Manage_Procedure_List (shown in "Layout 1") ----------------------------------- KEY: 1 Name: Procedure 1 Description: Procedure 1 Description KEY: 33 Name: Procedure 33 Description: Procedure 33 Description KEY: 123 Name: Procedure 123 Description: Procedure 123 Description (etc.) t_Manage_Procedure_Items ----------------------------------- KEY: 1 Description: Item 1 Description for Procedure 1 KEY: 1 Description: Item 2 Description for Procedure 1 KEY: 1 Description: Item 3 Description for Procedure 1 KEY: 33 Description: Item 1 Description for Procedure 33 KEY: 33 Description: Item 2 Description for Procedure 33 KEY: 123 Description: Item 1 Description for Procedure 123 (etc.) So, the user clicks on Procedure 1 from Layout 1...now I want to copy all the associated data for Procedure 1 to a new t_User_Procedure_List record and show it in Layout 2, which might end up looking like this... t_User_Procedure_List (shown in "Layout 2") ----------------------------------- KEY: 188 Name: Procedure 1 Description: Procedure 1 Description t_User_Procedure_Items (Shown in portal on "Layout 2") ----------------------------------- KEY: 188 Description: Item 1 Description for Procedure 1 KEY: 188 Description: Item 2 Description for Procedure 1 KEY: 188 Description: Item 3 Description for Procedure 1 NOTE: I have access to the t_Manage_Procedure_List from "Layout 1". The t_User_Procedure_List would be shown in "Layout 2". Any idea how one might script this?? Many, many thanks for any ideas or solution for this. Many regards, Kevin

OK, I am officially dufus boy. The layout I was going from wasn't even related to anything, so how the heck can you go to a related record! DUH! Thanks for all you help (and advices) on this. Many Regards, Kevin

No, the layout I am currently on shows the records from "BLAH" table. So If I create the button "Yours" and have it show related records from "PROCEDURES 2" shown using the Layout "Yours", there are no related records to the "BLAH" table. Hence nothing happens even though I know they are there and were created. I obviously still don't get it, although thanks for the above handling when there are no related records. Kevin

I did the above, but no go. I think the problem is that there is no related record at this point. I just have a layout showing a bunch of other records from something else, but when I click on the tab now set as Goto Related Record I don't think there is a related record. Yes, it is quite possible I am being a dufus. Thanks again, Kevin

OK, I jumped the gun. Let me further explain since I must still be doing something dumb-headed, ------------------------ Table: PROCEDURES Field 1: PROCEDURE_NAME (Text) Field 2: PROCEDURE_DESC (Text) Field 3: PROCEDURE_USER (Text - automatic Account Name entered) Field 4: PROCEDURE_CURR_USER (Calc - unstored - Get(AccountName)) Table: PROCEDURES 2 (COPY OF PROCEDURES) Relation: PROCEDURE_USER = PROCEDURE_CURR_USER Field 1: PROCEDURE_NAME Field 2: PROCEDURE_DESC Field 3: PROCEDURE_USER Field 4: PROCEDURE_CURR_USER ------------------------- Now I have two "tabs". One is a layout called "Yours" and another is a layout called "Everyones". These two different layouts each show a LIST of records. When I go to layout "Yours", I want the user to see JUST the records that match the current user (the logged in AccountName). When I go the "Everyone's" I want to show all records created (this already works like one would expect). Now, I ASSUME the layout "Yours" records are based on table "PROCEDURES 2" and the fields shown are also based on "PROCEDURES 2 ", and the layout "Everyone's" shows records based on table "PROCEDURES" and the fields shown are also based on "PROCEDURES". There is no Go To Related Record option, as I am displaying a list. I just Go to the layout. For instance, click on tab "Yours" and the list of records shown should be just the one's that match the current user. Is this clear? I hope so. Again, your help is appreciated. Kevin

Oh Man! Thanks Fenton! I almost got there. Had everything except the "Show only related". And as always, my grateful thanks to the experts here who take the time to answer these questions. This forum is what makes Filemaker "work". Kevin

Let's say I have the following... Table: PROCEDURES Field 1: PROCEDURE_NAME (Text) Field 2: PROCEDURE_DESC (Text) Field 3: PROCEDURE_USER (Text) When a record is created, the account name is automatically put in PROCEDURE_USER. So when I log in as "Admin" and create a record and I make... Field 1: "Procedure 1" Field 2: "Procedure 1 Description" Field 3: "Admin" (automatic) Now I log in as "Kevin" and create a new record... Field 1: "Procedure 2" Field 2: "Procedure 2 Description" Field 3: "Kevin" (automatic) Now I log in as "Joe" and create a new record... Field 1: "Procedure 3" Field 2: "Procedure 3 Description" Field 3: "Joe" (automatic) Now I see a list of records... RECORD 1: "Procedure 1" "Procedure 1 Description" "Admin" RECORD 2: "Procedure 2" "Procedure 2 Description" "Kevin" RECORD 3: "Procedure 3" "Procedure 3 Description" "Joe" Now I want to do the following. 1.) Be able to show all records to the logged in user. Easy as it already does this. RECORD 1: "Procedure 1" "Procedure 1 Description" "Admin" RECORD 2: "Procedure 2" "Procedure 2 Description" "Kevin" RECORD 3: "Procedure 3" "Procedure 3 Description" "Joe" 2.) Show ONLY those records belonging to the logged in user (will be in a different layout). If logged in as "Admin", I want to ONLY see... RECORD 1: "Procedure 1" "Procedure 1 Description" "Admin" ...as "Kevin" ONLY see... RECORD 2: "Procedure 2" "Procedure 2 Description" "Kevin" ...as "Joe" ONLY see... RECORD 3: "Procedure 3" "Procedure 3 Description" "Joe" I know I need to make a copy of the table with a relationship, but I can't seem to get it to do anything except show ALL records for all users and can't figure out this relationship. Apologize for the "newbie-ness" of this question. Thanks very much in advance. Kevin