FMN

Works - thanks so much.

Thank you, will give a try. Btw, I do not have any "/" in my field names! (They are actually just 'Prov' and 'ProvAbb' - phew).

Hello, In the address section of my database, when you select either Canada or USA it provides a list of relevant ‘Provinces’ or ‘States’ in the Province/State field. Currently the provinces/states are written in full but I would like that once a selection is made, the field automatically inputs the abbreviation - ex. someone selects ‘Saskatchewan’ and it auto-enters/replaces it to ‘(SK)’ on commitment. I managed somewhat to achieve this using the substitute function but only for one entry, I was not able to enter multiple substitutions – ex. Substitute (Province ; “Saskatchewan” ; “(SK)”). Is there a way to enter multiple substitutions as a conditional value? Is this the best way to go about it? FYI, my address section is linked to conditional value lists with the following fields: Country (list of countries) Prov/State (list of provinces and states) Prov/StateAbb (list of provinces and state in abbreviated form) Thank you in advance for your help!

Thank you

Hello, Is it possible to import field names (from Excel) into an existing FM database? I previously imported field names from an Excel worksheet (File – Open – select Excel file – select worksheet – select ‘Field names’ from first row option panel – and FM converts file into an FM database). I would like to add new field names without having to type them in manually, however I cannot use the same method (FM writes over my previously imported field names). Is it possible to import additional field names from an Excel worksheet into an existing FM database? (Using FM Pro 13 / OS Windows 7) Thank you!