I followed the .sql script to add the bed types, wards and multiple mappings of both however; I am not seeing any of them show up? Is there an extra step that I am missing?
Maybe you can upload a screenshot of the contents of the Ward tables, or a file containing the export of the tables. Then someone might be able to see if the ward table data is setup correctly.
Were you able to see the ward beds earlier, and then they stopped showing up after you ran some queries… or were they never showing up from the beginning itself? I ask this because the demo database ships with sample ward layout already.