Portal to Portal...

[leesome]

Gday all!

This is a bit of a strange one, so I wasn't sure which section to put this under...

OK - I have two layouts that are both 'showing records from' "VEHICLE DATABASE". On one layout is a "PAYMENTS" portal and on the other is an "INVOICES" portal.

Essentially when ANY payment is made by a customer is gets added to the PAYMENTS portal. Maybe half of all payments need to be referenced to an invoice, so I have a drop down list in the payments portal so people call select the invoice number.

What I want to know is - Is there a way whereby when somebody selects an invoice in the PAYMENT portal, there's a way of updating the INVOICE with the payment that's been made?

Bascially I want the portals to be able to cross reference each other.

I hope this makes sense...

If anybody could help, that would be most appreciated!