A
AltaEgo
Hi
I have a need to populate zero value for selected fields in a table when
using a sub form.
Main table = DailyStats
Sub table = Rejections
Link = StatID
Rejections has about 6 reasons for rejection. These will change over time.
Rejections has three fields
StatID
Reason
Required (Y/N) field
When entering data, I need to ensure all fields in Rejections with a
Required value of yes are populated with a value (i.e. a number >=zero). All
other values should be null.
I have in mind the sub form creating a line for each required value when a
new DailyStats record is added. Do I need to create a record set or is there
another solution?
I have a need to populate zero value for selected fields in a table when
using a sub form.
Main table = DailyStats
Sub table = Rejections
Link = StatID
Rejections has about 6 reasons for rejection. These will change over time.
Rejections has three fields
StatID
Reason
Required (Y/N) field
When entering data, I need to ensure all fields in Rejections with a
Required value of yes are populated with a value (i.e. a number >=zero). All
other values should be null.
I have in mind the sub form creating a line for each required value when a
new DailyStats record is added. Do I need to create a record set or is there
another solution?