Jump to content

value list from an other table...


guappo

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

Recommended Posts

  • Newbies

Sorry to ask for an apparently easy thing but ...

800 pda use about 20 different DC adapters. I want to add to the pda table a list from the adapters table from where to select the appropriate adapter. But I dont know how to create the relationship - there isn't really a realtionship..I would like just display the total value list from where to select... so I'm forced to create a relationship ...but I can't get through..I either get an empty list or a correct list but then when I select a value in the adapter list, all records in the pda table take that value.... I know Is stupid ..it was easy of FM 7 but here ... please help

Link to comment
Share on other sites

Each pda uses how many adapters?

If the answer is one, just have a field in the PDA table for Adapter and put that field on the PDA form layout. Double click the field and let it use a value list of Adapters. The right way is to store IDs not names. So, the value list is AdapterID and AdapterName. There is no relationship necessary.

If the answer is more than one, have a portal from the PDA table to a join table, "PDA_Adapters." This table has _kF_PDA_ID and _kF_Adapter_ID. Still can use your Adapter value list in the _kF_AdapterID field.

Link to comment
Share on other sites

This topic is 6104 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.