Select Field Determines Other Fields
Posted on 2009-04-06
The Select will have several options:
When you select "Dispense" I need text fields named:
If you chose "Receiving" text fields appear named:
In the perfect situation each text field is uniquely named verses using the same text fields with different labels. Some options may need 4 text fields, and another may need 1 field.
In the SQL database I'd have columns named:
DispName, DispCenter, DispNumber, RecVendor, RecForm, RecInvoice, etc.