Form Set Up Help

  • Thread starter Thread starter Lou
  • Start date Start date
L

Lou

Hello;
I need some suggestions on how to handle this idea.
My tables are as follows:

tblPartsHistory
[ItemNumber]
[Date]
[Quantity]
[Autonumber]

tblParts
[ItemName]
[Manufacturer]

The child to parent relation ship tblParts-[ItemName]
(Parent) to the tblHistory-[ItemNumber] (Child).

What I would like to do is have 5 fields assigned on my
form so that the user tabs to that field which will be
assigned to the tblHistory item and just put in the
quantity.

*I have set up the default value to the specific part
[ItemNumber]
*They enter an amount in the first [Quantity]
*The [Date]is Now()
*[AutoNumber] is auto

Say there is 5 [Quantity] fields in a column when they
enter the quantity in the first field and tab to the next
I would like the previous field to go blank when not in
use so all the fields do not show the same value as
previously. The database will handle first 356 parts to
start and will grow from their. I will set up the parts in
tabs according to vendor on the form as a continuous form,
my problem is that I keep seeing the same value placed in
all the fields as I want to stop this so they don't get
confused. I hope this makes sense.n Any and all help would
be greatly appreciated.

Access 2002
 
Back
Top