Good morning...
Let's see if I can make this somewhat simple
1. I have four data fields in a table; one is data type text (call it alpha); two others are data type number (call them bravo and charlie respectively) and field delta is data type number formatted as percent.
By written English type coding I need:
If alpha = "complete"
Then delta = 100%
Else delta = charlie divided by bravo *100
2. I need to link a field to a subsheet that brings up definitions. For example, if someone clicks on the field to enter information, in this case functional requirements (in form FR-001...), a subsheet opens up with a list of definitions; this is specifically referring to a list of functional requirements for system development. It isn't a drop-down to select list but just an information page so the person entering the data can make sure they are entering the proper functional requirement.
For examle, the functional requirements table reads (think columns)
Functional Requirement ...........................Description
FR-001............................................... ....System must do something
When the user clicks on the Functional Requirements Field in the database, this table with the definitions would open as a subsheet.
Thanks