Getting Latest Status through Query

[pumpkinhead]

Hello Seniors,

Scenario:


Table A (Issues Table) : Contains all the issues with a unique number.
Table B (Issues Follow Up Table) : Contains heaps of Columns,10 follow ups record [each follow up phase have 8 columns].

Additional info: Table B, the follow up of all the issues (issues in table A) are on different follow ups, some at 1st, or 3rd or 8th or even 10th.

End result:
I want to generate a query that will present, all the Issues (I have already did it) along with the LATEST FOLLOWUP details.

Wondering if someone can guide me.
Appreciated, thanks.

[ranman256]

Table B is designed wrong. (Normalization)
You don't make 10 columns: ProbID,followup1, followup2,etc.
you create 2 columns: ProbID, followup.
now you can have infinite follow ups, and can query on 1 field, data entry on 1 field.
Access queries search vertically ,not horizontally across the record.

The way you have it will require a separate query for each followup field.

[orange]

I agree with ranman --the table design is a major concern. And it is a common problem with people new to database.
Normalize the table.
There are several articles/videos available via Google/Bing

Here is one that may be helpful.

Good luck.