That looks like it might work but I would make the relationship between interest keywords...is that right????
I have not really played around with this program and feel a little like a fish out of water, so your quick response is fabulous. I will give it a try and post how I go!
One technique that is unique (as far as I know) to Filemaker is called the multi-value key. If you place a series of keywords in a text field, separated by carriage returns, you can use this field as a key field in a relationship and the database will match values in the related table as follows:
Main table Key field values
Record 1: banana
Record 2: Cherry
Record 3: Kiwi
In this example, your record in the main table will match Record 1 and Record 3 but not record 2. There are a variety of ways to load your keywords into text fields so that they can be used in this way.
Thank you...I am going to work on it today so I'll let you know how I went....
So on the contact page I make fields - interest1, interest2 etc.....and then on the grant body page the field/s interest1, interest2, etc...???
"So on the contact page I make fields - interest1, interest2 etc.....and then on the grant body page the field/s interest1, interest2, etc...???"
That's a lot of work in the wrong direction. You are placing multiple values in the SAME FIELD.
Type in text, hit return to start a new line, type in text hit return to start a new line, etc. Do this all in the same field.
I suggest describing what you want to do in more detail first. There are several different methods for implementing this approach, as well as some ways to avoid having to type everything in, but I can't describe how to do this without a clearer picture of your database and how you want to set this up on your layout.
Ok....I am very new to this and the terminology so thank you for taking the time to understand, I appreciate it.
Bascially, I am trying to set up a database for another lady to use. Her job is to have an updated profile for all the academics, in particularly their research interests. She basically needs to help to those academics find grants that relate to their research interest areas. She also needs to find community bodies that might be interested in engaging in research with them.
What I was trying to set up for her was a database/s where she complied profiles on academics, grant bodies and community bodies. The idea was when she entered the academic's research interest into the field she could see what grants and community bodies would be the best for this person. She would also like to be able to see when the grant submission dates are due so she can 'nag' the academic to get their submission in.
Does this make sense?
Quoting from your original post: "Similarily, I wanted to connect appropriate community groups (database) to the interest keywords, so this list would also be generated on their page."
"Connecting to the interest keywords" is where this multi-value approach might work for you. If you have a list of keywords in a field in a record from one table, you can build a relationship to link that record to multiple records in another table. This is not the only approach, you could also construct a Join table that works the same way.
Before you get all involved in such programming details, though, you need to plan out exactly how you need to organize your data. How many different tables of data will you need and how do they relate to one another? That's a very difficult question to answer for you via this forum. You may want to sit down on draw up lists of typical information you plan to put into your database. Each list may well become a separate table in your database.
Since you describe yourself as a "newbie", you may want to spend some time learning more about databases in general and Filemaker Pro specifically. There are books and tutorials that can assist you in acquiring this information. If you take the time to study up, it'll help you better make sense of the help offered to you through this forum.
Other people, when confronted by the need to design a new database like this, resort to hiring a consultant to make sure they get a design that meets their needs.
Thank you...I have only ever used a filemakerpro database after it has been set up. I will go back to the books and take into account what you have said and have a tinker. We do not have any money for a consultant so I will just be persistent until I get it!
Feel free to keep posting questions to the forum. Any additional info that you pull together through books and tutorials will enhance your understanding of what you see here.