synergy46

FM 13 Adv - Import 'many' table

Discussion created by synergy46 on Feb 24, 2014
Latest reply on Feb 26, 2014 by synergy46

I have a membership application.

One of my users wants to bring his excel data in my app.

Tables are;

 

MEMBERS;

PKMEMBERID

LASTNAME

FIRSTNAME

ADDRESS1

ADDRESS2

CITY

...ETC.

 

PROGRESS:

PKProgressID

FKMEMBERID

DatePetitioned

DateAccepted

....ETC

 

These two tables are related 1 to many.

 

As is typical of many users, *ALL* the information is in a giant Excel spreadsheat with one row for each member.

 

The Excel spreadsheet has:

 

MemberID (Unique membership number)

NameLast

NameFirst

Date Petitioned

Date Accepted

 

I can easily import the appropriate Members data into MEMBERS and FM agreeably generates a PK.

HOWEVER, when I try and import the Excel::Date Petitioned and Excel::Date Accepted fields, there seems to be no way

to generate the appropriate PROGRESS::FKMemberID

 

My sense of it is that I can import the EXCEL::MemberID in both the Members:: import and the Progress:: import to link the two FM tables. But, after that I am stuck. I need to relink the Members::PK to the Progress::FK... Ideas???

Thank you

 

Ron

Outcomes