Relationship problem

R

Rock

HI,

I have created a dbase table with the following fields..

Store Name
Contact
Address
City
State
Zip
Phone
Fax
Email
Web

I now need to create another table that will record the dealing we have
with the store but the more I try to strat it the more confused I get
with this relationship thing.

I need these fields in this Tracking table..

Date Sent
How Sent
Type
Details
Response

Of course this table will have many entries to the one of the first
table. That's when I get stumped.

Can anyone give me a clue how to set the relationship up. Slso is this
called a One to Many relationship ?

Thanks

Rock
 
G

Guest

hi,
looks like you need a new field in your first table.
Store ID. make it something unique.
then add a store id field to your other table.
that would be your relationship. this would be how you
link the 2 tables in queries.
 
Top