April 23, 200817 yr 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!
Create an account or sign in to comment