DlookUp

[cap.zadi]

Hello there,

I am looking to operate DLookup function in my a form.

tblEmpInfo
EmpID PK
EmpName
PositionID FK (by query shows positionname)


SectionID FK (Same above)


tblSectionInfo
SectionID
SectionName

tblPositionInfo
PositionID
PositionName


So now i want to see a form where if i just enter EmpID so it should shows me the
EmpName, PositionName & SectionName

EmpName = DLookup("EmpName", "tblEmpInfo", "EmpID =" & EmpID)

It works also for PositionID & SectionID but i want to see the name of Position and Section not the ID as it is in EmpInfo tble.

plz advise.

thanks

zee

[June7]

Then do the DLookup on the SectionInfo and PositionInfo tables instead.

[cap.zadi]

Sir I try to upload the database but it cant bcz of its size.

[RuralGuy]

Sir I try to upload the database but it cant bcz of its size.

Did you do a Compact and Repair first and then ZIP up the db? We accept up to a 2MB file if zipped.

[cap.zadi]

Dear,

please lookinto the project. thanks

[June7]

See thread by same poster https://www.accessforums.net/forms/d...ion-17077.html which is essentially same topic.