Relationship issues

[James]

Hi as for the more information ok here goes....

Basically I have now set up my One - To - Many
relationship from tblMP3List (The main Table) to
tblMP3Title (Which has the MP3 Titles in)... To get the
data in the tblMP3Title do I just copy it over?

Also when I am adding data into my form (based on
tblMP3List) so when I add data it comes up with the Title
of the MP3 in the relevant field and then one of the
titles I put in the list... How do I get it to place
another record in the table? plus it dosent puit the
record in the tblMP3Title so the title is not going in
there?

I have the following in the tables:

tblMP3List

MP3Title (Text Field)
MP3TitleID (AutoNumber) (Key Field)
MP3's on CD (Text Field)

tblMP3Title

MP3Title (Text Field)
MP3TitleID (AutoNumber) (Key Field)

Joined in a One - To - Many Relationship joined by
MP3TitleID in both fields.....

Many Thanks

James





How do I get this to work?

I have done this but it says the relationship is one - to -
one...

This suggests that the field to which you're linking in
the Folders
table has a unique Index, such as a Primary Key. Make sure
you're not
linking to the Primary Key; if you're not, check the
Indexes on the
table and make sure there isn't a unique Index on the
field.

How do I get it to be a one - to - Many relationship...
plus I have done the tables as you requested... I have no
data in my new table is there a way that the relationship
pulls the records across...

That's NOT HOW RELATIONSHIPS WORK.

The whole *point* of a relational database is to avoid
redundancy,
thereby avoiding redundancy. A relationship *prevents* you
form adding
"orphan" records, e.g. folders which have no valid Title;
it doesn't
automatically add new records to the related table (and
you wouldn't
want it to do so!)

If you could explain a bit more about what these two
tables are and
what you expect, someone should be able to clarify how to
do what you
want.