Jump to content
Sign in to follow this  

Find in a related DB!!!!!

Recommended Posts


I try to make a search in my master DB, when I change in my Record with the "Next record arrow" find a record in the related DB just to show me 3 Fields in my master DB, these fields show me a calculation, for example:

If I have in my master DB in the field OT a record with 1 (this changes), so find all the records with 1 in my Related DB.

Thanks for your help


Share this post

Link to post
Share on other sites

If i understand correctly you need to display the related records then,first of all, you MUST have a living relation (based on the OT field) between the two dbs.

This accomplished. there are two ways to display related recs.:

  • Using a portal (based on this relation) in your master db

  • In the master db (in your GOTO NEXT script) include the statement 'GOTO RELATED RECORDS' checking the 'Related Only' checkbox.

    In this case you are switched to the related file (build there an apposite form-list) and you have the scope only to the fully related recs.

    Obviously have a navigation button in order to gain the ability to 'come home'.

And that's all.

Saludos y hasta luego !

[ July 14, 2001: Message edited by: JPaul ]

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.