Linking?

[aellistechsupport]

Not sure the best way to try and explain this ...



I am linking tables from accounting system and a completely separate system for membership detail information.

There's a table named MemberTypes which has a productcode that links to the itemnmbr (item code) from the accounting system.

I need to pull the MemberType descriptions for the productcodes or basically the itemnmbr.
HOWEVER in the accounting system there's an itemnmbr called "ADMFEE" which in the membership system and in the membertype table this code does not exist.

The final report is grouped on MemberType but since the ADMFEE does not exist in that table it comes up Null. I think I can group the ADMFEE under FEES.

Anyway, side tracked there ...
If you look at the below sample data the "All Year FSC" seems to show the corresponding MemberType for the invoiced item as described in the ItemDescription field and identified by the Item and ProductCodes

HOWEVER the next two sets "Ann Arbor FSC" and "Arrowhead FSC" should show "First Family" but it's showing other MemberType labels.
I'm not really sure why?

OrgName	OrgMbrshipNo	MemberType	Item	ProductCode	MbrshipNoDynamics	ItemDescription	ExtPrice	PaymentDate
All Year FSC	30	Introductory	MB-INTRO	MB-INTRO	1072447	MEMBERSHIP: INTRODUCTORY FOR #1072447; DUPON, MICHELLE	25	5/21/2014
All Year FSC	30	Subsequent Family	M2-SUB	M2-SUB	1072325	MEMBERSHIP: SUBSEQUENT FAMILY FOR #1072325; SPIERS, ANYA	20	5/21/2014
All Year FSC	30	Subsequent Family	M2-SUB	M2-SUB	1072448	MEMBERSHIP: SUBSEQUENT FAMILY FOR #1072448; DUPONT, JULIE	20	5/21/2014
All Year FSC	30		ADMFEE		0	PROCESSING FEE	1	5/21/2014
All Year FSC	30	Introductory	MB-INTRO	MB-INTRO	1072324	MEMBERSHIP: INTRODUCTORY FOR #1072324; SPIERS, BEN	25	5/21/2014
Ann Arbor FSC	70		ADMFEE		0	PROCESSING FEE	1	5/3/2014
Ann Arbor FSC	70	Inter-Collegiate Team	M1-REG	M1-REG	1068171	MEMBERSHIP: FIRST FAMILY FOR #1068171; BERSTEIN, SHANTI	50	5/3/2014
Ann Arbor FSC	70	First Family	M1-REG	M1-REG	1068171	MEMBERSHIP: FIRST FAMILY FOR #1068171; BERSTEIN, SHANTI	50	5/3/2014
Ann Arbor FSC	70	Friends of Figure Skating	M1-REG	M1-REG	1068171	MEMBERSHIP: FIRST FAMILY FOR #1068171; BERSTEIN, SHANTI	50	5/3/2014
Arrowhead FSC	100		ADMFEE		0	PROCESSING FEE	1	5/2/2014
Arrowhead FSC	100	Inter-Collegiate Team	M1-REG	M1-REG	1068157	MEMBERSHIP: FIRST FAMILY FOR #1068157; GONG, CATHY	50	5/2/2014
Arrowhead FSC	100	Friends of Figure Skating	M1-REG	M1-REG	1068157	MEMBERSHIP: FIRST FAMILY FOR #1068157; GONG, CATHY	50	5/2/2014
Arrowhead FSC	100	First Family	M1-REG	M1-REG	1068157	MEMBERSHIP: FIRST FAMILY FOR #1068157; GONG, CATHY	50	5/2/2014
Arrowhead FSC	100	Inter-Collegiate Team	M1-REG	M1-REG	6606145	MEMBERSHIP: FIRST FAMILY FOR #6606145; HIOE, JAYLEN	50	5/2/2014
Arrowhead FSC	100	Friends of Figure Skating	M1-REG	M1-REG	6606145	MEMBERSHIP: FIRST FAMILY FOR #6606145; HIOE, JAYLEN	50	5/2/2014
Arrowhead FSC	100	First Family	M1-REG	M1-REG	6606145	MEMBERSHIP: FIRST FAMILY FOR #6606145; HIOE, JAYLEN	50	5/2/2014

