Hoping that someone may be able to assist in this. If I need to have a paid membership to get the answer, open to that as well.
I have 2 tables: ProjectList and ProjectNotes. ProjectNumber is in both tables. There can be many ProjectNote records for each Projectlist record.
I am trying to create a form-Continuous, based on projectlist where next to each project it shows the latest (top 1) note entered. I tried creating a query that has both tables in it, relating projectnumber, setting the notedate field to descending and then setting the return to 1, but it only provides 1 projectlist record.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
