onno Posted November 28, 2001 Share Posted November 28, 2001 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 More sharing options...
Kurt Knippel Posted November 28, 2001 Share Posted November 28, 2001 You need a relationship based on FileB-ProdSerial to FileA-ProdSerial rather than by the ProdCategory relationship that you are using to generate the vaalue list. Link to comment Share on other sites More sharing options...
onno Posted December 3, 2001 Author Share Posted December 3, 2001 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 More sharing options...
Recommended Posts
This topic is 8201 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 accountSign in
Already have an account? Sign in here.
Sign In Now