SELECT IIf(IsNull([OrganizationName]),"Individual",[OrganizationName]) AS OrgName, dbo_v020DeferredMembershipsDynamics.OrgMbrshipNo, IIf(IsNull([Description]),"Admin Fee",[Description]) AS MemberType, Trim([ITEMNMBR]) AS Item, lookup_MemberTypes.ProductCode, getNumber([ITEMDESC]) AS MbrshipNoDynamics, Trim([ITEMDESC]) AS ItemDescription, dbo_v020DeferredMembershipsDynamics.ExtPrice, dbo_v020DeferredMembershipsDynamics.PaymentDate, dbo_v020DeferredMembershipsDynamics.EndDate, dbo_v020DeferredMembershipsDynamics.MonthPaid
FROM dbo_v020DeferredMembershipsDynamics LEFT JOIN lookup_MemberTypes ON dbo_v020DeferredMembershipsDynamics.ITEMNMBR = lookup_MemberTypes.ProductCode
ORDER BY IIf(IsNull([OrganizationName]),"Individual",[OrganizationName]);

Any ideas and how can I fix this?

[dkanti]

Not sure the best way to try and explain this ...

I am linking tables from accounting system and a completely separate system for membership detail information.

There's a table named MemberTypes which has a productcode that links to the itemnmbr (item code) from the accounting system.

I need to pull the MemberType descriptions for the productcodes or basically the itemnmbr.
HOWEVER in the accounting system there's an itemnmbr called "ADMFEE" which in the membership system and in the membertype table this code does not exist.

The final report is grouped on MemberType but since the ADMFEE does not exist in that table it comes up Null. I think I can group the ADMFEE under FEES.

Anyway, side tracked there ...
If you look at the below sample data the "All Year FSC" seems to show the corresponding MemberType for the invoiced item as described in the ItemDescription field and identified by the Item and ProductCodes

HOWEVER the next two sets "Ann Arbor FSC" and "Arrowhead FSC" should show "First Family" but it's showing other MemberType labels.
I'm not really sure why?

OrgName	OrgMbrshipNo	MemberType	Item	ProductCode	MbrshipNoDynamics	ItemDescription	ExtPrice	PaymentDate
All Year FSC	30	Introductory	MB-INTRO	MB-INTRO	1072447	MEMBERSHIP: INTRODUCTORY FOR #1072447; DUPON, MICHELLE	25	5/21/2014
All Year FSC	30	Subsequent Family	M2-SUB	M2-SUB	1072325	MEMBERSHIP: SUBSEQUENT FAMILY FOR #1072325; SPIERS, ANYA	20	5/21/2014
All Year FSC	30	Subsequent Family	M2-SUB	M2-SUB	1072448	MEMBERSHIP: SUBSEQUENT FAMILY FOR #1072448; DUPONT, JULIE	20	5/21/2014
All Year FSC	30		ADMFEE		0	PROCESSING FEE	1	5/21/2014
All Year FSC	30	Introductory	MB-INTRO	MB-INTRO	1072324	MEMBERSHIP: INTRODUCTORY FOR #1072324; SPIERS, BEN	25	5/21/2014
Ann Arbor FSC	70		ADMFEE		0	PROCESSING FEE	1	5/3/2014
Ann Arbor FSC	70	Inter-Collegiate Team	M1-REG	M1-REG	1068171	MEMBERSHIP: FIRST FAMILY FOR #1068171; BERSTEIN, SHANTI	50	5/3/2014
Ann Arbor FSC	70	First Family	M1-REG	M1-REG	1068171	MEMBERSHIP: FIRST FAMILY FOR #1068171; BERSTEIN, SHANTI	50	5/3/2014
Ann Arbor FSC	70	Friends of Figure Skating	M1-REG	M1-REG	1068171	MEMBERSHIP: FIRST FAMILY FOR #1068171; BERSTEIN, SHANTI	50	5/3/2014
Arrowhead FSC	100		ADMFEE		0	PROCESSING FEE	1	5/2/2014
Arrowhead FSC	100	Inter-Collegiate Team	M1-REG	M1-REG	1068157	MEMBERSHIP: FIRST FAMILY FOR #1068157; GONG, CATHY	50	5/2/2014
Arrowhead FSC	100	Friends of Figure Skating	M1-REG	M1-REG	1068157	MEMBERSHIP: FIRST FAMILY FOR #1068157; GONG, CATHY	50	5/2/2014
Arrowhead FSC	100	First Family	M1-REG	M1-REG	1068157	MEMBERSHIP: FIRST FAMILY FOR #1068157; GONG, CATHY	50	5/2/2014
Arrowhead FSC	100	Inter-Collegiate Team	M1-REG	M1-REG	6606145	MEMBERSHIP: FIRST FAMILY FOR #6606145; HIOE, JAYLEN	50	5/2/2014
Arrowhead FSC	100	Friends of Figure Skating	M1-REG	M1-REG	6606145	MEMBERSHIP: FIRST FAMILY FOR #6606145; HIOE, JAYLEN	50	5/2/2014
Arrowhead FSC	100	First Family	M1-REG	M1-REG	6606145	MEMBERSHIP: FIRST FAMILY FOR #6606145; HIOE, JAYLEN	50	5/2/2014

