Hi Ross,
If you wouldn't mind, I would like to take a look at your demo.
Thanks very much.
Bruce Herbach
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
