Is there a relation between soil compaction test value and soil bearing capacity value?
The compaction test measures compaction of the particular material at the surficial level.
This is mostly a parameter to determine if the site has been prepared properly.
The soil bearing capacity is a function of the loads imposed by the structure and is normally limited by settlement. If you do not have any fill, the compactive effort will generally only extend to a foot or two below the ground surface. Unless your footing is very lightly loaded, the stresses imposed by the structure will extend several feet below ground.
Your geotech should be giving you bearing capacity recommendations based on the structural loadings they are provided and the subsurface conditions.
Above is a snippet.