hello

I am new to filemaker. i have a user database and DVD collection database. A user wants to add some DVD's as his favorites. how should i implement ?

Pls help me.

Bye

Geethanandh

If there are many users (and everyone could have his own set of favorites) than you'll need an join table UserFavorites with user_ID and DVD_ID which would contain all favotite DVDs for every user.

Now in your user DB define an value list say myDVDLIst (after defining an relationship say myFavorites with join file thru User

hi djgogi

Thank you for ur reply. I dont have any portal relation between user and DVD database. My user database(300 records) has only iser details and dvd database(1000 records) has details only abt the dvd's. How do i link both of them.

"Now in your user DB define an value list say myDVDLIst (after defining an relationship say myFavorites with join file thru User

This can be done without a related file. You will need a Text field (lets call it FAVLIST) and a global text field (Lets call it USER)

Ok, step for step