Connect a form & subform with aLIKE statement?

[Wayne Beck]

Can somebody please help, I've created a form which shows a subform that is linked by buyers names. The problem i have is that in one table the buyers record could contain two names ie "Joe Bloggs & A Friend". This is causing me some problems with conecting to the subform. Is there any way that i can link the main form to the subreport using the LIKE statement ie '[subformBuyer] LIKE "*Joe*"'

Sorry if im confusing people but i cant seem to explain it any better.

Thanks for any help in advance

Wayne

 

[KevinM]

Why don't you link the two tables the proper way with Primary ID and Foreign key fields?

 

[Wayne Beck]

Thanks for your help both. I've decided to fix the data and change the way that my tables link.

Thanks

Wayne