Not showing up on report

[jeremy0028]

I have the following table

InsuranceID(Pk)AutoNumber
Insurance Name

I also have the following table called tblproviderID

Provider(Lookup ComboBox)code
SELECT [tbladdprovider].[ProviderID], [tbladdprovider].[First Name]&"
"& [tbladdprovider].[Last Name]&" "& [tbladdprovider].[MI]&" "&
[tbladdprovider].[Degree] FROM [tbladdprovider];

Insurance Name(Lookup Combo Box)
SELECT [tblAddInsurance].[InsuranceID], [tblAddInsurance].[Insurance
Name] FROM [tblAddInsurance];


Pin#(Text)
Box24K(Text)
Group#(Text)

Frm Primary Insurance(Lookup ComboBox) Insurance Name, InsuranceID

Heres the problem i'm having when generate a report I select primary
insurance from IRI-people form
Provider, Pin

However if you take a look at the top portion where Its says provider,
insurance, pin#, Box24k
If i select Provider Insurance and enter pin # in text box everything
shows up on report

But If i select Provider Leave insurance blank and enter Pin# the
report only shows providers that are associated with insurance
selected.

I do i generate a report so that if insurance field is blank it will
apply Pin# to all Insurances

 

[Rob Oldfield]

I can't say for sure (as I don't use them) but I'd strongly suspect that the
problem is being caused by your use of lookups in your table design. Not to
overstate the case, but these are the spawn of the devil and should be
avoided only slightly more than accidentally stapling your nipple to a door.

Lose them.

Then create a query that does the lookup and base the report on that
instead.

 

[Marshall Barton]

I can't say for sure (as I don't use them) but I'd strongly suspect that the
problem is being caused by your use of lookups in your table design. Not to
overstate the case, but these are the spawn of the devil and should be
avoided only slightly more than accidentally stapling your nipple to a door.

Lose them.

Hmmmm, I'm getting the impression that Rob doesn't
appreciate the subtle benefits of Lookup Fields ;-))