This is probably the simplest of questions but I am missing the li

F

FBrnstrmr

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.
 
J

John W. Vinson

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.
Click to expand...

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.
 
F

FBrnstrmr

Sorry for the inaccurate use of terminology. I have one database with
numerous tables. One of which is an import for the use of data in it. It is
the foundation of the database itself as it contains the records of addresses
which are the starting point for collecting information related to each
location. I have been helped tremendously here in creating cascading
combo-boxes, drop-down, lists, etc. for the form I am using to collect the
associated data but now that I have done so I seem to have missed the part
where the "new" data I added into the form gets collected somewhere in a
table from which I can retrieve? it for a report when required. I have been
so intent on creating the form I neglected to follow through the process in
order to recognize this oversight until now. In short if I have a text box
(which has had info. entered into it by the user) or a combo-box in which an
item has been selected how do I get this info stored for future reference and
retrieval with a report. I am sure the report will be no problem but I don't
know where to point for the data. I am assuming probably erroneously, that
there should be a table with the user entered data stored in it, and I
further assume I was to create it when doing the form but how do I get it to
the table for storage? Is it the after update row that I use? I hoped to end
up with a table which has associated with each address a collection of
observations which are unrelated (except for the address and form a new
numbered record for each observation.) Sorry for the long description but I
know of no other way to describe it.
Thanks very much for any suggestions, etc. you may have.
-F
 
F

FBrnstrmr

I think my question in reply to your response is that I don't know how to
"store" it in the pantry.
 
F

FBrnstrmr

and/or how do I create a new record in this database for each observation.
OK I think thats about all I can say to try to explain my black hole.
 
F

FBrnstrmr

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
 
M

MikeJohnB

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
 
F

FBrnstrmr

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
 
F

FBrnstrmr

So I guess that what I am doing is not so much adding "new Info" but really
just associating relevant info from many choices to a specific date and
location which I need to record soemwhere for future reference. clearer with
every writing? I hope so.
 
Top