Hopefully this is a simple solve.
I have two tables. “tblSeed” and “tblRef”
“tblSeed” has a column with a dropdown named “Seed Type”. This has four options to choose from.
“tblSeed” has another column named “Seed Cost”. The idea is to auto-populate this column with the cost, according to the dropdown selection from the “Seed Type” column.
“tblRef” is a separate table that simply has two columns that have the same names (“Seed Type” & “Seed Cost”) and these list the seed costs next to the specific seed type.
I can not figure out, for the life of me, how to get the seed cost to populate in my form when I choose a specific seed type from the dropdown.
Full Disclaimer: I have spent quite a bit of time and energy, trial and erroring this, but come to find out, I’m an idiot. I could really use some help and/or direction on this matter. And I thank you in advance!