We help IT Professionals succeed at work.

Need a form to create a new invoice, and attach it to a particular contract.

taborrg
taborrg asked
on
Medium Priority
354 Views
Last Modified: 2012-05-12
Hi,

I think I just need general guidance at this point.

Need a form to create a new invoice, and attach it to a particular contract.

e.g.
Form to Add an Invoice.
     Contract: Aloha Trust Co.   Invoice Amt:  $100.00

tblContractName is a table with ContractNameID as primary key
tblInvoices is a table with ContractNameID as foreign key

Thanks,

Rick
Comment
Watch Question

If you can post a sample db, it would be easy for us to assist you.

Ed

Author

Commented:
Hey Ed,

Here it is.  

Thanks,

Rick
Database1.accdb
What would you prefer - a dialog form or a subform?

Or can you provide steps on when the invoice form display.

Ed

Author

Commented:
I'm enough of a newbie that I don't know the difference.  (My background is mostly hardware, systems engineering - trying to move into software).

It's for a non-profit org that does community based support for small businesses.  They have a lot of volunteers who get no real training, so something simple, intuitive.

A form that would have a combo or list box to select the (already existing) contract name, then fields to enter the new invoice might be the way to go.

Thanks



Ok.
Try to see the attached db. Then, Open the frmInvoice

Sincerely,
Ed
Database1.accdb

Author

Commented:
Great!

Thanks.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.