Master->Child using "like"....possible?

[K90267000 via AccessMonster.com]

Hi all,
In a report with subreport, is the following possible?

Master = FieldM (eg "P1")
Child = Like '*' FieldC & '*' (eg "P1P2ABC")

Reason is I need subreport with "P1P2ABC" to show up for Master record with
FieldM="P1" and Master record with FieldM="P2".

If possible, how can i enable that?

Thanks!
Ken.

 

[Duane Hookom]

It seems you might be storing more than a single value in a field. You can
create a column in your subreport's record source like:
ChildLink: Left([FieldC],2)
Then set the link master/child like you normally would.

BTW: you can't set these properties using "Like" or wildcards.

 

[K90267000 via AccessMonster.com]

Thank you sir for your assist.
Your suggestion is constructive, however,
such subreport will work for Master="P1" not "P2",
Thanks for the effort.

It seems you might be storing more than a single value in a field. You can
create a column in your subreport's record source like:
ChildLink: Left([FieldC],2)
Then set the link master/child like you normally would.

BTW: you can't set these properties using "Like" or wildcards.

Hi all,
In a report with subreport, is the following possible?

[quoted text clipped - 9 lines]

Thanks!
Ken.

 

[Duane Hookom]

Your request doesn't include enough information for me to understand.
Was I correct in assuming you are storing multiple pieces of information in
a single field?
Can you provide several master values with about 5-6 child values that you
would like to link?

There might be a solution but you need to provide more specifications and
sample records.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm

Thank you sir for your assist.
Your suggestion is constructive, however,
such subreport will work for Master="P1" not "P2",
Thanks for the effort.

It seems you might be storing more than a single value in a field. You can
create a column in your subreport's record source like:
ChildLink: Left([FieldC],2)
Then set the link master/child like you normally would.

BTW: you can't set these properties using "Like" or wildcards.

Hi all,
In a report with subreport, is the following possible?

[quoted text clipped - 9 lines]

Thanks!
Ken.