Advice on db set up (1 Viewer)

[twoplustwo]

Morning all,

I have a small project to set up a db to record the decisions of a tool we use for within day, D+2 and D+2 forecasting.

Would it be more prudent to set up a table with these three fields in or just have one field for "decision" and two date fields i.e. "RunDate" and "ForecastDate"?

If the latter, which I think is normalized, I would need to be able to add 3 records at a time for each forecast.

My following question then would be what is the most effective set up to allow a user to enter three records on a form?

Thanks for any advice.

 

[neileg]

Yes, the second option is best. Join the tables together in a query and base the form on that.

 

[twoplustwo]

Hi Neil,

Thanks for the reply.

I now have a form based on a query etc.

I am having a bit of trouble creating 3 records at a time. I think I need subforms.

I have a thread in the "Forms" forum for more info!!

Thanks again.