(Originally posted in the wrong topic)
Hi everyone! I am very new to participating on this forum, but have been a voyeur for a while, and have gotten a lot of good information, but I am still a beginner in FM)
I am creating a database for a dating service. I currently have one table, it includes MemberID, MemberEmail and profile information (Most of which pulls from value lists).
My question has two parts.
1. I need to keep track of the dates that the members are sent on. One person can have many dates with different people. If I enter date information (time, place, comments) for one person and add the member they dated, I would like the same date place, time etc. entered as a date record for the second person. I shouldn't have to enter it twice (once for each person on the date). I don't even know where to begin on this one. If I add a table called dates, there would need to be two MemberID fields right? I'm a little lost.
2. I would like to be able to have filemaker make matches automatically based on the member's preferences. I have figured that I can make scripts for each member with their preferences, but I was wondering if there is an easier way?
Thanks in advance for your help. Please let me know if I need to provide any other information.
La Juana
