Computing.Net > Forums > Office Software > MS Access - Dlookup works?

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

MS Access - Dlookup works?

Reply to Message Icon

Name: YEONG
Date: July 30, 2003 at 08:17:46 Pacific
OS: WindowsXP
CPU/Ram: 256
Comment:

I don't know how to elaborate my problem. But what i wanted to know is Eg, i got a master sales type table [ ID, orderTYPE , OrderNextNo] which is related to sale table [id, ordertype, orderno date] in a relationship of 1 to many.

SO, when i insert 2 fields (ordertype and orderno) from sale table into a form in which i would select the ordertype from the Sale Type table by using combo box and it will auto-show the orderNextno which is in sale type table. Do i need to Dlookup command for that?



Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: MS Access - Dlookup works?

MS access www.computing.net/answers/office/ms-access/3517.html

MS Access 2000 Recordset Issues www.computing.net/answers/office/ms-access-2000-recordset-issues/1360.html

Pictures & MS Access 2000 www.computing.net/answers/office/pictures-amp-ms-access-2000/1486.html