This can get complex pretty quick due to the endless combinations of cable building x_x Ill try to explain this in steps.
In a nutshell, I want to perform some human error checking on a table (specific field) to add things to my table that may not have otherwise been added. For example, if someone completes a parts list, and there are transitions that do not call out tape, the user must add tape to the parts list, even though it is not called out specifically on the list of parts given (it may be hidden in some drawing footnotes). If tape needs to be added, it will be calculated depending on the number of different transitions (3 legged, 4 legged, 5 legged etc), of which I want to be calculated before adding it to the parts list. A message box with a yes or no option would suffice for entering tape and such. My problem is that I'm not sure how to go from a pop up to an addition to a table, or autofilling my form would be ok too.
1) If the word "transition" is in any record via the Description field, have a pop up that says "Transitions found. Add tape to the parts list?"
2) On yes, enter a customer specified tape. Otherwise, set a default tape part number.
3) Have a place (either on the same pop up or another pop up) where user enters # of 3 legged transitions, # of 4 legged transitions etc up to about 8 legged transitions. About 3 inches per leg * number of legs * # of x legged transitions = amount of tape needed in inches.
4) Add this amount for every transition type and convert to FT.
5) Confirm tape selection, append to table.
I might have a second pop up for epoxy on transitions as well.