Jump to content

Value list problem


onno

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

Recommended Posts

I have the following problem.

File A : ProductTypeCode / ProductSerial / Productdescription / Budget

File A has an internal relationship between ProductTypeCode and ProductSerial

File B has a ProductTypeCode field that is formatted as a value list.

When user chooses a certain ProductTypeCode, the value list of the ProductSerial field (also in File : only displays the ProductSerials related to the ProductTypeCode field. So far it works.

The problem is that in File B I would also like to display the corresponding ProdDescription and Budget fields.

When I place the related fields from file A on the layout in file B, they display the first value from file A, instead of the values that are in the corresponding ProductSerial record.

I hope I have made myself clear. I think this is a problem that occurs to many FM users.

Thanks for your help folks!

Link to comment
Share on other sites

I have tried, but it doesn't seem to work.

I have been looking if other FM users have had the same problem, and I have found one question that has remained unanswered (dated june 2001)

Here it is :

I have three fields:

product

supplier

order no.

The value list for the supplier field is a conditional value list. The condition is based on a relationship to a catalogue-of-goods-db. So it shows only those suppliers who actually sell the certain product. It works perfectly.

Now comes the problem: I want the order no. to be displayed of that certain supplier out of the catalogue-of-goods-db, too.

Whenever I have one and the same product, which is offered by two suppliers I want to choose between both. When I change the supplier, the order no. doesn't change.

End of quotation

I have already tried to create a find script in the related DB, so that the only report found is the one that contains the information that I want to see in the file. However, the related fields (::Serial and ::Budget) in the main file still display the values entered in the first record of the related DB.

I really don't understand this...

Link to comment
Share on other sites

This topic is 8265 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
×
×
  • Create New...

Important Information

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