Jump to content
Sign in to follow this  
NotADBA

Passing Find Criteria between Databases

Recommended Posts

Hello. I have a question regarding a script/find that I think is most likely an easy thing to do, but yet I have not been able to find the solution;

I have two databases- one is a cookbook, the second a wine list. I have created a pull-down list in the cookbook for pairing suggestions, which pulls wine type from the "Type" field in my Wine Database. What I would like to be able to do is have a button in my cookbook which opens the Wine Database (I've gotten that far) and then uses the criteria from the "Pairing" field in the cookbook to do a search in the "Type" field in the Wine Database. So basically if I have the pairing as Pinot Grigio, and I click the [find] button, it will open my Wine Database and display all records for Pinot Grigio that I have in the database.

Is this possible? Any help would be appreciated. Thank you.

Share this post


Link to post
Share on other sites

Create a relationship from the Pairing field to the Type field and use the Go to Related Record [show only related, yourrelationship] script step.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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