I have huge trouble understanding the part of value lists when it says 'use only related values starting from....'
I had tried putting in the 'higher' levels here, such as Temperature, Group, but realised from Ross's demo that I should be pointing it at the 'Products' level. I still don't understand why, but it sure works! Emma on 23/1/09 02:35, Ross Dickson at [email protected] wrote: > Hi Jason > > I didn't do much. It was clear that Emma was on the right track but had > somewhere along the line got her relationships a little confused. So, > rather than trying to diagnose the problem from afar, I just made a > little demo of the basic tables, fields and relationships that she > needed to create the value lists and data entry layouts. I hoped that > she would be able to compare what I suggested and what she had done to > find the discrepancy(s). Apparently, I was right. > > The main data entry table is Products, with fields, Temperature, Group, > SubRange, SkuRange and SKU. Each value list has its own table, with a > field for the value and another for the field it is contingent upon. So > the Groups table has two fields, Temperature and Group, the Subranges > table has, Group and Subranges, and SkuRanges has SubRange and SkuRange. > The Temperature table has just the field Temperature. > > There are relationships from Products to Temperatures, Groups and > Subranges based on the fields, Temperature, Group and SubRange > respectively. These are the basis for three conditional value lists > Groups, SubRanges and SkuRanges, using values from the appropriate field > and including only related values starting from Products. > > As well, four value lists are created Temperatures, AllGroups, > AllSubRanges and AllSkuRanges which contain all the entries in these > fields in the eponymous tables. The first is used in the Products table > as a radio button formatted field to facilitate data entry in > Temperature, the rest are used in the value list tables to ensure > consistent data entry there. > > The demo actually took less time to create than writing this note. If > anyone else would like to see it please ask. > > Ross > > Jason L DeLooze wrote: >> I wonder what Ross wrote - how he solved your problem. >> >> Jason >> >> >> On 1/22/09 at 2:51 PM +0000, Emma Glaisher wrote: >>> Thanks to Mr Ross Dickson, I think I have a solution. Similar to what I had, >>> but it has been built with clarity and understanding, both sadly lacking >>> from my attempts. >>> >>> Cheers all! >>> >>> I'm still going to explore the Excelisys system with its lovely PathIDs >>> which build themselves, because it's fun and may be useful another day! But >>> first to implement Ross's system. >>> >>> Emma >> > > - - > Inbound email: This email has been scanned for viruses by MessageLabs > (Fourninety) - - Fourninety Limited, a member company of the Media Square plc group. Registered in England No. 3737606. Registered address Clarence Mill, Clarence Road, Bollington, Cheshire. SK10 5JZ Confidentiality Notice: The information in this document and any attachments are confidential. It is intended only for the use of the named recipient. If you are not the intended recipient please notify us immediately and delete this document. The contents on this document must not be disclosed to any other person nor may any copies be taken. The views of the author may not represent the views of the Company. Security Warning: This e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. All liability for any claims arising as a result of using this medium to transmit information by us or to us is excluded to the extent permitted by law.
