trouble tracking down $$sc_FieldForContactID failure
2 posts
• Page 1 of 1
Posts: 7
Joined: Wed Aug 18, 2010 8:46 am Location: Bonny Doon CA |
I've looked at every field setting and name on Source No 1 (only one) studied the matrix of variables best I could: LayoutObject/Names= Let ( [ desiredobject = "SourceContactID" ; valuenumber = PatternCount ( Left ( $sc_SourceObjectNames ; Position ( $sc_SourceObjectNames ; desiredobject ; 1 ; 1 ) ) ; "¶" ) + 1 ] ; $sc_SourceObjectNames= Substitute ( LayoutObjectNames ( "" ; $sc_LayoutName ) ; [ "<¶" ; "" ] ; [ ">¶" ; "" ] ; [ "¶¶" ; "¶" ] ) sc_FieldForContactID If ( GetValue ( $sc_SourceObjectNames ; valuenumber ) = desiredobject ; GetValue ( $sc_SourceFields ; valuenumber ) ; "" ) ) amazed it just quit, probably with some colon missing or some such. any advise on plan of attack ... I'm miffed. |
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am |
Hi Tom,
Thanks for the screenshot! It looks like the contact id that you've mapped on the Contacts tab of your Source No 1 layout is incorrect. That should be mapped to the contact id field in your EVENTS table: something like SampleEvents::id_contact. (Where "SampleEvents" is the table occurrence upon which your Source No 1 layout is based.) It should not be pointing to the contact id field in your contacts table, which is what it looks like is going on in that screenshot. So I'd head over to your Source No 1 layout, go to the Contacts tab, and double click on that contact id field: selecting a field from the local table instead of from Contacts. Hope that helps! - John John Sindelar
SeedCode |
2 posts
• Page 1 of 1
Return to DayBack Calendar for FileMaker
Who is online
Users browsing this forum: No registered users and 3 guests