mardi 3 mars 2015

Microsoft Access: Is this the best way to build this form / database?

I am building a database to record job details for a printing press:


Here is a picture of the form: http://ift.tt/1DHAqR1 Yellow = Main form, Blue = Sub Form (Each print station is a seperate subform, 10 total)


Here is the table design: http://ift.tt/1EgCmUs PrintJob = Main form, PrintStation = Sub forms


So basically, this form can enter as much as 11 records into the database when it is ran. I am finding it a little hairy to link all of the subforms to the main form properly, so before I waste too much time I was hoping someone could give an opinion on whether this is a good way to build this form, or if there is a more optimal way to get this done.


So far it has been really frustrating...


Aucun commentaire:

Enregistrer un commentaire