gevensen
asked on
how do i exhange information between 2 tables
filemaker pro version 9 for windows
I have 2 tables
One is a master membership table ( i use a form view to input data)
The second is a table that records dues payments ( i also use a form view to input data)
I have already figured out how to look up the ID number in the membership table using a popup window and input it into the corresponding field in the dues record without having the mebership record opened.
But when I retrieve that ID number I would like the data from the membership file (name address city state zip that is associated with the member ID) to automatically be inputted in the form i use for entering dues payments
I am having a difficult time finding any decent scripting examples or maybe im looking in the wrong places
I have 2 tables
One is a master membership table ( i use a form view to input data)
The second is a table that records dues payments ( i also use a form view to input data)
I have already figured out how to look up the ID number in the membership table using a popup window and input it into the corresponding field in the dues record without having the mebership record opened.
But when I retrieve that ID number I would like the data from the membership file (name address city state zip that is associated with the member ID) to automatically be inputted in the form i use for entering dues payments
I am having a difficult time finding any decent scripting examples or maybe im looking in the wrong places
ASKER
enclosed is the file, i tried several adjustments but havent figured it out yet
you will see an icon verify record on the receive ministerial tithe
what i was going to do was enter the ID from a simple popup and then click verify to pull the data related to that number from the NJMD Ministry file to insure that if there are people with the same last name in the files we can verify we picked the right account number
i couldnt attach the file here so i uploaded it to my server
the location is www.njupc.org/transfer/njmd.fp7
you will see an icon verify record on the receive ministerial tithe
what i was going to do was enter the ID from a simple popup and then click verify to pull the data related to that number from the NJMD Ministry file to insure that if there are people with the same last name in the files we can verify we picked the right account number
i couldnt attach the file here so i uploaded it to my server
the location is www.njupc.org/transfer/njmd.fp7
got a pb with the link, does not work...
use:
http://www.ee-stuff.com/accessLogin.php?returnURL=%2FExpert%2FUpload%2Fupload.php
or:
http://pagetruck.com (mine)
use:
http://www.ee-stuff.com/accessLogin.php?returnURL=%2FExpert%2FUpload%2Fupload.php
or:
http://pagetruck.com (mine)
ASKER
http://www.njupc.org/experts/NJMD.fp7
i moved it to a new directory the file name was all caps
i tried this one
sorry
i moved it to a new directory the file name was all caps
i tried this one
sorry
ok; works now
ASKER
Im not seeing any changes??
You obviously missed the 1st lesson at the filemaker school, and God is of no help in this situation!
I did:
- changed the link for using IDs only
- created a fullname field to reduce the identity to a single field to have them both in the popup menu (next)
- created a new list for the popup menu to show first and lastname, but insert the ID field.
and that's all...
If you come across dups using last + first name, the rest of the info will tell you. I also displayed the ID in the Dues layout for a quick check, but any other information can do this job either.
I deleted you "check" script as it could not work.
getting info from related records when you can't use looked up data is not done this way anyway, simply use
set field [local name] = [related_table::related_fi eld]
the file back:
https://filedb.experts-exchange.com/incoming/ee-stuff/6708-njmd.zip
I did:
- changed the link for using IDs only
- created a fullname field to reduce the identity to a single field to have them both in the popup menu (next)
- created a new list for the popup menu to show first and lastname, but insert the ID field.
and that's all...
If you come across dups using last + first name, the rest of the info will tell you. I also displayed the ID in the Dues layout for a quick check, but any other information can do this job either.
I deleted you "check" script as it could not work.
getting info from related records when you can't use looked up data is not done this way anyway, simply use
set field [local name] = [related_table::related_fi
the file back:
https://filedb.experts-exchange.com/incoming/ee-stuff/6708-njmd.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yes it works
i am new to filemaker but have some previous experience in borland c++
i havent found a good book on it yet, it seems the documentation ive seen so far
isnt that good
thanks for the answer!
i am new to filemaker but have some previous experience in borland c++
i havent found a good book on it yet, it seems the documentation ive seen so far
isnt that good
thanks for the answer!
c++ does not really help for filemaker I am afraid. some sql or php would be closer maybe...
and about books, I can't recommand anything since I never read one since V4, but I heard that criticism quite often, especially since v7.
I remember the v4 filemaker original book was very good, I never needed more.
But as this cost is important, they probably cut it down as usual.
and about books, I can't recommand anything since I never read one since V4, but I heard that criticism quite often, especially since v7.
I remember the v4 filemaker original book was very good, I never needed more.
But as this cost is important, they probably cut it down as usual.
ASKER
ill figure it out, ive been learning some cs3 flash too and dreamweaver cs3 but i seem to like this better than MS access
c++ is very different a lot more base level
but i see what you did and made a few changes already
im sure i will be asking a few more ez questions
again thanks for the help
c++ is very different a lot more base level
but i see what you did and made a few changes already
im sure i will be asking a few more ez questions
again thanks for the help
simply create the req. fields in the due table and make them auto-entered type/look-up, from the relationship dues/membership based on the ID + field which contains the info you wanna get into the due form field(s).
if not clear, post your file, I'll make it to show you.