Jump to content

help..add data from portal files that share values


gatti

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

Recommended Posts

Alrighty, this is the situation...

I have a "clients.fp5" database and an "invoice.fp5" database. The client database shows a "portal" of each invoice that was created and linked by "client code". Now the thing is...certain invoices are to billed under a shared "contract code".

This "invoice.fp5" database uses a number field in regards to the "total billing price" and a number based "contract code" field that is to be used only when an invoice is to be billed under a shared bill. I plan on adding an additional database called "contracts" and have it as a portal in the "clients.fp5" database.

What I need to do is add the "total billing price" of the INVOICE records that specifically share/contain the same "contract code." Can someone help me and shed some light on the formula that I'd use?

Link to comment
Share on other sites

I'm not sure i understand. That thing is that I only want records that have a specific field number that match another databases field to be added. Perhaps if you can go into more detail that'll help out so much.

oooo. never mind. i got it now. thanks again.

Link to comment
Share on other sites

This topic is 7216 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
×
×
  • Create New...

Important Information

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