O
OmahaAccess
I'm not for sure if I will explain this well enough to understand but I will
try.
I am making a sewer bypass record database. I have many bypasses, each
bypass has many details. One of the details is Mitigation Steps. There are 3
possible Mitigation Steps. Each bypass can have: jet line, saw line, or
remove debris. The bypass may have just 1 Mitigation step or it can have 2
or 3. It cannot have the same step twice or cannot have an option that is
not in the list. I have a subform within a form through a many to many
relationship. I have the junction table to set that relationship up. I get
the subform to work fine, other than getting some validation rules set up to
make it so one option cannot equal another option and only 3 options can be
selected. Maybe its not a validation rule that I need? Anyone have any
ideas? Thanks
try.
I am making a sewer bypass record database. I have many bypasses, each
bypass has many details. One of the details is Mitigation Steps. There are 3
possible Mitigation Steps. Each bypass can have: jet line, saw line, or
remove debris. The bypass may have just 1 Mitigation step or it can have 2
or 3. It cannot have the same step twice or cannot have an option that is
not in the list. I have a subform within a form through a many to many
relationship. I have the junction table to set that relationship up. I get
the subform to work fine, other than getting some validation rules set up to
make it so one option cannot equal another option and only 3 options can be
selected. Maybe its not a validation rule that I need? Anyone have any
ideas? Thanks