Populating Listbox

funk44

New member
Local time
Today, 11:10
Joined
Nov 1, 2013
Messages
9
Hi all, first time poster, long time lurker who has found plenty of answers to my questions from this forum so thank you all in advance

I am quite new to Access, Im fairly competent in VBA but an absolute novice using SQL, so bare with me and hopefully this makes sense

Im building a quality database but i am having trouble writing an SQL statement populating my Row Source

I have 4 tables tblCATOnlist, tblCATOfflist, tblCATClinical & tblCATAgedReport where the data is submitted from frmCATOnlist and so on. Each table has different criteria and calculated fields to determine the overall quality score so I am unable to combine all the data into one table

Each table contains the same 5 fields which i want to be displayed in my listbox namely Reference (CATON***** for tblCATOnlist etc), Type, Date_Entered, Reviewed_By, Agent & Score

I was wondering how i could go about combining the reference results into a single reference column and display the additional fields corresponding to the reference number

The results would then need to be clickable to display the original completed form (if that makes a difference) which i'll figure out using VBA

Hope that make sense and please ask any questions

Thanks
 
Welcome aboard:)
If each table contains the same 5 fields, you should use one table rather than 4. You'll need to add a sixth column to identify type.
 
Thanks Pat

Each does contains the same 5 fields which i need to appear in the list box but they also contain several others which are used for weighting in a calculated field depending on the type, which are all different
 
Perhaps you could step back and tell us about your "business" in plain English.
Pat has identified a potential issue with your table design. You may wish to research Normalization to see why she has advised you as she did.


Getting your table structure and relationships designed to support your business is critical.

For general sql issues see
http://www.w3schools.com/sql/

For relational database concepts see
http://r937.com/relational.html
 

Users who are viewing this thread

Back
Top Bottom