Search results

- I have a report that is unbound. It consists of many controls, subreports and other formatting elements. - Each control, textboxes or listboxes, is bound to an SQL query, written to extract a very precise piece of information from the database as a whole. - Each of these SQL queries...

I have a set of reports: - Each report contains subreports. - All reports and subreports contain listboxes. - All listboxes are bound to various queries. - All queries reference directly to the database, not derived tables. - All sub-reports are bound to a query. - All parent reports are...

I have a set of reports: - Each report contains subreports. - All reports and subreports contain listboxes. - All listboxes are bound to various queries. - All queries reference directly to the database, not derived tables. - All sub-reports are bound to a query. - All parent reports...

A new problem! This once again concerns the relationship Client > Case Reference < Case. I have a subform that is bound to Case Reference. This subform is placed in another subform that is bound to Case. The purpose of this subform is to cycle through the Clients that are related to the Case...

Please bear with me folks. You do not need to tell me about data integrity issues, the importance of key referencing and how all these things work. I can design a database. The difficulty I'm having is producing a working solution using Access with its powerful but, for what I'm use to, wholly...

@ Banana I'm aware of all these issues, but if I were to use some form of automatic key numbering it would have to be as simple as possible, bearing in mind I have about 13 + entities, most of which have unique keys. Pat's idea was good. Your idea sounds good but slightly more complicated to...

@ Banana Your advice has been very useful Banana, thanks. I think I'm starting to grasp how I should go about constructing these forms. Perhaps the biggest plus is confirming with my client that they do not mind entering the key values themselves manually (that is, Case ID, Client ID, etc)...

@ Banana - Thanks for that link, I've done a bit of reading of it. I have only a month to implement my solution as some real life issues have pinned my project time between going back to my studies at university and visiting loved ones at hospital. That means you're suggestions are, while...

For the benefit of clarity, I would suggest anyone who reads this thread to download the entity relationship model I have produced of the database in order to understand what the hell I'm talking about. :D I have points to make before I present my questions: * The database is intended to be...