Update Three Tables with Single Form (1 Viewer)

[karl009]

Hi,

I have three tables;

tbl_Exchange_Rates_CI
Currency, RatesCI

tbl_Exchange_Rates_MU
Currency, RatesMU

tbl_Exchange_Rates_PS
Currency, RatesPS

They all have the same data but each have one different felid, is there any way that they can all be updated at the same time?

Thanks

 

[ghudson]

Sounds like your data structure is not normalized. Fix that and the rest will be easy.

 

[Simba]

Karl!

I think you could do this way but still I am also on learning stage.

tblExchangeRate
RateType,Currency

tblRateType
id, description

Then if you create the relationship, you might get the values.

Anyone here to tell, if this is correct.

 

[karl009]

Hi,

Simba your idea dose sound good...

Could you link the tblRateType to three felids in the same table, this is why I made three tables.

Each one can use a different currency and when I do calculations the one table with the relationship can influence all the calculations even when one is in Pounds, the other Dollars and another in Euros.

Can be messy...

I will give this a try but I will still need three links between the two tables, will this work?

Thanks...