Please help! 'Go to related record' script issue.

[Jesse Stolow]

Hey everyone,

Sorry this is so long. I am a newbie and don't know how to explain it any better.

Essentially, the main table I created is used to create and print quotes for a potential client (before they become a real client and get assigned a Purchase Order number). When I create a new record in the Main layout for a quote, I am able to select a client from a drop down menu that is tied to the Client table (which holds all client info). The two tables are linked by the clients name.

I have also set up a third layout entitled Memo that is the printable layout for the quote. I created a script button on the Main layout to take me to the related record in the Memo layout and print the record. When I click the print button for a new client, the record prints the client name and the quote information on the Memo layout just fine. However, if the client's quote/record is for a client we have had in the computer before with a previous quote/record, the print script gets all screwy.

Instead, the Memo layout shows the original record for that client, not the new record that I want to print.

What am I doing wrong?

Thanks!

[aldipalo]

I can't be 100% positive without seeing the file, but, I have had a similar problem. I added "Go to Record Request Page [Last]" after my GTRR and that solved it for me. What may be happening is you are going to the First record rather than the most current entry.

Of course, I'm sure there is probably a more precise answer from those who have a lot more experience than I.

HTH