SnipeD Posted February 15, 2001 Share Posted February 15, 2001 I don't quite understand it. But i 'll try to explain my problem different. I want to select a car brand in a list of values. Then I want to select a type of this brand car from a list of values. Only the types corresponding to this brand should be showed. In the database are several cars of the same type. In the value list i only want to show each type Once! Do you have an answer to this question? Thx in advance Link to comment Share on other sites More sharing options...
BobWeaver Posted February 16, 2001 Share Posted February 16, 2001 I think you can solve this the same way as the province/city problem. Here's more detail. Make up a related file called ModelInfo containing the car/model (or Province/city) info Fields like so: Make,Model ------------- Ford,Bronco Ford,Model T Ford,Fairlane Chevrolet,Impala Chevrolet,Lumina Chevrolet,Cavalier etc. Now, in your main database, set up a relationship from the Make in your main database to the Make field in the ModelInfo. Then when you go to select a value list, pick "Use values from field" and then in the next dialog that comes up: "Only related records" selecting the relationship that you just created from the popup menu. Finally, select the Model (or city) field. Link to comment Share on other sites More sharing options...
SnipeD Posted February 16, 2001 Author Share Posted February 16, 2001 I have tried your sollution but it wont work because i can't select "Only related records". There is not any option for that. I am using FM 4.1. Is this the problem? Can u help me find a sollution that works with this version? Thx in advance Link to comment Share on other sites More sharing options...
john.daly Posted February 16, 2001 Share Posted February 16, 2001 You're right!! You can't do this in FM4. You'll have to upgrade to FM5! Link to comment Share on other sites More sharing options...
BobWeaver Posted February 17, 2001 Share Posted February 17, 2001 Right. Sorry, I should have read your first post more carefully. I agree with John that the cleanest solution is to upgrade to FM5. A workaround is to use a portal instead of a value list. Use the same files and relationship as I described above. Use a normal value list to select the make, and then have a portal that displays the models. You can overlay a transparent button over the portal row that executes a script or a set field command to set the model field in your main file to the model value in the related record. Link to comment Share on other sites More sharing options...
SnipeD Posted February 19, 2001 Author Share Posted February 19, 2001 I have to talk to my boss about that upgrade!!! hehe.. Thanx for ur help u guys. Link to comment Share on other sites More sharing options...
Vaughan Posted February 19, 2001 Share Posted February 19, 2001 For a hierarchical menu solution, go to http://www.databasepros.com/ and look for their tip on "hierarchical menus." It's pretty complicated, involving scritped replaces and a whole heap of other stuff. Link to comment Share on other sites More sharing options...
SnipeD Posted February 20, 2001 Author Share Posted February 20, 2001 Thx I am back on the right track again!!! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8487 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