I am working on a database Mac FileMaker Pro 15. I am hoping to be able to input one "Account Number" (which is currently set up as a drop down menu) and have another field "Item Type" (currently set to a value list) to auto fill in when the specific item number is selected.
So hypothetically, when "account number" A732200 is selected from the drop down menu, the number I'd like to auto fill, 0005792100, would pre-populate in the "Item Type" field. Reasoning behind it would be so that there's no chance for a potential typo.
I've been looking at value lists and also trying to do a relationship between tables. I'm sure I'm overthinking this, as I thought it would be relatively easy to do, but I'm obviously missing some BIG steps. It's a database on students and Fall and Spring semester teaching allocations. I'm just totally brain blocked right at the moment. Any ideas? Thank you so much!!! Lori