[AccessD] Lookup and production tables' alternative symbolic keys...

Stuart McLachlan stuart at lexacorp.com.pg
Sat May 12 05:13:56 CDT 2007


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





More information about the AccessD mailing list