Display "Multiple" if parent contains more then 1 subrecords

[isladogs]

If a label is the only way to make this happen how would I set that up?

I said it was the easiest way of displaying that text - not necessarily the only way. If you're happy to do that just add a label with that text wherever you want it to appear & use code as in my first reply

Beyond that, I'm sorry but I'm no clearer having looked at the 4 screenshots so unless you can explain in a different way, I'm going to drop out of this thread

Read the FAQ to find out how to upload images to this site

 

[yeasir01]

This is what ended up working for me, I put this in the field area of the query. Hopefully, this thread can help someone else. Thanks for steering me in the right direction guys!

WARNING: Nz(IIf(DCount("*","ISD_LIST_SUB_QRY","[ISD_LIST_SUB_QRY].[ID]=" & [ISD_DETAILS_TBL].[ID])>1,"Multiple Records",DLookUp("WARNING_DESC","ISD_LIST_SUB_QRY","[ISD_LIST_SUB_QRY].[ID]=" & [ISD_DETAILS_TBL].[ID])),"No Records")