February 5th, 2010, 09:39 PM
posted to microsoft.public.access.forms
|
|
|
'Add Record' button on a form
Thank you BruceM.
"BruceM via AccessMonster.com" wrote:
You would need at least a Customer table, an Invoice table, and an
InvoiceDetails table (for invoice line items). Each Customer may have many
invoices, so there is a one-to-many relationship between the Customers and
Invoices tables. Likewise, each Invoice may have many InvoiceDetails, so
there is a one-to-many relationship between the Invoices and InvoiceDetails
tables.
The short answer is that what you seek can be done, but you will not be
helping yourself to proceed as you describe. It may sort of work at first,
but there are many places where it can cause major future problems. Also, it
will require a certain amount of coding to implement it, which has its own
learning curve.
This is more than can be talked through in a newsgroup (at least it is for me)
, but if you have some basic terminology and techniques under your belt you
can make progress, and come back with a specific question. To that end it
will probably help to review some tutorials, etc. about Access and realtional
databases in general. Here are some links that may help. Crystal's tutorial
is as good a place as any to get started, IMHO.
Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html
The Access Web resources page:
http://www.mvps.org/access/resources/index.html
Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/
A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html
A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal
MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
ramudo wrote:
Thank you, Jeff Boyce, for making that clear to me. It is very apparent that
I have very little experience in Access. I am using a form to input invoice
data into a table. What I meant by reusing the data is that if when I
clicked the Add Record button, the customer code and customer name would
remain on the form so that I would not need to select them again, being that
I have multiple invoices for each customer. All other fields would clear.
Thank you again for your help.
Ramudo
[quoted text clipped - 23 lines]
.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201002/1
.
|