How do I automatically fill a column in a table using a ID code c.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to have a material description column fill automatically when a
correct material code is entered into my table. I have created a material
table with a unique code for each material type. When generating a work
order, in a work order table, I would like the material description to fill
automatically when a valid material code is entered.
 
That would be redundant to store the data in the table. The whole point of
a relational database is that data is stored only one time. You can relate
the two tables so that the forms, reports, and queries will be able to pull
data from more than one table.

What happens if you change your material descriopstion? How would all the
old records get updated?

There are exceptions. If you DO WANT to record the description AT THE
CURRENT TIME so that future changes don't affect historical records, then
you might want to do it the way you mentioned, but this is more common when
talking about prices or things that will change but should not affect
history.

Look at how to populate other fields in a form afer selecting a key, rather
than how to do this in a table. There are TONS of posts on this if you will
search.

Also, sounds like you are working with a system very similar to the built in
NORTHWINDS sample database. Why don't you study that database before you go
any further. It deals with products, customers, employees, salesmen,
invoices, etc.


Rick B
 
Back
Top