General information
Title:
Loading a Table from an SQL Select
For a medical system I need to select a group of patients from a master table and load/stuff a table or grid with some of the fields from the master table....easy enough using Select SQL BUT if a field in the master table contains a value which is related to a look-up table, i.e. Region '1' which is actually 'North-East' in the related table, HOW can I transfer 'North-East' into the search results instead of '1'.
At the moment I am doing the Select SQL which transfers raw data from the master table then loading another table with related data etc which takes time
Any ideas please anyone?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only