Newbies guappo Posted October 4, 2007 Newbies Share Posted October 4, 2007 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 More sharing options...
bcooney Posted October 5, 2007 Share Posted October 5, 2007 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 More sharing options...
Recommended Posts
This topic is 6140 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