Table normalization

[patriot76]

Anyone can direct me to place the following fields into different tables. I currently import all this info from an Excel spreadsheet.

Here are the fields: Record No., datarange, picker-nbr, picker-name, tt-picker-piece, cust-pieces, invc-pieces, invc-date, group, load, batch, pieces, item, description, slot, reason, cust-nbr, and invc-nbr.

Thank you
Patriot76

 

[Banana]

Will you use it to store orders for your firm?

If so, I suggest that you take a look at Northwind database, which comes includes with Access or sample ordering databases either on this forum or from Mircosoft. Take a look at how the tables are arranged and related and you'll get a good idea how data are normalized.

 

[patriot76]

Table

Banana

I records will be stored, these records are slot replenishment.

I'll take alook at the Northwind database.

Thank you
Patriot76