Calculated Form Fields do not fill data into related table fields

From: rich1838 (rich1838_at_discussions.microsoft.com)
Date: 02/12/05 

Date: Fri, 11 Feb 2005 22:09:01 -0800

I am creating a db for a retail business. I have multiple vendors from which
I buy the same product for resale. These vendors issue pricing either based
on net or varied discoumts from their list price. I created a table for the
products, a sub table for the vendors, and another sub table to caculate
pricing based on list / net costs. On the form, I'll take the vendors price
and use a Yes/No field to determine a calculation for my price, eg. Iif
([List /Net], [Vendor Price], [Vendor Price] - ([Vendor Price] * [Vendor
Discount])) . The calculations in the form field [My Price] work, however
this calculated number does not show up in the table field [My Price], nor
can I link this calculated number into other fields on other forms (PO's). I
have checked the one-to-many relationships and referential integrity /
cascade up and delete and nothing?

Relevant Pages

  • Re: Cheapest Place To Buy a 80ED Refractor
    ... You won't see any better pricing on an item that costs at wholesale ... close to the lowest price. ... competition in the US market and other selected markets. ... > seeing very little competitive pricing among the vendors that I am ...
    (sci.astro.amateur)
  • Tracking History of an Item
    ... I'm needing to track Part Pricing for customers and Vendors ... And then when I created an order I would Select the most recent price ...
    (comp.databases)
  • Re: What are the issues?
    ... So they either have to add or drop vendors. ... seems to be going up (except the price of blooming orchids), ... Out-of-country growers who truly can't afford to ship any unsold plants ... By the time you get them landed here, the cost is ...
    (rec.gardens.orchids)
  • Columbus OH woodworking show..
    ... are still a number of great vendors there that make the show worthwhile. ... Mostly, you can pay the asking price of the item, but get a bunch ... Try getting it free with your purchase! ...
    (rec.woodworking)
  • Re: LW "hobbyist pricing"
    ... because he doesn't like the price doesn't mean he's unsuccessful. ... Fact is, with only 1/4 the gold required, Cheapside Man ... maybe one of the vendors should become "Steve Jobs ... over from a time when the software market expected such high prices. ...
    (comp.lang.lisp)
Loading