Tom England Posted January 2, 2002 Share Posted January 2, 2002 I have a client database with field ClientRef (unique). We have another field that directs users to other records. ie. Instead of having duplicate/similar details in 2 records it may say See ClientRef XYZ123. The only information that the 2nd field would hold is 'XYZ123'. Is it possible to create a script that would use the XYZ123 data, and go to that specific record? Hope that makes sense!! Link to comment Share on other sites More sharing options...
LiveOak Posted January 2, 2002 Share Posted January 2, 2002 There is a "Go to Related Record" scrpt step that can be used to move the the related records for a given record. You specify the relationship to use. -bd Link to comment Share on other sites More sharing options...
Tom England Posted January 4, 2002 Author Share Posted January 4, 2002 I don't really understand how to use this function. Can anyone explain?? Link to comment Share on other sites More sharing options...
Balder Posted January 4, 2002 Share Posted January 4, 2002 Tom, Before you can use the "Goto Related record" scriptstep, you have to create a relationship between your "second" field and another field (in another db or even in the same db. If you create a portal on the layout, showing the fields of the related record(s), you can directly show the related info. Check the manual on Portals. Regards, Erik Link to comment Share on other sites More sharing options...
Newbies Aglaysher Posted January 5, 2002 Newbies Share Posted January 5, 2002 Just a little add on to previous suggestions. You have two files that you created a relationship for using a common field. Maybe its Customer number. In your customer file you have a customer or record with a unique number (or Text or both) In your invoice file you have an invoice. One of the fields in your Invoice file should be Customer Number. Now you can link Customer file with invoice file by creating a relationship using the field Customer number. Next Step: Make a button on your layout. In your format button chose "goto related record". Bingo. Thats it. When you click the button in the Invoice file it will take you to that customers record in the customers file. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8145 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now