I have a membership application.
One of my users wants to bring his excel data in my app.
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)
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???