I am developing a db for our web design/hosting company.

Here's the dillema. I have three databases. vc_client, vc_billing and vc_server. All of the revenues for design are straight forward. However, we have two people providing hardware for servers. We have a seperate agreement with each one. Each one receives 30% of all revenues collected for hosting ONLY for clients hosted on their respective server.

Am I completely confusing you yet? ;-)

In the vc_billing db, I have a field for each server that I enter the amount the client has committed to for hosting on a monthly basis. For instance, if I am serving your web site on server1, I will enter 50.00 into the server1 field. If I am hosting you on server2, I will enter 50.00 into the server2 field.

Now, here's what I need to have happen. I would like to have that monthly amount automatically post to a new_charges field also in the vc_billing db on the 14th of each month so I can generate current invoices on the 15th

Next, when I post a payment into post_payment from a client in the vc_billing db for hosting, I need to have 30% of the hosting fees post to the vc_server db in a field called host_revenues that is automatically routed to the appropriate servers record. And yes, each server is assigned a server ID.

This 30% needs to be figured off of the static monthly amount , not total payment posted as there may be design fees in a payment posted.

Would it be easier to have two payment posted fields? One for hosting and one for design?

I may be making this way more difficult than it needs to be. I am just beginning to wrap my mind around the power of FMP and appreciate your patience with this soon-to-not-be-a-beginner developer!

Cheers! Stephanie Cameron

Having gone through something similar recently, I suggest that you create two records for the payments to the vc_server db, one for 30% to one server and one for 70% to the other. If you try to do this with two fields and one record, you will likely find it difficult to work with the data.

Rather than entering an amount in server1 or server2, it seems like it would be simpler to have just a single field for amount, and another field for serverNumber. That way, you could easily break out payments for a given server by number.

Told you I thought I was making it WAY too complicated!!

Thanks for the help. I think your suggestions are what I needed to get past this sticking point.

Back to the trenches ...

Stephanie