Dlookup

[deb]

access 2003
main form is f040ProjectMain (PK ProjectID)
t51KeyMilestones(PK KeyMilestonesID FK ProjectID)
t51KeyMilestones.ProjectID can have many KeyMilestoneSubID

I would like a textbox on my f040ProjectMain(form) to contain a dlookup of
the first record in t51KeyMilestones(table) where t51KeyMilestones ProjectID
= f040ProjectMain ProjectID and t51KeyMilestones KeyMilestoneSubID =12

 

[Jeanette Cunningham]

Hi deb,
build a query that returns the first record.
Include the fields ProjectID and KeyMilestoneSubID in the query, so you can
use them to check matching criteria.

How will you know which record is the first record - is it done by date for
example?

If it is date, you will need a totals query sorted by the date, then there
will be a way to detemine the first one.

Just for interest, what does the 51 mean in t51KeyMilestones?
I am working on a project management database at the moment - although it
sounds quite different from yours - built for a different purpose.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[deb]

I list my tables in order.
51 is Key milestones
52 may be key milestone details
53 may be a table used for a dropdown box
and so on, it keeps related tables together

 

[Jeanette Cunningham]

Interesting way to do it.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia