linking data

[basilyos]

hello guys

i have over 3000 movie and i'm making them a database

everything is fine

but i have an idea when i double click on any movie to see the info i created a subform where he will list all the movies linked to this movie

for examle if i double click on lethal weapon 01

i will get the information about lethal weapon
and in the subform i will see
lethal weapon 02
lethal weapon 03
leathel weapon 04

to do this i'm entering the id of the first movie and the other one


for example
M_ID - M_Name
1 Lethal weapon 01
2 Lethal weapon 02
3 Lethal weapon 03
4 Lethal weapon 04


in the link table i will have

M_ID1 - M_ID2
1 - 2
1 - 3
1 - 4
2 - 1
2 - 3
2 - 4
3 - 1
3 - 2
3 - 4
4 - 1
4 - 2
4 - 3


i will attach the database

but my question is could i do this in other solution more flexible

 

[Minty]

No - I think you have the data layout spot on. There are other ways but they cannot be any more efficient. (IMHO obviously )

 

[basilyos]

Minty thank you for you response but i find a way
i create a new field in movies table named (movie_series)
in that field i choose from combobox for example saw for all saw series

and the subform source it will be the movies table


and the link Master and child will be the movies_series

and voila it's done

 

[Minty]

Sorry I assumed you wanted a separate table, but yes you are correct self-referencing is the other route to go, if not a little more complex to program around.

 

[smig]

If you only want to link for series your second solution is good.
As general I think your first way is the correct one.