Match Record From Another Field

[Mian Umar]

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

[Inky Phil]

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

[Mian Umar]

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

[Inky Phil]

Have a look at 'Value lists' in the help files. That is how I got the information in there.

In the sample file select file menu> define> value lists and you will see there how they are formed

HTH

Phil