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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

K90267000 - 23 Jan 2008 03:36 GMT

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.

Reply to this Message

Duane Hookom - 23 Jan 2008 05:21 GMT

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.

Signature

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

> Hi all,
> In a report with subreport, is the following possible?
[quoted text clipped - 9 lines]
> Thanks!
> Ken.

Reply to this Message

K90267000 - 23 Jan 2008 09:59 GMT

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:
[quoted text clipped - 8 lines]
>> Thanks!
>> Ken.

Reply to this Message

Duane Hookom - 23 Jan 2008 14:16 GMT

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.

Signature

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,
[quoted text clipped - 13 lines]
> >> Thanks!
> >> Ken.

Reply to this Message