Split same fields into two seperate tables?

T

TKM

I have several fields with the same name in two seperate tables..example...PO
Number, RMA#, serial # etc.

The tables names are Shipping and Receiving. The shipper ships the item to
an address and then when he receives it he ships back either the full order
or only half of the order. Either way he uses the same RMA etc fields in both
tables. Is thier a simpler non redundant 3NF way of doing this?
 
K

KARL DEWEY

Use a single table with additional field to indicate coming (Receiving) or
going (Shipping).
 

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

Combine same fields into one table? 3
Two columns followed by single page-width column on same page 0
Linking Two Tables 2
Seperate AddressField into two fields 2
Two Tables with the same field name 2
Formatting: Putting Tables into Columns 1
Linking several tables to one table 3
Naming Two Fields that aren't *Quite* the Same 1

Top