Split same fields into two seperate tables?

G

Guest

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?
 
G

Guest

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
Linking Two Tables 2
Naming Two Fields that aren't *Quite* the Same 2
Linking several tables to one table 3
Seperate AddressField into two fields 2
multiple tables with same fields 5
Table Structure and Related Form Design 10
How do I merge two access tables into a new table 1

Top