A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Products/Services Table



 
 
Thread Tools Display Modes
  #1  
Old April 8th, 2010, 05:59 PM posted to microsoft.public.access.tablesdbdesign
dvvog
external usenet poster
 
Posts: 1
Default Products/Services Table

I am using Access 2007. I have a database for my Products/Services industry.
I have a table containing my products/services, as well as a Work Order Form
that is linked to the Products/services table from which I can choose via
drop down the products that I am selling to that customer. The
Product/services table contains 3 fields; Product, Cost & Price. The Work
Order Form also contains those three fields, and when I choose a product from
the drop down, the corresponding Price field fills in as well. Now, sometimes
(after bargaining of course!) I want to change the price for that specific
work order without it affecting the main Products/services table, can anyone
help?
  #2  
Old April 8th, 2010, 06:45 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Products/Services Table

You should have a separate table for Work Orders. Your work order form
should be based on this table. This table design makes the price in the work
order table independent of the price in the products/services table. You can
leave the price auto fill in the work order form and if you need to change
it just move your cursor to the price field and edit it. The end resuly will
be no change to the product price in the product/services table and a
different product price in the work order table than is in the
product/services table.

Steve



"dvvog" wrote in message
...
I am using Access 2007. I have a database for my Products/Services
industry.
I have a table containing my products/services, as well as a Work Order
Form
that is linked to the Products/services table from which I can choose via
drop down the products that I am selling to that customer. The
Product/services table contains 3 fields; Product, Cost & Price. The Work
Order Form also contains those three fields, and when I choose a product
from
the drop down, the corresponding Price field fills in as well. Now,
sometimes
(after bargaining of course!) I want to change the price for that specific
work order without it affecting the main Products/services table, can
anyone
help?



  #3  
Old April 8th, 2010, 06:53 PM posted to microsoft.public.access.tablesdbdesign
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Products/Services Table

You would need to have the appropriate fields in the "child" table to store
the values. Typically the combo box for the products/services would contain
columns for the price. The after update event of the combo box would have
code to set the value of the price field like:

Me.txtPrice = Me.cboProdService.Column(1)

Columns are numbered from 0.

--
Duane Hookom
Microsoft Access MVP


"dvvog" wrote:

I am using Access 2007. I have a database for my Products/Services industry.
I have a table containing my products/services, as well as a Work Order Form
that is linked to the Products/services table from which I can choose via
drop down the products that I am selling to that customer. The
Product/services table contains 3 fields; Product, Cost & Price. The Work
Order Form also contains those three fields, and when I choose a product from
the drop down, the corresponding Price field fills in as well. Now, sometimes
(after bargaining of course!) I want to change the price for that specific
work order without it affecting the main Products/services table, can anyone
help?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:25 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.