AgentsSka Posted March 26, 2004 Share Posted March 26, 2004 I have not set up relational databases in FM before and am now trying to. I find the instructions less than helpful. So, I figured someone here has to have the answer I am looking for. I have a database (dataX) that simply has two fields: Team Name & Coaches Name. In a seperate database (dataY), I have created a dynamic value list of the "Team Names" from dataX. What i am trying to setup is the following. In dataY, when the Team Name is selected from the pull down menu, I want the Coaches field to be populated from the corresponding "Team Name" in dataX. Should be simple enough, but I have not yet been able to make this work... Any input would be very appreciated. Thanks, in advance! Version: v7.x Platform: Mac OS X Jaguar Link to comment Share on other sites More sharing options...
Ano Nimus Posted March 26, 2004 Share Posted March 26, 2004 You need to create a relationship between the two files, where dataY::Team Names = dataX::Team Names Then you make Coach Name (in dataY) a looked up value, over the relationship Team Names - Team Names. The value it looks up is Coaches Name in dataX. That should do the trick. (see attached) teamandcoach.zip Link to comment Share on other sites More sharing options...
AgentsSka Posted March 26, 2004 Author Share Posted March 26, 2004 See, I knew that was easy! Thanks for putting it into English, Ano Nimus. I am much abliged. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7336 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