Display default on report for insurances not in list

[jeremy0028]

Ok Have a table name tlbproviders

ProviderID(Auto)
Provider First Name
Provider Last Name
Provider MI
License#( Note This is the Default for Insurances not in tbl
providerID table)

I have another table name tblProviderID

ProviderID(Auto)

ProviderName(look up)
SELECT tblProviders.ProviderID, [tblProviders].[ProviderFirstName] & "
" & [tblProviders].[ProviderMI] & " " &
[tblProviders].[ProviderLastName] & ", " & [tblProviders].[Degree] AS
Expr1
FROM tblProviders;

InsuranceName
SELECT tblInsurance.InsuranceName, tblInsurance.InsuranceAddress1,
tblInsurance.InsuranceAddress2, tblInsurance.InsuranceCity,
tblInsurance.InsuranceState, tblInsurance.InsuranceZip
FROM tblInsurance;

Pin#
Group#
Box24k


Heres the scope Certain insurance require different licenses see
tblproviders when i assign a value to a certain insurance see
pin#(same thing as license#. When I generate a report it only shows
Insurances assigned a value which is the pin# field.

How do i create a report so that all insurances with a value will show
up and all insurances not in the tblProviderID will be assigned the
License # see tblProviders.