Welcome to the forum.
How much experience with designing databases do you have? You may need to invest some time in learing how filemaker works and how to design a database. This forum is a good resource. You may also want to acquire a book and/or some tutorials in order to learn more. In any case, be prepared to invest some time and effort in learning how to do what you want here.
"Should the sales tab and inventory tab be separate databases or should they just be separate Tables within my "Contacts DB"?"
I'd recommend keeping them in the same file. You can put them in separate files, but generally it's better and simpler to keep them all in one file.
With regards to pricing, I'd put all your pricing schedules in a single table and set up the database so that the correct price is looked up from the pricing table for a specific type of customer. An all in one table, is usually much easier to maintain and update--especially if you need to add new pricing schedules in the future.
Thanks for the quick response. I am very new to filemaker and databases, but the more I do the tutorials and the more I learn the better I feel about this. Actually I can't believe I wasn't using this before....
Thanks for the advice, I will keep the inventory and sales sheets within my contact file...
Is there any limits to the size of the files? Can they get too large? (or would this make searches run slower?)
If it matters I'm on a MAC with plenty of RAM...
I guess that would be my main concern (down the road) with keeping everything in one file....
This forum has been great for figuring out what approach I should take. Thanks again, wish me luck... or I may be back on here harassing you fine folks....
"Is there any limits to the size of the files? Can they get too large? (or would this make searches run slower?)"
One of my files is approaching 3 gigabytes in size and it works ok. I think you'll have to really work at things to get a file that is "too big". It is true that larger files take a little longer to search, but there are many other issues that are more likely to significantly affect search response times.
"or I may be back on here harassing you fine folks....
It's not harrassment, speaking for myself only, this is something I do for fun.
Well thanks again I'm ready to move forward on this.
Oh and by the way, if this is fun for you, I can't wait until I get "good enough" to start really enjoying this.
Just remember that there are two completely different definitions of the word "fun". :smileywink: