0 Replies Latest reply on Oct 27, 2010 10:55 AM by LiamCarter

    Two Databases one field in layout



      Two Databases one field in layout


      Hiya Guys,

      This is my first post so please bear with me.

      Here goes

      i have 2 database's, 1 - Database A (FileMaker database) & 2 - Database 2 (an external MySQL Database)

      I have imported 1 field from a table DB2 called ID into a table DB1 called EXTID this is performed regually to keep the ID's up to date

      Both databases have fields for Name, Address, etc...

      DB2 is Read only

      I have a field in a layout called Field 1.

      I need to do following:

      When a record loads:

      If table from DB1 has a value in EXTID then display the data from table in DB2

      If table from DB1 doesn't have a value in EXTID the display the data from table DB1

      I have managd to do this using a calculation field with the following command

      If ( not IsEmpty ( localtable::EXTID );
      GetAsText ( externaltable::first_name );
      GetAsText ( localtable::FirstName )

      This works perfectly with one exception. I need to be able to edit the data if EXTID is empty.

      i.e. if the data is being displayed from the local filemaker database

      Sorry if this is vauge.

      Thanks for help in advance and please ask for any more infomation and i will reply asap



      Just as an extra note.

      What i am looking to do as such:

      When a record loads i want to be able based on the value in the EXTID change the "Specify Field"