Dear members,<br><br>I've a small problem using MS access, <br>I've two table:<br><br>1° TABLE NAMED DOMAINNAME<br>FIELD NAME<br>id_dn<br>ext<br>ip<br><br>2° TABLE NAMED: TYPEDN<br><br>FIELD NAME<br>id_tdn<br>id_dn<br>date_last_modify<br>Info<br><br>In my form from typedn table i need to show a lookup to domainname table, when i put a id_dn code, show the ext and ip. <br><br>Noy sure how to develop a simply lookup, i've try to query but non work.<br><br>Please help me<br><br>Thank's<br>Paolo
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Lookup
- Thread starter poldo
- Start date
if you have a query that has both tables, and all the fields in showing in the query, all you should need to do is establish a link between the [id_dn] fields in each table.<br><br>do this by going into your query design mode, and simply clicking on [id_dn] in TypeDn table, and dragging over to [id_dn] in your domainname table. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
