Jump to content

Match Record From Another Field


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

Recommended Posts

Hello All.

Let Suppose

I created 2 Tables, named by Movies and Rental Repectively. And Suppose the Fields are for table Movie

Movie No.

Movie Genre.(Action, Romance & Adult In it)

Movie Name. (10 Movies belong to the genres mention above)

And Table Rental.

Rental No.

Movie Genre

Movie Name

So I want When i enter in RENTAL TABLE And Select Genre as Romance, And when i enter Next Field (Movie Name) Then It Show me Only the Names of that Movies that are Romance Genre, As well as I Select Genre as Action, And when i enter Next Field (Movie Name) Then It Show me Only the Names of that Movies that are Action Genre.

Tell me any tip about it

Very Very Thanks

Umar Farooq

Link to comment
Share on other sites

HI Umar

What you are looking for is called a conditional value list.

I have attached the same file as your last question but with an amended field to demonstrate the cond. value list in action.

If you go into find mode and click into the genre field you will see a list of all the genres that you have on file. Once you select one the list of movies available is restricted to that genre.

Have a look at the value lists used (File menu>define>value lists) and the extra table occurance (ctrl-D)

HTH

Phil.

Umars_sample.zip

Link to comment
Share on other sites

I am very Thankfull to u.

But I dont understand

how u mange it

How u store Genre & Movie Names In the Tables?

bcz in Video Table there is only one record

Plz Explain Some Qlues how u Make This one.

I am very thank full to u

Waiting ur reply.

Mian Umar

Link to comment
Share on other sites

This topic is 5780 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.