Re: Option groups, passing a string value to table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 01/19/05 

Date: Wed, 19 Jan 2005 18:20:08 -0500

Sorry, but that is the recommended approach with Relational databases.

Certainly, having the words there doesn't improve maintenance: if you've
currently got A, B and C as your text, and decide you want Best, Better,
Good instead, all you have to do is change your lookup table, not every row
in your main table.

There's no difference in usability, either: as I said, you can create a
query and use the query rather than the table (seldom, if ever, should you
be working directly with the table anyhow)

I don't see how reliability enters into the equation.

However, in the end, it's your database. 

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Scott" <Scott@discussions.microsoft.com> wrote in message 
news:2745E51E-EF79-413F-97D4-6A01FB39517E@microsoft.com...
> This needs to be kept as simple for usability, reliability, maintenance 
> and,
> in this case, I don't see any benefit to using a table linked to another
> table.
> Scott
>
> "Douglas J. Steele" wrote:
>
>> Why? It's generally better to have numeric foreign keys in your table.
>>
>> Assuming you have a table that translates the numbers to their values, 
>> join
>> the two tables in a query and use the query wherever you would otherwise
>> have used the table.
>>
>> -- 
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>>
>> "Scott" <Scott@discussions.microsoft.com> wrote in message
>> news:18B6A5B1-51C9-4CD5-A811-3091359E2E1B@microsoft.com...
>> > Hi All,
>> >
>> > I have a form with a group of three option buttons. Everything is 
>> > working
>> > fine and "as expected" but I want to change the value inserted into the
>> > table. Currently, the option group places an integer value, 1 through 
>> > 3,
>> > in
>> > the table but I want to change the value to a string. For example, 
>> > instead
>> > of
>> > "1" I would like the string "State" placed into the table.
>> >
>> > Thanks,
>> > Scott
>> >
>>
>>
>>

Relevant Pages

  • Re: TclOO: Renaming "new" and "create" methods?
    ... organizations use relational databases is because of the ability to ... normalize data and to query the data, ... base objects. ... As long as you've got *some* control over the query, ...
    (comp.lang.tcl)
  • Re: Table of cells contains comingled text (A,B,C,1,2,3)-formated
    ... > Delimiter As String) As Long ... > Dim Items As Variant ... Each of these fields will look like this in the query ...
    (microsoft.public.access.gettingstarted)
  • Re: Equipment Maintenance Database
    ... comfortable with database design concepts, ... Specific type of equipment ... Specific Maintenance item ... > 2 - How can I write a query which will allow someone from management to ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Records wont show up
    ... Try losing the join between the subcomponents table and the components table ... I am trying to create a query that allows me to look up a maintenence ... record of a component and also a maintenance record of a sub-component at ... Categories to Products to Components which is linked to both the sub ...
    (microsoft.public.access.queries)
  • Re: date useage in vb expression
    ... > a WHERE clause rather than a named filter or query. ... >> End Sub ... >> Best regards ... >> Scott B ...
    (microsoft.public.access.formscoding)