Tables

G

Guest

I have one table with 31 fields. What is the easiest way to break out or
optimize the tables? See example below.

Fields in one table:

Item Description
Part Number
Serial Number
Type
O/H QTY
Unit of Issue
Location 1
Location 2
Origin of Receipt
Rec #
Initial Qty Rec
Initial Receipt Date
Disposition
Issue S/N
Issue Qty
Shipping Date
Receiving Date
FedEX Tracking Number
UPS Tracking Number
Other Shipper Name
Other Tracking Number
Document Number
Requesting Activity
Remarks
Active
Reason for Issue
Notes
Contract Number
Shelf Life
Alternate P/N
Hardware
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

H E L P - Problem with 'related' table - no new record is created - why ? 2
Won't let me complete new [Order_item] recordn ?? 1
How to design relationship between tables 1
Access 2000 Set-Up Question 4
Design issues 2
Updating Table with another tables values 6
creating a query from two tables 2
Create a lot # and store it in an indexed – no duplicates field ? 2

Top