Is this possible? make a customisable relationship

[Enuma]

I have a Project table with many movies and a actors table.

I want to relat actors with movies with buttons.

So what i want is that the user being able to relat actors with movies freely.

[Osman]

you can defeine realtionship with a global field. and two button can be used to change value in global field. Button one sets global field as actor, and relationship shows actors. Button two sets global field as film, and relation shows film records.

osman cabi

[normanicus]

This will be a many to many relationship.

Assuming you have ID fields in each table you need just add a field to each table which will contain multiple ID fields of the other, each on a new line.

So, in the Actors table you will have a field containing the set of Movie IDs that actor is in.

Similarly, in the Movies table you will have a field containing the Actor IDs of actors in that film.

Make a relationship between these two fields.

Your buttons could work like this:

1. In the Movies table have a global field showing a drop-down of all actors.

2. Select an actor.

3. Hit the button to add the ID of the actor selected to the list for that movie.

Do similar for the Actors table but this time have a global showing the full list of films.

I hope I explained that OK,

Norman

[Enuma]

hmm how will these fields with the multiple ids be connected ?

and how i will show the records... in a portal?

[Enuma]

hmm i think i just realized how to do it..

but if i want to exclude an actor from a movie or a movie from an actor how will i locate the precise id and delete it?