Unbound Form

  • Thread starter Thread starter NNlogistics
  • Start date Start date
N

NNlogistics

I want to create a form to be used by Data Entry as a worksheet. When
customers call they would be able to work the costs and totals on existing
product. I tried to use a bound continuous form that uses the "tblProducts"
to supply basic product information. Of course it doesnt allow me to enter
an existing product because I would create a duplicate product code(Key).

I suppose I need an unbound form but I want to make use of the exsting prod.
information (Codes, description, price, etc) and I would like to open a "new
record" (Although I know its not really a record, in that I cant write it
anywhere) after one is completed.

I hope that makes sense.

Thanks

Joe
 
Your question is a bit vague but it sounds like you need 2 tables in a
one-to-many relationship. Then you could handle this with a bound form to the
first table (tblProducts) and a subform to the second table (tblCosts).

-Dorian
 
Back
Top