battenberg
Burning candles both ends
- Local time
- Today, 22:42
- Joined
- Sep 25, 2006
- Messages
- 118
Hi
I want to have a table of 'database defaults' in my DB
each of the defaults is a setting that applies to all of the DB
how do i relate this table to the rest of the relationships or more simply how can i pull in one of these default settings into a calculation?
Example: I am trying to generate a warranty expiry date on a 'field exit' event.
the default warranty period in 'months' is contained within 'tblDatabaseDefaults' under the 'WarrantyPeriod' field
I think I may just be being thick!!!
can anyone help ??
I want to have a table of 'database defaults' in my DB
each of the defaults is a setting that applies to all of the DB
how do i relate this table to the rest of the relationships or more simply how can i pull in one of these default settings into a calculation?
Example: I am trying to generate a warranty expiry date on a 'field exit' event.
the default warranty period in 'months' is contained within 'tblDatabaseDefaults' under the 'WarrantyPeriod' field
Code:
Dim intWarrantyIncrement as integer
intWarrantyIncrement = ??? (tblDatabaseDefaults - WarrantyPeriod)
I think I may just be being thick!!!
can anyone help ??