Adding Query That Requires Info From Multiple Files
Last evening I finished adding information to my first Brilliant Database thanks to some great help from MacHeuS. The database contains four files (three single sheet/tab files and one file that has three sheets/tabs). I am now ready to start adding queries but have already reached a stopping point at my first step. I researched the User Guide and watched the video tutorials but none addressed my issue.
My problem is as follows: is it possible to add a single query that, for example, has to go to another file to extract information. More specifically, I am attempting to recreate a database that I did in EXCEL for managing my organization's employee training. In BD, I have a file listing all 'Employee Names' which contains their 'Job Title'. There is another sheet/tab on the 'Employee Names' file which lists the training 'Courses' that the employee has completed. A separate file lists all 'Job Titles' and contains all training 'Courses' required for that position. I want to be able to see what 'Courses' an 'Employee Name' is missing based on their assigned 'Job Title'.
I had to recursive code in Visual Basic for Applications in the background of EXCEL to make this work in my earlier program. Is this possible to do this in Brilliant Database without having to write code?
My intentions are not to have you do all the work but given the fact that I am only on day 5 of my Brilliant Database indoctrination, it is glaringly evident I have no idea on what to do - I certainly appreciate your willingness to help. One more question, on the file that contains the 'Completed Training' records, is it possible to enter the date that the training was completed? Ideally, the resultant field would have the identification of the 'Completed Training' and the date it was completed.
Please see attached.
What steps did you use when you tried to import this? I opened a blank BD and went to 'File' and 'Import/Parse' (is that the direction you went?). What is the next step? Attempting to open the file in the normal fashion still presents the same error message and then shuts down Brilliant Database.
MacHeuS has been extremely helpful and I would really like to see what he did!
I'm sorry, this one still presents the same error and then immediately closes the file. I am using the v9.42 Ultimate. I still appreciate your help though I would like to see what you did.
I am still curious if Brilliant Database will let a user initiate a query from one file while pulling information from another file? This seems like it would be a simple database function but there is nothing (at least nothing I could find) that would allow this basic ability. This should not require special, custom scripting since this is what databases are supposed to do.
I am curious if anyone has an example that they would be willing to share that uses contents in one folder (Folder A) and compares it to the contents in another folder (Folder B). Folder A and Folder B contains several items so it would need to be recursive (Folder A item 1 compared to Folder B item 1, Folder A item 1 compared to Folder B item 2, Folder A item 1 compared to Folder B item 3... until all components in Folder B are exhausted then it would loop back to the next item in Folder A - Folder A item 2 compared to Folder B item 1, Folder A item 2 compared to Folder B item 2, Folder A item 2 compared to Folder B item 3...). I can do this all day long in EXCEL but have reached a major stopping point with Brilliant Database... (i.e., I have been stuck at this point for the last week). I would think that this is a very basic request for databases but I cannot find any help with this request.
Continuing to utilize EXCEL for my project is not desirable as my main attraction to Brilliant Database is the fact that it is a stand-alone program. But... Brilliant Database is only an option if it can do the basic comparisons that are required. If I had just one example, I think that I would be in great shape and could then develop the other codes that I need from that one example... I am just stuck now and cannot proceed. PLEASE HELP!!!