Hello all.

I'm fairly new to FM, so please forgive me if my question seems stupid.

I have a really huge database in FM 12 (let's call it FM1). I also have a FM file, which needs to see some fields from FM1 (let's call it FM2). It's all taken care of in relationship graph (FM1 as External Data Source). What I need is for the user of FM2 to be able to view data from FM1, without being able to alter it in any way. So far I came up with preventing the user from entering these fields in Browse mode, but that seems to me a bit unprofessional (and makes impossible to copy the field). And if it's a way to go, is it 100% foolproof?

The user will have to be able to edit, create and delete other records in FM2.

 

tldr: Is there a way of preventing making changes in External Data Source FM file?

You would control the Edit rights to any table using FM's Security and privilege sets.

I have a data separation model working:   main file  GBc.fmp and GB.data.fmp

  I need to change the names of these files (e.g. to reflect dates modified )

When I do that, I can't figure out how to use the 

   File / Manage / External Data Sources (menu item) to change the file path to the current ( new name ) data file

 

Driving me nuts!!

Hope someone can help

 

Jill

Just double-click the file path, or select it and click edit. Then I would suggest rather than typing the file name, use the Add File button, which will then prompt you to select the file.