New TFP User from FM

[David Kramer]

Question to Brendan Duttridge – On page 66 of the TFP manual shouldn’t this link to the Client Expenses form NOT the Client Call Log?

GENERAL QUESTIONS

(1) Field Types: What is the difference between TEXT field and NOTE fields. Can Notes fields be searched? What is the specifications in terms of number of characters for each?

(2) Check Box. On my FM database I have Boolean fields. In FM they are either 1 or 0. Then in the layout I describe what the meanings are for 0/1. In TFP do I import them as numeric and can I then convert to a Checkmark. How? Or do I leave them as numeric and maybe a pick list will format numeric into correct items or checkmarks?
Any ideas are welcome.

THE FOLLOWING WAS A QUESTION I WAS GOING TO POST – BUT I THINK I HAVE A SOLUTION:

3)on my FMDB I have 4-tables. Each one has a unique ID. I have exported them from FM as Merge files and massaged in Numbers. I have renamed the FM IDs as -rec_Form_Record_ID and imported as type=numeric.

Three of the FM tables imported (mostly) correctly but one table reads only 2 records and stops (ignores 150+ records). In Numbers I deleted the first 10 records thinking there was something there causing problems but TFP still only reads 2 records.

Then I had an idea. I opened the merge file in Excel. Saved it as CSV; changed the name. AND TFP imported ALL the records.
There was a small problem in that TFP created additional records with field information out of order. However those were easily deleted.

4) so I have imported my FM data. In each record there is rec_Form_Record_ID. I then redefined the child record id as Link-To the appropriate child record. Moved the link-to field onto the layout. I expected to see the child-records in the parent record. But I Do Not see the child records automatically. I do see the child records if I choose “Select existing linked records.” And manually link them. But not automatically based on stored ID values.
Note: The import data prefaced the id fields with -rec_Form_Record_ID which I changed to Form_Record_ID once it was imported.

5) In FM I used a starting value which is different for each table. Since I already have unique ID numbers how do I specify the starting ID number in TFP (starting from the last number ID used and then use an increment.

6) after a lot of trial/error I was able to format field names and values (stroke/fill). But I could not get TFP to format a button I added to my form?

7) I’m asking a favor. Can someone write a script for me that when runs opens a layout (1) within this form and or (2) opens a form in a different form. Once I have that as a template I’m sure I can figure out other buttons I need. Thank you.
Forms:
– Form1
– Form2
– Form3
Layouts I created:
– General
– Instructions
– Expenses

Example: From the General layout the user may want to go to the Instructions [button] layout which is within the same form or may want to go to the Expenses [button] layout which is in a different Form.

Thank you all.

[Brendan]

Hi David,

I answered your questions answered via email.

Thanks,

Brendan

[Author]

Posts