I'm trying to figure out how to tie one text box to another, to limit the amount of entering needed and errors when typing. Everytime I add in a new row I want some of the information to populate based on the information entered in the first (or second) column. The first Column is numbers, the second column is names and each time I create a row and choose a number, the name needs to be tied to that number (1 will always equal A, 2=B, 3=C etc.) Is there a way that I can set the options so that everytime I put 1 in the first box, the next will automatically populate as A?
And from there, I need the third column to give a drop down list of the items that are connected to the first two; there are more options for this, about 5 per number/name, but the descriptions will be different for each, so I just want a dropdown of those that are relevant to the number/name columns in the table. I can get the dropdown boxes, but I haven't been able to make them autopopulate or limit the choices.
Table is done, relationships are establised, how do I make the rest work? Thanks!
And from there, I need the third column to give a drop down list of the items that are connected to the first two; there are more options for this, about 5 per number/name, but the descriptions will be different for each, so I just want a dropdown of those that are relevant to the number/name columns in the table. I can get the dropdown boxes, but I haven't been able to make them autopopulate or limit the choices.
Table is done, relationships are establised, how do I make the rest work? Thanks!