split the table

F

flow23

I have a table with 7 fields in it. ( Name, Postcode, member ID, payment,
method, amount,etc)

A person would have made payment many times, and for which there would be a
record in the table.

I want to split the table in two..

First one.. only unique entries (only once name, postcode, and ID) and the
other as a link with all payment info)

There is no unique autonumber or anything.

How can I do it?
 
D

Douglas J. Steele

As you've already suggested, one table would have the details of the member
(Name, PostCode, Id). The other table would have the Member Id (assuming
that's the Primary Key to the table) so as to be able to link it back to the
first table, plus Payment Date, Payment Method, Amount. You'd have one row
in the second table for each payment. The Primary Key for the second table
would likely be the combined fields Id and Payment Date.

Jeff Conrad has a lot of good resources for Database Design at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101
 
Top