I have two tables. One listing the various Exchange rates between the Euro and Sterling. The other a list of Projects.
I have designed a form for the Projects Table which has a Project Budget which is entered in Euro. As I enter these values I want them to calculate the Sterling Equivalent and drop it into the appropraite field.
Two Questions:
1. How do I get the Projects Table to reference the Exchange Rate Table, pull out the rate of the day and enter the Sterling Value.
2. How do I prevent all records being amended whenever a new rate is set.
Thanks for any assistance.
I have designed a form for the Projects Table which has a Project Budget which is entered in Euro. As I enter these values I want them to calculate the Sterling Equivalent and drop it into the appropraite field.
Two Questions:
1. How do I get the Projects Table to reference the Exchange Rate Table, pull out the rate of the day and enter the Sterling Value.
2. How do I prevent all records being amended whenever a new rate is set.
Thanks for any assistance.
