Access 97 - Combo Listboxes in Tables

  • Thread starter Thread starter Damaeus
  • Start date Start date
D

Damaeus

I've got two tables so far. One for categories and category types, and
then one with a product list.

In the product list table, I have a category field and I want to have a
listbox for categories come up as products are entered. For example, the
categories table may have:

blue
red
black
white

When I get to the related "category" field in the product list table, a
little "button" would pop up which could be clicked to select one of the
four colors listed above.

I know this can be done because I've loaded other Access databases and the
tables behave like that. I just can't figure out how it was done.

Also, I prefer entering data directly on the datasheet table, not the
forms. I really don't like forms that much at all.

Thanks,
Damaeus
 
Forms are far more robust and powerful than normal
tables.. BUT:

Use the lookup wizard in design view of the table. That
will get it to work the way that you want.



Chris Nebinger
 
Chris Nebinger said:
Forms are far more robust and powerful than normal
tables.. BUT:

Use the lookup wizard in design view of the table. That
will get it to work the way that you want.
Click to expand...

I believe "lookup fields" were not introduced in Access until Access 2000 --
I think they are not available in Access 97.

From the many, many questions in the newsgroup, they cause more problems
than they solve, by obscuring what is actually stored. They are also a
violation of proper relational database design. I do not use lookup fields
and do not recommend they be used.

Store the foreign key to the lookup _table_, and explicitly do the join in
queries. As far as I am concerned, lookup fields are useful only to the
end-user who enters and edits data directly in datasheet view.

Larry Linson
Microsoft Access MVP
 
Larry said:
I believe "lookup fields" were not introduced in Access until Access 2000 --
I think they are not available in Access 97.
Click to expand...

Nope, A97 also has 'em...more's the pity.

LeAnne
 
Back
Top