vaidehikumar
Registered User.
- Local time
- Yesterday, 21:09
- Joined
- Apr 17, 2012
- Messages
- 25
I have a Data entry Form to enter the payment info. I have Invoice ID and Invoice amount etc... in Invoice Table. I want the Invoice amount to appear automatically in the Payment form based on the Invoice Number I enter. I have Invoice number in both tables, Invoice Table(Primary Key) and Payment Table (Foreign Key).I have attached a sample DB, and my DB is similar ti this sample DB, just bigger with more fields.
Thank you for your help.
Thank you for your help.