I would like to create a simple table that allows me to select 1 item in a field using a dropdown box and which will then automatically bring up the related value in the next field, eg. select procedure, then item number for that procedure is entered automatically in the field
How do I do this please??
I have only basic filemaker knowledge - please use non technical terms.