Newbies NotADBA Posted November 1, 2004 Newbies Posted November 1, 2004 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.
-Queue- Posted November 1, 2004 Posted November 1, 2004 Create a relationship from the Pairing field to the Type field and use the Go to Related Record [show only related, yourrelationship] script step.
Newbies NotADBA Posted November 2, 2004 Author Newbies Posted November 2, 2004 You, my friend, are a genius! Thank you- worked like a charm.
Recommended Posts
This topic is 7665 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