Chippewa Publishing LLC

Hello, I've developed several different databases that I'd love to tie in together yet I'm at a loss. There are some tweaks I'd like added as well. It doesn't seem that hard to do, yet I'm pulling my hair out. I need the following: A RDBMS with a table for books, authors with more than 1 pen name or a person table with more than 1 pen name and funtion, a royalties/income database where a person for each book can be author, artist, proofreader, photographer, model, and/or editor. There are also some other roles needed. The system needs to be shared over the web and access control via login. Just a few examples can do then I can add the rest. Right now people can login but the actually see the hidden field with ?? in it and it's ugly. :-) A project check off list for what state the book is in, what formats are completed, etc. A review site check off list for what sites the book has been submitted, reviewed or declined to. A check off list to what catalogs/distribution system we've added the books to. The problem is that I'm a startup with very little cash. Most of it goes out the door right now. If you are interested, please send me a quote. I can show you what I have already. Maybe we can work out some sort of one time payment if reasonable or work out a payment deal. I might even need future changes if I can't do them myself. My email is chippewa pub at mac dot com (no spaces). Thanks! Rebecca

Thanks Stanely. I will try it. The concept does seem easy until I try to put it into action. Now that I realize a lot of the information is taken from outside tables it makes a little bit more sense. I've been going back and forth between MySQL and FileMaker and although the concept is the same, the method is different. Thanks! Rebecca

And now I'm really scratching my head because it seems that now not only are there related fields, but related external databases as well. I was just reviewing the business kit for FMPro 8. I'm sure the idea is not that difficult. I understand the 1 to many, 1 to 1, but putting the concept together is driving me nuts. Thanks!

I've been working with filemaker since a very early version so creating a flat file type database for me is very easy. Even using lookup fields to populate information was easy. Using a field to see data from another table is somewhat simple. The problem I start to panic at is when I need about ten tables for various things and then realize that I have no idea what I'm doing and how I"m going to tie this stuff together. I mean, say I have a book table, an ISBN table, and a person table. In very rare cases an author can be an editor and sometimes an artist as well. Do I need three "title" tables or maybe one person table and a title table? Check boxes for each title? It gets even worse with royalty databases. I built a really slick one that is great when there is one author, but with split royalties for anthologies I have to enter the book as many times as there are authors because I don't know how to tie one book to many authors. I just need a "smack me over the head with a keyboard" book so I can grasp the very basic concept I guess. -) If possible, please point me in the right direction. Thanks! Rebecca

Excellent. I figured out how to get the script to run in the File Options menu. Now I just need to figure out how to automatically put in the user name and continue the script without user intervention in the find command.

Hello, I'll let you know my problem first then what I need. Problem: I have several users with functional layouts (ie editor, artist, etc). I want the user to login and see only their layout (done), but I want it to only see the fields with their name (done). The problem is that even though they can only see their records, they can see the fields that say "no access". So what I want to do is have them login and when they login it does a search on that specific field with their login name and it finds only those records. It's kind of complicated. I did it this way because I have no clue how to make a database relational. ha ha. But it works! I just need to find out how to perform the find command with their user name when logging in and have it work both in the web sharing and in the normal network sharing. Thanks! Rebecca