I am creating a book register for the office. Most of them are actually reports and guidelines from various government department. I have created a table called author to store the name of the organisation that authored the document and a table for the alternative org name. Then used a union query to amalgamate the org name and alt org name. See attached database.
That works reasonable well except that the org name in the form revert to an alt org name instead of the org name. The problem is that it is sorting the org alt name field of the union query.
does not accept entry that are not in the org table. So we have a delema
when the org name is shown the alt org name is not accepted.
when the alt org name is accepted the org name is not shown unless it has priority in alphabetical sorting.
I seems to me that this could be solved if there is away to force the records from the org table to appear first in the union query, that is
1) sort by org number
2) no alphabetical order in alt org name but records from org table must alway come before records from the org alternative table.
Can anyone assist
Cheers
Start Free Trial
