Breaking Up Table in ER

[Drunkenneo]

I have a situation where i need to import a table in Access which is in Excel, After importing i need to know how can i break it up differently keeping relation of FK and PK intact: For Eg


Excel Sheet:

Name Biz ID Biz Name Address1 Address 2 Address 3 OrderNo Order Date


Person Record
ID(PK) Name Biz ID Biz Name Address 1 ....

Order Record
OrdIDPK ID FK OrderNo Order Date

How can i distribute it?

 

[jdraw]

I would work with a model similar to the attached.

Good luck.


After posting, I found this has been cross posted.
http://www.accessforums.net/programming/breaking-up-table-fk-pk-39754.html

Please advise readers and include a link when you cross post.