multi relationship

[superlukeyboy]

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

[M.A]

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.