Normalization & DB Design

[jepoysaipan]

Hi Guys,

I have a new task which is to design an order tracking for our company using the attached excel format.

Having hard time normalizing ang designing the interface since the user requested the form to be as easy as the excel since they are used to it.

You help is highly appreciated.

Thanks again & again!

Jeff

 

[Ron_dK]

Acces comes with a number of sample dbases.
Order entry is one of them. I guess that one might suit your needs. Just try it and take a look at how it is configured.

Hth

 

[jepoysaipan]

Hi Pat,

Thanks for the enlightenment, Believe it or not I consumed the whole day yesterday just trying to normalize the data but still can't get it to work plus the fact that I need to do some form design

I am really running out of time on this one and probably if I can't produce the result by 2 weeks I will just tell them to buy a software for the tracking of our PO, it just drained me for the past 2 days.

Thanks a lot.

 

[jepoysaipan]

Hi Pat,

Thanks for the encouragement, after so many hours here is what I have so far (pls. see attachment for details).

Please let me know what I messed up.

Thanks again.

Jeff