I'm using 4.1 and am very new to this (about 1 week - boss gave me the book, Filemaker for Dummies and said "go"). I am setting up a database at work with our client profile and contacts. I need to log in every time a client contacts our agency so I put in a date field (entitled "date") and made about 50 copies of it (ie. "date copy", "date copy2", etc) for up to 50 contacts per client. 1) I don't even know if that is correct or not.
2)Now I am trying to figure out how I can do a search to find out which clients contacted us, for example, in December 2000. Since I have 50 separate date fields, I have no idea how to go about writing a script that will do this.
Help! I'm failing miserably!! Thanks in advance.
