Re: This is probably the simplest of questions but I am missing th

Well here is the thing, I have a main table which lists 30000+ addresses with
owners and owners addresses etc. Not all the Info. in that table is relevant
but it gives me a starting point for my requirements. So I have created a
form which has a combo-list that provides me with the selection I need from
the 30000+ addresses.
After choosing the relevant address I then proceed to add info onto the form
from various other drop down lists which provide other relevant info.
including date as it is a time-location specific form. From all of that I
need to create another table which serves as a memory (record) for each
location-time. How do I save the info from the form to the "new" record in
the memory table such that when I add more info to that location on that date
it does not erase the other one. Originally I was just planning to print the
form after each instance but now it is necessary to preserve it. -Thx


"MikeJohnB" wrote:

A form should be based on a table or better still on a query that is based on
a table. When this is the case, the form is bound to the table either direct
or through the query. Entering data in a control within the form will then be
entered direct into the related table. So your data should not need a save
button as the data as eneterd is fed direct to the table. A combo box will
prompt you for the field in which the lookup data is to be replaced.

I cant work out how you have made the form which is not related to a bound
table so I am struggling to understand the problem.

So, in essence, start with the table which is to accept the data and then
generate the query and onto the form.

Sorry if I have mis-interpreted what you have added.

John is perhaps a lot better at this than I am if he has not dropped the
thread.

Hope this helps a little?

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


"FBrnstrmr" wrote:

So I have been looking and do I need a save button and a new record button or
something like that? I can't seem to find it anywhere so even a marker to
help me find the info would be most appreciated. Thx, (many times over),
-F

"John W. Vinson" wrote:

On Sat, 10 Jan 2009 09:17:01 -0800, FBrnstrmr
<FBrnstrmr@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I have database tables and use them to create a form with some of the data
from each and then add more info which is relevant to a third database. How
does this added info get into the third database from the form, please?
Thx.

Well... you don't.

Relational databases use the "Grandmother's Pantry Principle" - "A place - ONE
place! - for everything, everything in its place". If you store data in one
table, then that is the *only* place you should store it; you can use Queries
and other tools to display it in conjunction with information from other
tables.

Perhaps you could explain a bit more about the context and what you're trying
to accomplish (such as some information about the design and structure of
these tables). If you really mean "another database" - a separate .mdb or
..accdb file - please explain why you're adding this additional complexity.
--

John W. Vinson [MVP]

.

Loading