Relationship Newbie

[AgentsSka]

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

[Ano Nimus]

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

[AgentsSka]

See, I knew that was easy! Thanks for putting it into English, Ano Nimus.

I am much abliged.