Lookup Calculation?

[sullyman]

Don't know if this the right section to post so please forgive me if it is.

I am currently reading data from SQL tables and inputting data back to SQL from my FM Frontend Database.

I have come across perhaps a simple issue (maybe not) that i would like to achieve.

In SQl, i have a table full of Vendors.

In my FM Frontend, i am reading another SQL Table Full of Products for example. I also have three fields in here available to fill in Vendors information (Vendor; Vendor Address; Vendor Telephone). I would like to perform a lookup on the existing SQL Vendor Table to accomplish this (i.e if i lookup a Vendor Name from the existing SQL Table, it will fill in the three fields for me automatically)

I have read up on ESS on this forum and learned that lookups on an SQL Table were not possible and available through ESS. So i created a temporary Table in FM to import the Vendors Information.

I can now perform a lookup to get the Vendors Name from a Drop down list but how can i now get the Vendors Address and Telephone Fields fill in automatically on the SQL Table.

I could create another drop down list for both fields but thought if i got the Drop Down Vendors Name field working, that it would populate the other two.

Is this possible with a calucation ? or is it possible at all?

Thanks

Edited February 6, 2008 by Guest