Question How to record multiple record in one go

[sohailcdc]

Hi there
I am using access around after 15 year, now I am trying to build small databased for my budget purpose

Here is the situation example
FY2013 = Total working days
Period 1 = No of working days & expected Exchange rate
Period 2 = No of working days & expected Exchange rate
so on........
Period 12 = No of working days & expected Exchange rate

Now once i done - I want to save all record in single go, plus since this budget - total working days can't be change therefore, to avoid any error made by someone, i would like to save Total working days = (Period 1 ++++++++ Period 12)

Thanks for your help in advance

 

[Steve C]

Hi Sohailcdc

I am new on here too, so my answers are a bit flakey,

Period 1, Period 2, Period 3, - are they seperate fields? or three entrys (1,2,3) in a Period Field?

Is the maximum Periods 12? or an infinate number?

You might want to seach on DB Normalisation.
And
1 to Many Relationships

It's all on here - once you get your head around it, it'll be okay.

Not sure why multiple records need to be stored at the same time. I think access does things one thing at a time (sometimes it does them only miliseconds apart - but still just one at a time)

Best wishes


Steve C