I have a form wherein there is a currency exchange rate, the fields are as follows:
Form 1
1-ID - Autonumber
2-Company Name
3-Currency
4-CurrencyRate
Form 2 (this is a breakdown or list of purchases)
1-ID-Autonumber
2-Form1ID-to connect to Form 1 ID
3-Quantity
4-CostPrice in EUR
5-CurrencyRate-will be taken from Form1
6-Total cost=quantity * (#4/#5)
I need that the currency rate in form 1 appears in form 2 for the number of lines they will enter.
How can I make this appear in form 2.
Thank you again for your assistance.
Trident
Sample: USD1.00 = EUR1.35
The fix number is the USD and the EUR can change to any currency.
I also have a subform inside this form.