I have a multiple items form that runs off a query, but doesnt show all of the information in the querry. The columns are there, but they do not contain any data, even tho the data shows in the query. Any ideas? Ive attached screenshots.
I have a multiple items form that runs off a query, but doesnt show all of the information in the querry. The columns are there, but they do not contain any data, even tho the data shows in the query. Any ideas? Ive attached screenshots.
those screen shots were not very informative. For example, an employees position shows on the querry but on the form the column is blank. The same with thier type of exception.
what joins are you using in your query....
I think what you are asking me is what the relationship betweeen the tables I have querried are? All of the tables in my database are joined by the employee ID, which is set up with the retain integrity and cascading updates and deletes for that primary key and foreign key relationships.