"If" coding

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

Guest

I want to create a form that will become a job quote. I want to enter a item
number and from that number have the description field automatically filled
in. Can I do this in Access and how. I also need to do this with states,
i.e. enter a state and another filed automatically enters data linked to that
state.
Thanks
 
Hi Sam

This is what relational databases are all about!

You should have a table of items, with ItemCode as the primary key. Other
fields would contain information about that item - for example: description,
category, availability, price, etc.

Your quote detail record does not need to contain any of that data, except
for the ItemCode. The other information about the item being quoted may be
gained from a query where the two ItemCode fields are joined in a
one-to-many relationships.

Take a look in the sample Northwind database. There are numerous examples
of such one-to-many relationships: Customers-Orders, Orders-OrderItems,
Products-OrderItems, and many more.
 
Back
Top