Two Database once Field

[ibizamale]

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

Regards

Ibizamale

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"

Cheers

[Cabinetman]

May not be the best solution but here's what I use quite a bit...

In layout mode put the "EXTID from table DB1" field on there so that it is BEHIND the Calc. field. Then set the calc field up as a button and tell it to go to the DB1 field.....

When you click on the calc field in browse mode it'll allow you to enter the data and the calc field will display it after you exit the field.

Edited October 27, 2010 by Guest

[ibizamale]

Then set the calc field up as a button and tell it to go to the DB1 field.....

Ok sorry to be dumb, how can i achive the above

Cheers

[Cabinetman]

Ok sorry to be dumb, how can i achive the above

Cheers

look at this........ gotta go but I'll check in again when I can

calc.zip