SELECT IIf(IsNull([OrganizationName]),"Individual",[OrganizationName]) AS OrgName, dbo_v020DeferredMembershipsDynamics.OrgMbrshipNo, IIf(IsNull([Description]),"Admin Fee",[Description]) AS MemberType, Trim([ITEMNMBR]) AS Item, lookup_MemberTypes.ProductCode, getNumber([ITEMDESC]) AS MbrshipNoDynamics, Trim([ITEMDESC]) AS ItemDescription, dbo_v020DeferredMembershipsDynamics.ExtPrice, dbo_v020DeferredMembershipsDynamics.PaymentDate, dbo_v020DeferredMembershipsDynamics.EndDate, dbo_v020DeferredMembershipsDynamics.MonthPaid
FROM dbo_v020DeferredMembershipsDynamics LEFT JOIN lookup_MemberTypes ON dbo_v020DeferredMembershipsDynamics.ITEMNMBR = lookup_MemberTypes.ProductCode
ORDER BY IIf(IsNull([OrganizationName]),"Individual",[OrganizationName]);

Any ideas and how can I fix this?

-------
Can you provide me the sample data table of both the tables like you have given screenshot of output table?
thanks

[aellistechsupport]

Here you go.

[dkanti]

You are pulling MemberTypes from table ‘lookup_MemberTypes’ and Item Description from table ‘dbo_v020DeferredMembershipsDynamics’ with left join on Itemnbr and productcode, however neither Itemnbr or productcode has PK, they are not unique, you need unique/primary key to link tables and then apply union query if required.
PK: you can make it by adding two/three fields which can be denoted as primary key to pull values in final output table.plz try this..

[aellistechsupport]

unfortunately that's not really possible.

These tables are existing tables in SQL DB.
lookup_MemberTypes is from one db (Phoenix) and the dynamics table is from another db (Great Plains)
Aside from the ProductCode and to the ITEMNMBR, the only way, I was told, is to extrapolate the membership number from the ITEMDESC, which I did, and link that to the membershipnumber in Phoenix, which exists in the entity.Person table.

the "PK" are:
in the "lookup_MemberTypes" is the "Id" field, which is the MemberTypeID.
in the dynamics table it's "SOPNUMBE" which is the invoice number.

As noted it's left outer join because the AMDFEE in dynamics does not exist in ProductCode in Phoenix and I need the data for those ADMFEE transactions to report.

[aellistechsupport]

I was trying to get it in the least amount of steps (queries).

What I did was get all of the dynamics info AND the Phoenix info ONLY up to the membership information and the membertype to those memberships are tied with using the ProductCode to the ITEMNMBR.

Once in Access and running the ExtractValue() function to parse out the membershipnumber from the ITEMDESC then adding the entity.Person and linking on the membershipnumber for the contact info.

I am still getting duplicates on some of the records?

[aellistechsupport]

I got most of them but there are still a few odd results

In the membership db the actual record is the one with 6/30/2014 as the EndDate.
NOTE: this is NOT always the case, meaning the 2014 enddate so can't use that as a parameter.

As you can see for this record the one with the MemberType info has a EndDate of 6/30/2017.

518	FSC of Charleston	Robert Benner	1060155	MEMBERSHIP: COLLEGIATE FOR #1060155; BENNER, ROBERT	COLMEM	70	Collegiate	5/2/2014	6/30/2017
518	FSC of Charleston	Robert Benner	1060155	MEMBERSHIP: COLLEGIATE FOR #1060155; BENNER, ROBERT	COLMEM	70		5/2/2014	6/30/2014

the ADMFEE will not have a MemberType as mentioned previously.
The ones that seem not valid with the 6/30/2017 EndDate also do not have a MemberType.

