Go to related record in another window fm6 vs. fm7

[audiojack]

With filemaker 6 I had a calendar file and a dates file. The calendar file had a script for a button that simply took you to the related date in the date file when you clicked on that date in the calendar file, using the go to related record statement. Since they were two different files they were two different windows and that was perfect as viewing both at once is prefered.

With filemaker 7 I have put the date and calendar files together as two seperate tables in one file. To get it to act as it did I have added "new window" commands to get to the calendar. But now I'm having trouble getting the button in the calendar to go to the related record in the dates table, and display that in the dates window. I've tried the select window command before the go to related record command but this doesn't seem to work as it just goes to the dates window and sits on the current record.

I could use a find after selecting the correct window but then only that record shows and I don't want to disturb the current found set, I just want to go to the record selected from the calander window. Maybe there is a better way to use find to do this?

Make sense? any sugestions?

[MoonShadow]

With FM7, everything you need is grouped for you. So, by Selecting 'Go To Related' ...

1) You specify which related table

2) You specify which layout to use (be sure Layout > Layout Setup shows records from your related table)

3) You specify your window control (new window), size and placement

4) You specify Show Only Related

If that isn't working for you then you may need to provide more information on your process and script.

[audiojack]

Thanks for the post, that all totally makes sense to me, the one difference in what I would like to do is not make a new window but specify another window that is already open. The 'go to related' command seems only to let you make a new window, but in my version the window that the file needs to switch to is already open. This worked well with fmp6 as the two tables were seperate files, and by going to the related record it would "automatically" go to the right window without making a new one (unless the window didn't exist)

I've tried putting 'select window' before and after the go to realated statment, and my script always goes to the correct window, but doesn't go to the related record, just sits on the record that was in the window in the first place.

I'm thinking I'm going to have to get into a bit more complex script that would perform a find, but if I do that I'm wondering what the best way to not change the current viewed set while finding that related records.

Any ideas would be greatly apreciated.

[MoonShadow]

the one difference in what I would like to do is not make a new window but specify another window that is already open.

Each window will maintain its value. If you bring up a date window with a found set and leave it open, then perform Go To Related on a different date but select this (already open) window, your original found set will remain. This is the power of opening multiple windows displaying multiple found sets (dates).

Go To Related [] can be used without a new window. It would simply switch from your Calendar window to your Dates window and display related there. If you don't want multiple Date windows open at one time, you will need to provide a Close on your Date windows for your Users, or teach them to close the prior one first. Why do you want to use a previous Date window? Actually, I've had 8 open windows at a time and have never noticed a problem with it.