Re: [suse-linux-uk-schools] OOo20 database
---- Original Message ---- From: thomas_adam16@yahoo.com To: johnsonmlw@yahoo.com, suse-linux-uk-schools@suse.com 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
--- francis stanbridge <fbs@cocobc.org> wrote:
---- Original Message ---- From: thomas_adam16@yahoo.com To: johnsonmlw@yahoo.com, suse-linux-uk-schools@suse.com 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.
Indeed - I rarely use Access, but this is what I do in PHP/MySQL - i.e. get value/key pairs from a table: display the value in a dropdown menu and have it insert the key (id) into the main table. Cheers -- Matt Send instant messages to your online friends http://uk.messenger.yahoo.com
participants (2)
-
francis stanbridge -
Matt Johnson