Узкая лестница спускалась к платформе, за которой тоже виднелись ступеньки, и все это было окутано красным туманом. Грег Хейл, подойдя к стеклянной перегородке Третьего узла, смотрел, как Чатрукьян спускается по лестнице. С того места, где он стоял, казалось, что голова сотрудника лаборатории систем безопасности лишилась тела и осталась лежать на полу шифровалки. А потом медленно скрылась из виду в клубах пара. - Отчаянный парень, - пробормотал Хейл себе под нос.
I am creating a form with a subform. What are you actually tracking with the 2nd table? Based upon what you posted there is no price history. Was this reply helpful? Yes No. Sorry this didn't help. If there is no price in the tracking table and I make a change to price in the inventory table, then all of my historical ordering price will be incorrect.
Threats include any threat of suicide, violence, or harm to another. Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect.
Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software. Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites.
Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation. Details required : characters remaining Cancel Submit. This is one of the very few exceptions to the rule against redundant data.
When you have a value that is time sensitive you want to preserve the value at the time the record was created. First, your tables need some work. Do not accept the default name for your Autonumber fields. You should always use meaningful names for your objects. Then your foreign keys should be similarly named to visually indicate your relationships. That is redundant. Ken gave you one way to do what you want, but I think Ken missed something.
Given the way you have your form setup, You would never enter the product name since the FK fills in automatically, so the After Update event wouldn't fire. Since your main form has the current price, I would just set the Default Value of the Price control on the subform to:. They can see the Product name from the main form. But this isn't redundant data. Filling that value with a default value is another matter entirely. Choose where you want to search below Search Search the Community.
I have two tables. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question 0. Report abuse. Details required :. Cancel Submit. QA Guy CommElec. Thanks for your feedback. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. Ken Sheridan. Scottgem MVP. In reply to tonydepo's post on February 19, In reply to Scottgem's post on February 19, In reply to Scott McDaniel's post on February 19, Ok, I'll concede that interpretation.
This site in other languages x.