'recording' invoices

[Sam]

hi! I have a problem, I am using a form to 'pull' certain
information for an invoice. (ie: get it from tables via
drop down menus). However, I'd like it to 'record'
information such as calculations, addresses (obtained via
a drop down menu from a different table) preferrably in
the table that the rest of the form is having the
information pulled from. I thought of just having it print
the information via a report, but I need an electronic
copy to function as a log to track this information. Is
this so hard of a request to ask of Access?

Example:
Form1 - based on Query1 (which is based on Table4)
drop down menus 1-3 - based on Tables 1-3, respectively

Ideally, I'd like the selections from the dropdown menus
to 'show up' or be 'recorded' in a table of somesort. So
that I can a) have a full record of the invoice and b)
have a table on which to pull a report from.

 

[john]

its quite simple
make a table with all the fields that you want to record the data
next make the form then add all of your combo boxes and set them to store
the data in the respected fields