Jump to content

Newb to relationships (specifically, one to many)


Esmo2000
 Share

This topic is 6432 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 yay.gif

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6432 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.