I have a database where i will be entering payment information and I want to be able to potentially enter multiple payments for a single invoice. It won't necessarily be the same every time etc. I want to basically create a table off of each of those files but I don't know what to do! Im a complete beginner to this, so any help would be great. Thanks a lot for your advice,

Jim

In a nutshell: create a payments or transactions file that relates to the invoices by invoice ID. Also relate it to clients of course (by client ID). In FileMaker 7 relationships are two-way, but in FileMaker 6 you'll want to create a relationship in each file. Think about how payments are processed. E.g., you might get a payment in advance. You might get a payment that applies to more than one invoice. You might get an overpayment. You might need to issue a credit. You might need to apply credit or trade. Etc. etc.

Go to www.fmfiles.com and check out some of the examples.