November 1, 200619 yr Hi there (I think this in wrong section... is posable some one can move it) I have this problem..... With setting up Combo address field for my "Job instruction" layout and print instruction layout What I trying to do is set up combo delivery address field pop up menu and draw data from any of my client postal address in the "Job instruction" layout But when I try to do this get pop up dialog box saying "This action cannot be performed because this field is not modifiable" I can get a combo field to show the address of the "who" the job instruction is too, but I need to select a postal address from any of my clients from a list Attached is a clone of the database Does any one have throughs on this? It great hear from you Cheers Damian BD_job_tracking_test_v5clone.fp7.zip Edited November 2, 200619 yr by Guest wrong section
November 2, 200619 yr Why do you want a lookup. Shouldn't the address automatically populate the field? Your goods delivery address should reside in clients then by going to your shipping/Job Instruction layout the data will already be there. You do not have to let the user chose anything. Please see attached for changes. See attached. HTH BD_job_tracking_test_v3Clone_Copy_1.zip Edited November 2, 200619 yr by Guest
November 2, 200619 yr Hack you have the value list attached to a calculation field. You cannot change the data directly into a calculation field. You need to have the value list as a pull down attached to a text data field.
November 2, 200619 yr Author Hi John thanks for your reply I through I needed to create an combo calculation field as the postal address is spread over three fields?? How do you get them all three of them into one Pull down list, so I dont have do three separte pull down list of the postal address fields Cheers Damian Edited November 2, 200619 yr by Guest
November 2, 200619 yr Author By the way aldipalo I tryed look at the attached FMP file but it was old version of my database? and with no changes not sure whats going on here Cheers Damian
November 2, 200619 yr Damian, If you try and use the field 'Combo Postal address' as the field of reference in your value list it will not work properly because of the paragraph marks, it will essentually add them to your value list. Consider creating a new calc field with commas instead of the pilcrow (paragraph) symbol to use in your value list. Then attach the value list to a text field. Also I did notice that your calc field 'Combo Postal address' is set to result in a number and it should actually be set to text.
November 2, 200619 yr Author Hi john I made the changes to database but I still getting this error coming up?? any ideas? may be I not getting the ideas about "Then attach the value list to a text field." please see attached file for changes I have made thank you for your time Cheers Damian BD_job_tracking_test_v6clone.fp7.zip
November 3, 200619 yr Author Hi there aldipalo thanks for up loading the file, yes i have managed to do the same thing at my end the only problem is what if the delivery address is different to the Client postal address What I am wanting to do is use any postal address on my client list, is this possble with pop up combo list thanks very much for you time Cheers Damian Edited November 3, 200619 yr by Guest
November 3, 200619 yr Please explain, are you trying to have a value list where there are several different fields, e.g. ::Contact_Address; ::Shipping_Address; ::Mailing_Address showing in one drop down field? I'm not sure if that can be done. Al An After thought - Check this out by GenX. You may be able to incorporate this into your app and get the results you want. http://fmforums.com/forum/showtopic.php?tid/180278/post/225526/hl// Al Edited November 3, 200619 yr by Guest Just an after thought.
November 9, 200619 yr Author Hi Al Sorry I have not got back to you... I have been away on the road and not near a computer.... But I have had time to think what I am trying to do. What I am trying to do.... I have two different layout tables, one print instructions and the other job/memo instructions etc. Within the print instructions I have proof delivery and final delivery addresses. These addresses can be different as there can be multiple people involved in the project, so what I am trying to do is use any of the addresses in the client list for delivery address not just related to this particular project. Hope this helps on the description of what I am trying to do. Cheers Damian
Create an account or sign in to comment