Jump to content
Sign in to follow this  
geethanandh

favorites

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.