Lookup Fields

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

I committed the ultimate sin and used the lookup wizard.
I am sorry and want to antone - can someone point me to a
web adddress that walks me thru how to set it up properly.

Thanks.
 
I committed the ultimate sin and used the lookup wizard.
I am sorry and want to antone - can someone point me to a
web adddress that walks me thru how to set it up properly.

Thanks.
Click to expand...

Well, you don't really need much. Just open each Table which has
lookup fields; select each field in turn, and on the Lookup tab of the
field properties change the property to "Text Box" (instead of Combo).

Then open the Relationships window and click the "View All" button. If
there are duplicate table icons (with a _1 extension) they are
probably from the Wizard creating extra redundant relationships;
select the join line to these, click the Delete key, and then delete
the extra table icon.

You'll then be able to build forms as normal; you can use the Toolbox
Combo tool (with the magic wand icon selected) to put "lookups" on
your forms.

Ego absolvo te, filio! <g>

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Filtering a Lookup Wizard field in a tabular form through a button 3
Lookup Field Problem 2
Access 2007 Lookup Wizard Drop down Boxes 2
Lookup field 7
Lookup query allows me to retrieve up to two rows. 1
Access Command button to look up and copy data from a query to a table 0
Lookup field in table 4
The Lookup Wizard, Do I Hate It? 2

Back
Top