Mailinglist Archive: opensuse-edu (59 mails)

["francis stanbridge" <fbs@xxxxxxxxxx>]

---- Original Message ----
From: thomas_adam16@xxxxxxxxx
To: johnsonmlw@xxxxxxxxx, suse-linux-uk-schools@xxxxxxxx
Subject: Re: [suse-linux-uk-schools] OOo20 database
Date: Mon, 28 Feb 2005 00:00:17 +0000 (GMT)


>> Forms: I haven't got it using a TableB as a lookup for
>> the list values in a combobox on FormA, where FormA
>> edits and adds to TableA (you know - that wizard you
>> run on Access to get combobox values from somewhere
>> else (a table) and bung an id rather than the list
>> value into the main table).
>
>A classic MS-Access ideal - and one that teaches so many how not to
>design
>forms and database backends.  I don't want to get into that argument,
>but
>as a toy database, this'll do just fine.  :P

Might you expand on the last statement a little - (not that I want to
defend Access) - am just interested how looking up values and
inserting the appropriate keys in related tables might not be good
design - I am starting here from the basis that entities are not
repeated in other tables.

Francis Stanbridge
Community College
Bishop's Castle
Shropshire
SY9 5AY

tel: 01588 638257
fax: 01588 630034