BAQ Table Relation question

Yahoo Archive
1
I was overthinking this. My background/knowledge is with Universe database (Avante'), and I was looking at this hard-coded value as a component of the "key" to my EntityGLC record that I thought I had to provide via the Table Relation

What I was trying to do:
On the parent side of my table relations is Part, joining to EntityGLC
Part.Company -> EntityGLC.Company
Part.ClassID -> EntityGLC.Key1
"PartClass" -> EntityGLC.RelatedToFile

What worked, thanks to your help, is I only joined the first two things (Company and ClassID), and added criteria to the EntityGLC table for EntityGLC.RelatedtoFile = "PartClass"

Thanks again. This database/environment is a whole new world to me, after being on Universe (and Pick previously) for 30+ years!

Cindy Lawbaugh
MJMC, Inc.



--- In vantage@yahoogroups.com, "Len Hartka" <len.hartka@...> wrote:
>
> Good Day Cindy:
>
>
>
> I am not sure what you are after. How is it different
> than linking the tables as usual and then having a filter to limit it to
> a value.
>
>
>
> There is also the 'Criteria" ability on the Phrase-Build
> tab in BAQ design screen - highlight the table and at the bottom select
> the 'criteria' tab. They can be constants or Prompts.
>
>
>
>
2
I'm just getting comfortable doing BAQ's so bear with me.

I have had two situations recently, where I would like one of the values in a table relation to be a constant value. Is this possible?

Specifically, I want to retrieve a Part record's Part Class GLControl code. The table that contains that value is EntityGLC, and I believe one of the pieces I need is "RelatedToFile", in which I'd like to use "PartClass"

Epicor 9.05.700a

Cindy Lawbaugh
MJMC, Inc.
3
Good Day Cindy:



I am not sure what you are after. How is it different
than linking the tables as usual and then having a filter to limit it to
a value.



There is also the 'Criteria" ability on the Phrase-Build
tab in BAQ design screen - highlight the table and at the bottom select
the 'criteria' tab. They can be constants or Prompts.




Len.hartka@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of CindyL
Sent: Wednesday, February 20, 2013 6:09 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Table Relation question





I'm just getting comfortable doing BAQ's so bear with me.

I have had two situations recently, where I would like one of the values
in a table relation to be a constant value. Is this possible?

Specifically, I want to retrieve a Part record's Part Class GLControl
code. The table that contains that value is EntityGLC, and I believe one
of the pieces I need is "RelatedToFile", in which I'd like to use
"PartClass"

Epicor 9.05.700a

Cindy Lawbaugh
MJMC, Inc.





This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]