Re: Newbie question regarding table design

#1

Quote:

1) Should I use two columns, or should I use only one column and derive the value in the second column?

One column in the base table and two columns in a VIEW. This ensures
data integrity

#2

Quote:

Access is a file server database and doesn't have any triggers. To do this, you would use a form and VBA code to calculate the second column's data.

No. You would use a VIEW rather materializing a calculation or using
a trigger (procedural code, ugh!!).

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

comp.databases comp.databases