|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 11th, 2009, 09:29 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
How to Best Handle This
I need help in determing how best to set up part of my database. I want to
have a table of our mobile equipment. The key would be the asset#. I want a field for location. I want the location to be one of our valid location. How best do I handle this? I've read that lookup fields don't work well. Thank you. 
|
|
#2
February 11th, 2009, 11:12 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
How to Best Handle This
On Wed, 11 Feb 2009 13:29:01 -0800, stonelady
wrote: I need help in determing how best to set up part of my database. I want to have a table of our mobile equipment. The key would be the asset#. I want a field for location. I want the location to be one of our valid location. How best do I handle this? I've read that lookup fields don't work well. Thank you. You do want a lookup - but on a Form, not in your table. In fact you should never open a table datasheet except for debugging and development purposes. Base a Form on your Equipment table. Have a table of locations; put a Combo Box control on the form, based on the location table and bound to the location field in your Equipment table. It's not necessary to have a Lookup Field in the table to accomplish this; the Forms toolbox combo box tool will do it for you. -- John W. Vinson [MVP]
|
|
#3
February 12th, 2009, 02:49 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
How to Best Handle This
Thank you!
"John W. Vinson" wrote: On Wed, 11 Feb 2009 13:29:01 -0800, stonelady wrote: I need help in determing how best to set up part of my database. I want to have a table of our mobile equipment. The key would be the asset#. I want a field for location. I want the location to be one of our valid location. How best do I handle this? I've read that lookup fields don't work well. Thank you. You do want a lookup - but on a Form, not in your table. In fact you should never open a table datasheet except for debugging and development purposes. Base a Form on your Equipment table. Have a table of locations; put a Combo Box control on the form, based on the location table and bound to the location field in your Equipment table. It's not necessary to have a Lookup Field in the table to accomplish this; the Forms toolbox combo box tool will do it for you. -- John W. Vinson [MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