I'm not sure how to retain the ADMFEE without MemberType but exclude the other records without a MemberType?

See OrgMbrshipNo 518 who is FSC of Charleston:

The records before this organization are all correct and are NOT duplicating even with the ADMFEE but this organization and couple others are duplicating.
It seems that it's duplicating when a Name has an EndDate different then the other members in the Organization.

OrgMbrshipNo	OrganizationName	Name	MbrshipNoDynamics	ItemDesc	Item	ExtPrice	MemberType	PaymentDate	EndDate
847	Escondido FSC		0	PROCESSING FEE	ADMFEE	1		5/23/2014	6/30/2014
847	Escondido FSC	Marni Gray	932166	MEMBERSHIP: SUBSEQUENT FAMILY FOR #932166; GRAY, MARNI	M2-SUB	20	Subsequent Family	5/23/2014	6/30/2014
847	Escondido FSC	Nathaniel Chaney	1070795	MEMBERSHIP: SUBSEQUENT FAMILY FOR #1070795; CHANEY, NATHANIEL	M2-SUB	20	Subsequent Family	5/23/2014	6/30/2014
847	Escondido FSC	Jessica Chaney	1070797	MEMBERSHIP: SUBSEQUENT FAMILY FOR #1070797; CHANEY, JESSICA	M2-SUB	20	Subsequent Family	5/23/2014	6/30/2014
847	Escondido FSC	Theresa Poletto	6000103	MEMBERSHIP: SUBSEQUENT FAMILY FOR #6000103; POLETTO, THERESA	M2-SUB	20	Subsequent Family	5/23/2014	6/30/2014
847	Escondido FSC	Cindy Noh	6298261	MEMBERSHIP: SUBSEQUENT FAMILY FOR #6298261; NOH, CINDY	M2-SUB	20	Subsequent Family	5/23/2014	6/30/2014
847	Escondido FSC	Carla Petties	6303614	MEMBERSHIP: SUBSEQUENT FAMILY FOR #6303614; PETTIES, CARLA	M2-SUB	20	Subsequent Family	5/23/2014	6/30/2014
847	Escondido FSC	Alyssa Barandiaran	6485090	MEMBERSHIP: SUBSEQUENT FAMILY FOR #6485090; BARANDIARAN, ALYSSA	M2-SUB	20	Subsequent Family	5/23/2014	6/30/2014
847	Escondido FSC	Alison Portner	6677455	MEMBERSHIP: SUBSEQUENT FAMILY FOR #6677455; PORTNER, ALISON	M2-SUB	20	Subsequent Family	5/23/2014	6/30/2014
847	Escondido FSC	Masha Burdette	8851836	MEMBERSHIP: SUBSEQUENT FAMILY FOR #8851836; BURDETTE, MASHA	M2-SUB	20	Subsequent Family	5/23/2014	6/30/2014
1570	Essex SC of NJ, Inc.		0	PROCESSING FEE	ADMFEE	1		5/2/2014	6/30/2014
1570	Essex SC of NJ, Inc.	Gennaro Cascarano	1068073	MEMBERSHIP: INTRODUCTORY FOR #1068073; CASCARANO, GENNARO	MB-INTRO	25	Introductory	5/2/2014	6/30/2014
518	FSC of Charleston		0	PROCESSING FEE	ADMFEE	1		5/2/2014	6/30/2014
518	FSC of Charleston		0	PROCESSING FEE	ADMFEE	1		5/2/2014	6/30/2017
518	FSC of Charleston	Tori Newman	1023698	MEMBERSHIP: INTRODUCTORY FOR #1023698; NEWMAN, TORI	MB-INTRO	25	Introductory	5/2/2014	6/30/2014
518	FSC of Charleston	Tori Newman	1023698	MEMBERSHIP: INTRODUCTORY FOR #1023698; NEWMAN, TORI	MB-INTRO	25		5/2/2014	6/30/2017
518	FSC of Charleston	Robert Benner	1060155	MEMBERSHIP: COLLEGIATE FOR #1060155; BENNER, ROBERT	COLMEM	70	Collegiate	5/2/2014	6/30/2017
518	FSC of Charleston	Robert Benner	1060155	MEMBERSHIP: COLLEGIATE FOR #1060155; BENNER, ROBERT	COLMEM	70		5/2/2014	6/30/2014
518	FSC of Charleston	Mia Medina-Amores	1068020	MEMBERSHIP: INTRODUCTORY FOR #1068020; MEDINA-AMORES, MIA	MB-INTRO	25	Introductory	5/2/2014	6/30/2014
518	FSC of Charleston	Mia Medina-Amores	1068020	MEMBERSHIP: INTRODUCTORY FOR #1068020; MEDINA-AMORES, MIA	MB-INTRO	25		5/2/2014	6/30/2017
518	FSC of Charleston	Kate Confarotta	1068021	MEMBERSHIP: INTRODUCTORY FOR #1068021; CONFAROTTA, KATE	MB-INTRO	25	Introductory	5/2/2014	6/30/2014
518	FSC of Charleston	Kate Confarotta	1068021	MEMBERSHIP: INTRODUCTORY FOR #1068021; CONFAROTTA, KATE	MB-INTRO	25		5/2/2014	6/30/2017
518	FSC of Charleston	Anna Engler	8809750	MEMBERSHIP: INTRODUCTORY FOR #8809750; ENGLER, ANNA	MB-INTRO	25	Introductory	5/2/2014	6/30/2014
518	FSC of Charleston	Anna Engler	8809750	MEMBERSHIP: INTRODUCTORY FOR #8809750; ENGLER, ANNA	MB-INTRO	25		5/2/2014	6/30/2017
518	FSC of Charleston	Jeanie Martinette	8868005	MEMBERSHIP: INTRODUCTORY FOR #8868005; MARTINETTE, JEANIE	MB-INTRO	25		5/2/2014	6/30/2017
518	FSC of Charleston	Jeanie Martinette	8868005	MEMBERSHIP: INTRODUCTORY FOR #8868005; MARTINETTE, JEANIE	MB-INTRO	25	Introductory	5/2/2014	6/30/2014

