Hi Ross,
Many thanks for posting your comments below. May I have the demo as
I am sure that I could learn something from it.
Thanks in advance
Roger
On 23 Jan 2009, at 09:35, Ross Dickson 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
