Tables

J

Jenn Connors

I have 2 tables that I have linked together. 1 table is hardware and the
other 1 is location. In the location table I have entered 10 different
locations. I would like to be able to to into the hardware table in the
location column and type the 1st few letters of the location and it will put
it in automatically. Can you please help me with this? I have already
created the relationship between the 2 tables.
 
J

John Vinson

I have 2 tables that I have linked together. 1 table is hardware and the
other 1 is location. In the location table I have entered 10 different
locations. I would like to be able to to into the hardware table in the
location column and type the 1st few letters of the location and it will put
it in automatically. Can you please help me with this? I have already
created the relationship between the 2 tables.
Click to expand...

Use a Form. Table datasheets have VERY limited capabilities; forms are
much more powerful.

Create a Form based on the Hardware table, using the forms wizard (you
can open the table in design view and click the AutoForm icon if you
wish).

Access will give you a Textbox for the location. Right mouseclick it
and select the option Change To Combo Box - or delete it, and use the
Toolbox combo box tool to create a Combo Box. If you do the latter,
and have the "magic wand" icon selected, Access will walk you through
creating a combo based on the Location table.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top