Spirodoc Posted October 11, 2006 Posted October 11, 2006 I am trying to develop a DB using FMP7.0 which will allow me to select a template of text with the use of a button. I have probably 20 different templates I need to be able to select from (1 per occurence) and have them displayed in a text field. I can't seem to get around this in terms of setting up the file. Any help is appreciated!
Inky Phil Posted October 11, 2006 Posted October 11, 2006 Hi Spiro and welcome Set up a seperate table with only one text field per record. Create 20 records and store your template texts in there. Create a relationship between this file and your main file. Make it a cartesian relationship (ie match any field to any field and use the 'X' operator in the relationship graph). This relationship is created simply so that you can view these template records from your main file. Now in your main file you need to create a portal that shows records from this relationship and place the text field from the template file in the first portal row. Also place a button in the first portal row. Now whichever record you are on in the main fle you should see a full list of your template texts. This explanation is now getting a little long winded so I have decided it would be quicker (and probably a lot more helpful) to do a dem file. See attached and hope it helps. If you need any further help get back to me Phil template_example.zip
Spirodoc Posted October 11, 2006 Author Posted October 11, 2006 Phil, Thanks! That is exactly what I was looking for. Couldn't get the "old noodle" around it. Your help is appreciated tremendously! Spirodoc
Recommended Posts
This topic is 6676 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now