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!

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

Phil,

Thanks! That is exactly what I was looking for. Couldn't get the "old noodle" around it. Your help is appreciated tremendously!

Spirodoc