kmac Posted June 18, 2006 Share Posted June 18, 2006 I am a total newbie when it comes to FMP, but I want to create a database (or set of databases) to keep track of my genealogy research. There would be a main database that would hold all the fields necessary for what I want to keep track of. I’m not sure if I will need to create other databases with relationships back to the main research one OR if Value Lists (editable) in the main research DB will be sufficient. So, my qustion is this: If I create a Value List for a certain field in the main research DB, say, Locality, and enter in about 100 entries, does that have any adverse afffect on performance in FMP? Would a better option be to create a separate database for Localitys and enter these 100 in that and create a relationship from that to the Locality field in my main research database? (I hope I’m using the correct terms here.) I have a lot to learn about this fabulous program. I have been practicing, doing tutorials, reading, etc but have not created my first database yet. Trying to get myducks all in a row first. Thanks for any help! Link to comment Share on other sites More sharing options...
Genx Posted June 18, 2006 Share Posted June 18, 2006 Play play play, pull things apart, blow things up, its all good - welcome to the forums. As for your question in terms of value lists... i use ones attached to the values of fields all the time. The only "adverse effects" that i find it has is maybe a 1 sec delay (in custom web publishing or instant web publishing only keep in mind not over a lan). I have around 2000 entries in this value list and use a drop down list with auto complete enabled to help filter the list. Point is, no there are not really any adverse effects from my point of view. Hoped this helped, if it didn't feel free to say so and post again. ~Genx Link to comment Share on other sites More sharing options...
kmac Posted June 18, 2006 Author Share Posted June 18, 2006 Well, thanks. I think that did answer my question and gave me the go-ahead to create these long value lists (although, not as long as yours! Kmac Link to comment Share on other sites More sharing options...
IdealData Posted June 19, 2006 Share Posted June 19, 2006 Although FMP will happily support very long value lists bear in mind that it's a human using the computer. Link to comment Share on other sites More sharing options...
Genx Posted June 19, 2006 Share Posted June 19, 2006 Hence why we use auto complete :) Link to comment Share on other sites More sharing options...
IdealData Posted June 20, 2006 Share Posted June 20, 2006 Can't say I'm a lover of auto complete functions - you'd be amazed at how many mis-directed e-mails are sent from e-mail packages. Link to comment Share on other sites More sharing options...
Genx Posted June 20, 2006 Share Posted June 20, 2006 What do you mean? How are they misdirected? Link to comment Share on other sites More sharing options...
IdealData Posted June 20, 2006 Share Posted June 20, 2006 We're dealing with humans here, the computer is never at fault and will do only as instructed. Don't wory Genx, when you've as many miles under the belt as me you'll understand. Link to comment Share on other sites More sharing options...
Genx Posted July 3, 2006 Share Posted July 3, 2006 ... Really, i thought auto complete reduced the possibility of error. Oh well. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6501 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