[AccessD] Lookup and production tables' alternative symbolickeys...

Hello Stuart,

Thank you for your sample: this looks for me more as "lookup up chain" - a
kind of 6 levels classification system for a Voter.

I obviously missed to mention such cases in my first posting.

IOW: Province->District-> Local Level Government
Area->Ward->Locality->Location is in my opinion a lookup tables' chain not a
master->detail->...->detail chain of production tables.

Of course all depends on point of view: I'd distinguish lookup and
production tables based on probability of how often their data is getting
changed...

BTW, do you have autonumber/identity keys for all your tables? do you also
have (alternative) symbolic keys for your tables?

Thank you.

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Saturday, May 12, 2007 2:14 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Lookup and production tables' alternative
symbolickeys...

On 12 May 2007 at 13:52, Shamil Salakhetdinov wrote:

> BTW, what was the longest master->detail->...->detail chain for a database
> you developed?
> 
> >From my experience an average value for the length of these chains is
2.5;
> if it's 3 then the third level table is usually a (many to many)
> relationship table; sometimes length of chains can be even 5 but I have
> never seen chains longer than five...
> 
> Do they exist?

I'm currently working on an Electoral roll which has a seven level chain:
Province
District
Local Level Government Area
Ward
Locality
Location
Voter



-- 
Stuart


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com