[aellistechsupport]

I think I got it:

SELECT dbo_v020DeferredMembershipsDynamics.OrgMbrshipNo, IIf(IsNull([OrganizationName]),"Individual",[OrganizationName]) AS OrgName, dbo_v020DeferredMembershipsDynamics.Item, getNumber([ITEMDESC]) AS MbrshipNoDynamics, dbo_v020DeferredMembershipsDynamics.ItemDesc, dbo_v020DeferredMembershipsDynamics.ExtPrice, dbo_v020DeferredMembershipsDynamics.PaymentDate, IIf([Item]="ADMFEE","Processing Fee",[MemberType]) AS [Member Type], IIf(IsNull([MemberType]),Null,[EndDate]) AS [End Date], dbo_v020DeferredMembershipsDynamics.MonthPaid, dbo_v020DeferredMembershipsDynamics.BACHNUMB
FROM dbo_v020DeferredMembershipsDynamics
GROUP BY dbo_v020DeferredMembershipsDynamics.OrgMbrshipNo, IIf(IsNull([OrganizationName]),"Individual",[OrganizationName]), dbo_v020DeferredMembershipsDynamics.Item, getNumber([ITEMDESC]), dbo_v020DeferredMembershipsDynamics.ItemDesc, dbo_v020DeferredMembershipsDynamics.ExtPrice, dbo_v020DeferredMembershipsDynamics.PaymentDate, IIf([Item]="ADMFEE","Processing Fee",[MemberType]), IIf(IsNull([MemberType]),Null,[EndDate]), dbo_v020DeferredMembershipsDynamics.MonthPaid, dbo_v020DeferredMembershipsDynamics.BACHNUMB
HAVING (((IIf([Item]="ADMFEE","Processing Fee",[MemberType])) Is Not Null))
ORDER BY IIf(IsNull([OrganizationName]),"Individual",[OrganizationName]), dbo_v020DeferredMembershipsDynamics.Item;

