Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-04 : 20:01:35
|
Keith writes "I am using an Access 2000 project as a front to a SQL 7 database. In this database I have a one to many relationship between PRODUCT and ORDER tables (based on ProductID in both tables)
The PRODUCT table has a column which contains the retail price for the product and ORDER table has a unit price column and a ProductID column.
When the user enters the ProductID value in the ORDER table, I would like the unit price to default to the retail price in the corresponding PRODUCT row. The vast majority of the time this value will be correct but sometimes the user will need to override this default value.
What is the best way to accomplish this?
Thanks in advance!" |
|
|
|
|
|
Default column value based on lookup