Joined: 09 Aug 2010
Online Status: Offline
Posts: 53
Topic: Comparing two columns against one Posted: 27 Apr 2011 at 1:37am
Hi,
I have four columns: BOMPARENT, BOMCHILD in one table THEN PARTNUM which has PARTDESC linked two it in another table.
I have PARTDESC set to display only PG50 parts. What i would then like to do is display BOMPARENT which is like PG50 but then display all BOMCHILD which are not PG50 but are only in BOMPARENT that are PG50.
Joined: 01 Dec 2010
Online Status: Offline
Posts: 386
Posted: 27 Apr 2011 at 2:39am
display all BOMCHILD which are not PG50 but are only in BOMPARENT that are PG50.
What is the relationship between a BOMPARENT and a BOMCHILD?
I would probably try grouping each BOMCHILD with its corresponding BOMPARENT and then filter the results to only show the groups where BOMPARENT is PG50.
Joined: 01 Dec 2010
Online Status: Offline
Posts: 386
Posted: 27 Apr 2011 at 7:20am
You would want to group each child with each parent first, and then you will use a group selection formula to select which groups you want to show. That is, all parents that have "PG50".
By grouping each child with their parent first, you can guarantee that all the parts for a particular parent is shown.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
