Forgive me if I have missed this in a lesson or documentation. I’m still feeling like a baffled newbie.
I have a “Status” table that I want to use to show the status of a “Job”. The “Status” table is a simple lookup: “status_id” is a long, “status_name” is a string. There is a 1:Many relationship with “Job” , and it also has a field called “status_id”.
On the browse form I would like to replace the “status_id” column with the relevant “status_name” instead. “Open”, “In Progress” and “Completed” are more user-friendly than 1, 2 or 7. Ideally I would like to be able to automate this, rather than hand-code the change on the browse form.
Where can I find some instructions on what needs to be changed in the Jobs browse?