Jump to content

multi relationship


superlukeyboy
 Share

This topic is 6512 days old. Please don't post here. Open a new topic instead.

Recommended Posts

i have four databases at the moment, 'users', 'dvds', 'lists' and 'orders'. in 'orders' there is a field called 'amount paid' and a field called 'dvd chosen' where i will put the name of a dvd e.g pirates of the caribbean. the 'dvd chosen' field has a relationship going from it to the 'dvds' database where there will be a file with all the information on pirates of the caribbean including cost. can i make it so that in my 'amount paid' field in the 'orders' database, i can make it look at the 'dvd chosen' field, see that it is pirates of the caribbean then look in the 'dvds' database, look at the pirates of the caribbean info page, find the cost and then display it?

Version: v6.x

Platform: Mac OS X Jaguar

Link to comment
Share on other sites

Since you already have a relationship between dvds file and the orders file. Specify a lookup in the 'amount paid' file from the 'dvds' file. That should automatically populate it whenever you enter the name of the dvd. Ofcourse, the name of the dvd should match exactly.

Link to comment
Share on other sites

This topic is 6512 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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