RE: Combo Box

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Brook (Brook_at_discussions.microsoft.com)
Date: 01/06/05 

Date: Thu, 6 Jan 2005 11:19:02 -0800

Why would I not want to store data from another table? It would give me
details on my product?

What I have is a table that houses my inventory, and I want to create a
lookup/dropdown for the Quality, and with the quality is chosen with is
Numeric (I.E. 50, 60, 80 etc), the quality Name and Quality Abbreviation will
populate into my table, is this not possible?

Brook

"Sprinks" wrote:

> Hi, Brook.
>
> See above post to trashman. You don't WANT to store any field from another
> table other than the foreign key in 99.99% of cases--the main exception is
> time-based values that are expected to change, such as a UnitPrice in the
> Product table. The current value of it would need to be stored in the Orders
> table.
>
> Display other fields on your form either by basing your form on a query, and
> including the fields you'd like displayed, or through the Column property as
> described.
>
> Sprinks
>
> "Brook" wrote:
>
> > can I set up a lookup box in a table to populate other fields within that
> > table?
> >
> > Brook

Relevant Pages

  • Re: converting look-up fields
    ... The tables in a database are to store data and to maintain the data's ... They do not exist to display or directly enter data directly. ... have to check each place the name occurred and fix it. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Validation rule between 2 fields
    ... Tables store data, forms display it for add/edit. ... data) to add validation code. ... "Amir" wrote in message ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Capitalise first letter
    ... store data, Access forms display (and allow data entry). ... Jeff Boyce ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Count and display entries
    ... I know you do not store data in forms, and I know forms are used to display ... have the number of entries displayed on the form. ... individual entry, and display the number in the "Number of Entries" field. ...
    (microsoft.public.access.formscoding)
  • Re: calculating dates in records
    ... using an unbound control with the record source as a calculation. ... > yea i am using a form to display how many days are left until the next ... I'm imagining a query against the most recent row (requires ... Access tables store data, ...
    (microsoft.public.access.formscoding)