On Sat, 12 Jan 2008 12:31:37 -0700, John W. Vinson
I am probably making too much of this due to my inexperience so please
bear with me.....
I have a table containing a primary key and a customer request
I have a table containing various tasks and comments
(tblAnalyt)...this table is related to tblLog through a foreign key (I
believe that is the term to use)
I have a table containing varous items and costs (tblComponents) and
uses the same foreign key to relate to tblLog
The initial request by a customer is logged into tblLog and the
related tasks and items associated with that request are entered into
the tables tblAnalyt and tblComponents
In some cases, a customer request may be very similar to one already
in the tblLog table (such as a revision to an existing request)...in
those cases, I would like to call up that related request and use its
data as the basis for the new entry instead of typing all the info in
again....I also would like to do this without VB if it is
possible....for some reason I thought the appropriate entry of a form
setting would allow me to this (such as opening the form in entry mode
and searching for the specific log entry).
Here is how I'd like it to work.....I'd like to create a form using
tbl as the basis and in it contain contain subforms using tblAnalyt
and tblComponents as the basis of the subforms.....the user enters the
known info on the form and all the related info on the subforms come
up....they would modify it and it would now be saved as a new entry.
I hope I was more clear this time.....
Is my request possible without VB? If not, then how would I do what I
want to do?