COMBO UPDATE

[John]

Hi

Pls help me

in form i created 2 cells, item no & item name using combo.
item no is combo & item name is text (=item
no.column(2)(
i click item no and i can manage to see item name in item name box.
once update, i could not able to see in table for item name.

pls advice.

thanks

john

 

[strive4peace]

Hi John,

it is best NOT to set up the field in your table with a combobox -- it
is best to see the actual data being stored since users should not open
tables -- only admins, which would be your number. If you want to see
the names, use a form (as you have done) or a report.

Don't use lookup fields in table design
http://www.mvps.org/access/lookupfields.htm


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*

 

[John]

Hi Strive

I didn't set up look up field in table, what i have done is: -

In table: set up item table (item no & item name).
employee table (name & address)
Distribute table (link up with ITEMID & EMPLOYEEID)

In Form: set up Distribute table using (Distribute table in table)

When user do data enty in form, click item no (combo-dragdown) select and
item name to be appeared automatic using =item no.column(1). But after
posting for this transaction, i go and check the Distribute table in TABLE,
item no is updated, item name is blank. I would like to update item name in
Distribute table elsewhere. Pls help me.

Thanks a lot.

JOHN

 

[John Vinson]

Hi Strive

I didn't set up look up field in table, what i have done is: -

In table: set up item table (item no & item name).
employee table (name & address)
Distribute table (link up with ITEMID & EMPLOYEEID)

In Form: set up Distribute table using (Distribute table in table)

When user do data enty in form, click item no (combo-dragdown) select and
item name to be appeared automatic using =item no.column(1). But after
posting for this transaction, i go and check the Distribute table in TABLE,
item no is updated, item name is blank. I would like to update item name in
Distribute table elsewhere. Pls help me.

The item name SHOULD NOT EXIST in your distribute table.

Your description above is correct: the distribute table should contain
only the two ID fields.

Storing the item name (or the employee name or address) redundantly in
the third table is neither necessary nor good design.

Create a Query joining all three tables; that will let you display the
employee name and the item name together, without storing them
redundantly.

John W. Vinson[MVP]