That’s really useful vtxyzzy, and I agree. As it stands, WordPress just isn’t cut out for this sort of complex relational database stuff. Having said that, I wonder what plug-ins could be used to allow it to work.
Just interested to know of other people’s experiences and solutions.