Recent content by fromthecauseway

Thanks for the help. Found a previous entry explaining the alternative to using lookup on tables so will try again.

Yes. I have a table tbl_type made up of ID, typecode and typetext (ME and Mechanical). Tbl_documents then gets the value from there with a foreign key joined in relationships. Not sure how else I get the same result

I'm trying to make a document register where the number is made up of various fields. Discipline, type, number (ME-RPT-0001) which is mechanical report number 1. I have a tbl_documents which prompts for the discipline and type using combo box lookup from tbl_discipline and tbl_type. This is...