Newbies geethanandh Posted August 12, 2002 Newbies Share Posted August 12, 2002 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 Link to comment Share on other sites More sharing options...
djgogi Posted August 13, 2002 Share Posted August 13, 2002 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 Link to comment Share on other sites More sharing options...
Newbies geethanandh Posted August 13, 2002 Author Newbies Share Posted August 13, 2002 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 Link to comment Share on other sites More sharing options...
Rigsby Posted August 14, 2002 Share Posted August 14, 2002 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7918 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now