OrgMbrshipNo	OrgName	Name	MbrshipNoDynamics	ItemDesc	Item	ExtPrice	PaymentDate	EndDate	Organization	MemberType
847	Escondido FSC		0	PROCESSING FEE	ADMFEE	1	5/23/2014		Escondido FSC-847	Processing Fee
847	Escondido FSC	Alison Portner	6677455	MEMBERSHIP: SUBSEQUENT FAMILY FOR #6677455; PORTNER, ALISON	M2-SUB	20	5/23/2014	6/30/2014	Escondido FSC-847	Subsequent Family
847	Escondido FSC	Alyssa Barandiaran	6485090	MEMBERSHIP: SUBSEQUENT FAMILY FOR #6485090; BARANDIARAN, ALYSSA	M2-SUB	20	5/23/2014	6/30/2014	Escondido FSC-847	Subsequent Family
847	Escondido FSC	Carla Petties	6303614	MEMBERSHIP: SUBSEQUENT FAMILY FOR #6303614; PETTIES, CARLA	M2-SUB	20	5/23/2014	6/30/2014	Escondido FSC-847	Subsequent Family
847	Escondido FSC	Cindy Noh	6298261	MEMBERSHIP: SUBSEQUENT FAMILY FOR #6298261; NOH, CINDY	M2-SUB	20	5/23/2014	6/30/2014	Escondido FSC-847	Subsequent Family
847	Escondido FSC	Jessica Chaney	1070797	MEMBERSHIP: SUBSEQUENT FAMILY FOR #1070797; CHANEY, JESSICA	M2-SUB	20	5/23/2014	6/30/2014	Escondido FSC-847	Subsequent Family
847	Escondido FSC	Marni Gray	932166	MEMBERSHIP: SUBSEQUENT FAMILY FOR #932166; GRAY, MARNI	M2-SUB	20	5/23/2014	6/30/2014	Escondido FSC-847	Subsequent Family
847	Escondido FSC	Masha Burdette	8851836	MEMBERSHIP: SUBSEQUENT FAMILY FOR #8851836; BURDETTE, MASHA	M2-SUB	20	5/23/2014	6/30/2014	Escondido FSC-847	Subsequent Family
847	Escondido FSC	Nathaniel Chaney	1070795	MEMBERSHIP: SUBSEQUENT FAMILY FOR #1070795; CHANEY, NATHANIEL	M2-SUB	20	5/23/2014	6/30/2014	Escondido FSC-847	Subsequent Family
847	Escondido FSC	Theresa Poletto	6000103	MEMBERSHIP: SUBSEQUENT FAMILY FOR #6000103; POLETTO, THERESA	M2-SUB	20	5/23/2014	6/30/2014	Escondido FSC-847	Subsequent Family
1570	Essex SC of NJ, Inc.		0	PROCESSING FEE	ADMFEE	1	5/2/2014		Essex SC of NJ, Inc.-1570	Processing Fee
1570	Essex SC of NJ, Inc.	Gennaro Cascarano	1068073	MEMBERSHIP: INTRODUCTORY FOR #1068073; CASCARANO, GENNARO	MB-INTRO	25	5/2/2014	6/30/2014	Essex SC of NJ, Inc.-1570	Introductory
518	FSC of Charleston		0	PROCESSING FEE	ADMFEE	1	5/2/2014		FSC of Charleston-518	Processing Fee
518	FSC of Charleston	Anna Engler	8809750	MEMBERSHIP: INTRODUCTORY FOR #8809750; ENGLER, ANNA	MB-INTRO	25	5/2/2014	6/30/2014	FSC of Charleston-518	Introductory
518	FSC of Charleston	Jeanie Martinette	8868005	MEMBERSHIP: INTRODUCTORY FOR #8868005; MARTINETTE, JEANIE	MB-INTRO	25	5/2/2014	6/30/2014	FSC of Charleston-518	Introductory
518	FSC of Charleston	Kate Confarotta	1068021	MEMBERSHIP: INTRODUCTORY FOR #1068021; CONFAROTTA, KATE	MB-INTRO	25	5/2/2014	6/30/2014	FSC of Charleston-518	Introductory
518	FSC of Charleston	Mia Medina-Amores	1068020	MEMBERSHIP: INTRODUCTORY FOR #1068020; MEDINA-AMORES, MIA	MB-INTRO	25	5/2/2014	6/30/2014	FSC of Charleston-518	Introductory
518	FSC of Charleston	Robert Benner	1060155	MEMBERSHIP: COLLEGIATE FOR #1060155; BENNER, ROBERT	COLMEM	70	5/2/2014	6/30/2017	FSC of Charleston-518	Collegiate
518	FSC of Charleston	Tori Newman	1023698	MEMBERSHIP: INTRODUCTORY FOR #1023698; NEWMAN, TORI	MB-INTRO	25	5/2/2014	6/30/2014	FSC of Charleston-518	Introductory

[dkanti]

great...........