[Solved] SubForm Table - Show Only Unique Values

[jmadero]

Hi All,

Database: https://drive.google.com/open?id=1kCiKT ... PX4nMR3i4E

Steps:
(1) Open db;
(2) Go to "MyLibrary"
(3) Go to Record 285

Verify Title: Forward the Foundation

Observed:
On the right I have "Series by Author" and I really just want the name of each series in my Database by the same author. What I'm getting is a repeat of the series for each book in that series. Do I have to make a new query or is there a way for me to easily avoid the repeats and just show unique values.

Thanks

[UnklDonald418]

You need a different query for SubForm_SeriesByAuthor, something like:

Code: Select all

SELECT DISTINCT "BookTable"."SeriesID", "BookTable"."AuthorID", "SeriesTable"."SeriesName", "SeriesTable"."NumberOfBooks" 
FROM "BookTable", "SeriesTable" 
WHERE "BookTable"."SeriesID" = "SeriesTable"."SeriesID"

[jmadero]

Thanks! Worked like a charm. I'll probably be posting another 50 questions about this project in the coming weeks. Really appreciate the guidance, patience, etc....

If you're a beer drinker, round on me

[UnklDonald418]

Another recommendation concerning the form document MyLibrary.
On the Data tab of the Form Properties dialog for each of the 3 SubForms, change the Navigation bar property to Parent Form.
With that change, if you select something on one of the SubForms it won't hijack the main navigation bar.
Cheers!!

[jmadero]

I was trying to figure out how to do that! Thank you! Posting another question now