Question database and form Design - approach

[SantoR]

there are different users....for each user i will be storing these information on monthly basis
i have one main form from where user will select the month.
this will trigger a new form , where based on the selected month, number of rows will be shown (28/29/30/31)..
each row is basically represent a day and has partname, qty, arrival time.

for each user :
for first time--rows will be blank
for second or third..so on---- rows will retrieve data from main table

on submission
this all information goes into a main table.

how should i design this

problem : how to create second form ? and logic for multiple rows


should i use a dummy table with 31 rows and a continuous form

 

[Minty]

What data are you trying to store and what is it's purpose, and why have blank rows with no data if there are no records?

 

[plog]

Do not try and design forms and tables at the same time. Get your tables right first and foremost. Tables then reports then forms.

Read up on normalization (https://en.wikipedia.org/wiki/Database_normalization), run through a few tutorials and then layout your tables. I would open up Excel and make one big table with all the data you will need. Put field names across the top, then fill in a month or so worth of fake data to get an idea of what you need to capture. Then normalize that spreadsheet into the appropriate table structure.

 

[Simon_MT]

Plog,

Really good advice. I would add Tables > Reports > Tables.

Get your reports right even if it means going back and adjusting the tables. One-to-many start the report at the many and Group on the one.

Simon

 

[The_Doc_Man]

It appears you are trying to get to the design stage before you are quite ready for it. You might consider this "Old Programmer's Rule" - If you can't do it on paper, you can't do it in Access. Meaning you need to work out the program design before you ever touch a keyboard. Stated another way, that program design is your map. Without a roadmap, I don't know where you are going but the odds are you won't get there without a LOT of detours, double-backs, dead-ends, and excessive burning of that well-known commodity, midnight oil.