1 table or more?

[sbooth]

Currently, I have the following table:

tblPointsChart
PointsNum_pk
EntryCountMin
EntryCountMax
PlacementNum
Points


It is used to assign points based on:

tblShowClassEntry
ShowClassNum_fk
EntryNum_fk
PlacementNum_fk

and qryEntriesPerClass that returns the number of entries in a class.

My question is should I keep tblPointsChart as one table? tblPointsChart does not link easily with qryEntriesPerClass and tblShowClassEntry.

I have used the following code to get the results I need:

SELECT tblShowClass.ShowClassNum_pk, tblShowClassEntry.EntryNum_fk, tblShowClassEntry.PlacingNum_fk, qryEntriesPerClass.CountOfEntryNum_fk, tblPointsChart.Points
FROM (tblPlacement INNER JOIN (tblPointsChart INNER JOIN (qryEntriesPerClass INNER JOIN tblShowClass ON qryEntriesPerClass.ShowClassNum_fk = tblShowClass.ShowClassNum_pk) 
ON ( qryEntriesPerClass.CountOfEntryNum_fk between tblPointsChart.EntryCountMin  and tblPointsChart.EntryCountMax))
ON tblPlacement.PlacementNum_pk = tblPointsChart.PlacementNum_fk) INNER JOIN (tblEntry INNER JOIN tblShowClassEntry ON tblEntry.EntryNum_pk = tblShowClassEntry.EntryNum_fk) ON (tblShowClass.ShowClassNum_pk = tblShowClassEntry.ShowClassNum_fk) AND (tblPlacement.PlacementNum_pk = tblShowClassEntry.PlacingNum_fk)
WHERE (((qryEntriesPerClass.CountOfEntryNum_fk) Between [tblPointsChart].[EntryCountMin] And [EntryCountMax]))
ORDER BY tblShowClass.ShowClassNum_pk, tblShowClassEntry.PlacingNum_fk;

I am attaching a copy of my test database if anybody want to look at it.

I am just not sure how to change tblPointsChart to make this work more smoothly. Any suggestions would be greatly appreciated.