Different users should use one DataBase.

[glzm0]

Hello guys!

I plan to make my own DVD-archive.

Please don't discuss like: "... there are good solutions outside ..."

I WANT to make my own one .

OK now my problem: How should I solve the problem if more than one user is using this application (database)?Yes they can work at the same time on the same Database, but I think that would never happen

Following I planned before: One file; 1xUsertable; 1xMovietable; 1xMaintable

the movietable contains all DVDs. the maintable contains calculations and some variables.

And now the usertable? I don't know if I should make FOR EVERY USER A OWN table, or should I put ALL USERS IN ONE table.

Is it possible to create a new table with the filemakerscript or applescript funktion?

thx for every answere.

sorry for my bad english. I hope you'd understand what I want from you

[David Holmberg]

You don't need more than one usertable, create a record for each user in the table.

Then you don't need that script.....

[Ender]

What are you tracking about the movies that's different for different users? It seems the DVDs themselves will have information that's the same no matter which users happens to have it in their collection.

It looks like your structure should be something like this: A Movie table, a User table, and a User-Movie join table which allows multiple users to have the same movie. This join table can track other details that are specific to each User about the movie, like the Rating (four out of five stars, etc.)

[glzm0]

that's the way I would solve the problem.

[transpower]

I'd recommend that for clarity you change the names of your tables to:

User, Movie, UserMovie (the join table). Each record in UserMovie will have one user and one movie title.