Search results

Thanks jdraw, interesting to see your take on this. One thing that springs to mind (if I have interpreted your diagram correctly) is that the TripSession table would have a "ClientCount" entry every time I wanted to assign a guide to a trip. For example, TripSession (TripSessionID, TripID...

Absolutely. trip_names (tripNameID, tripName) 1 Half Day 2 Full Day 3 Heli Hike 4 Climbing trips (tripsID, tripsTripNameID, tripsDate, tripsClientNumbers) 1 1 01/08/2015 20 2 2 01/08/2015 12 3 3 01/08/2015 4 daily_schedule (scheduleID, tripsID, guidesID) 1 1 1 2 1 2 3 1 3 guides (guidesID...

I think the field name "TripNumber" implies some sort of ID number for the trip- not what I'm aiming for which is the total number of clients on a given trip. So ClientTotal or something similar would be more descriptive- that's the logic I'm working with at least. Nope, no need to know...

Hey jdraw, Thanks for the response. I have taken a look at the tables again based on your suggestions- could you please explain in a little more detail what you meant? I could create a client table, however I am not sure why this is necessary? The "ClientNumbers" field is a unique attribute to...

108 views... hoping somebody can offer some advice soon!

Hey Guys, Have been given great advice on this forum in the past- I would like to quickly clarify a table structure for a database I am working on. I appreciate those reading this invest some time in trying to visualize exactly what the person posting is trying to achieve so I will try to be...

There is another side to this that I have not yet explained... Equipment can also be assigned to a "Job", using same process when assigning it to staff. tblJobs has JobID as the primary key and foreign key in tblIssue. The situation I would like to "user proof" is the following- User assigns...

That works, thanks very much! However would it be possible to achieve the same thing while making the equipment available to select? The reason being I would like the user to know the reason why that particular piece of equipment is not available to select- ie. the user selects it and...

Thanks for the prompt reply! I kept my post brief to encourage interest but see now I may have out some important details... let me explain. 3 tables involved, tblEquipment, tblStaff and tblIssue. The primary keys are EquipmentID, StaffID and IssueID. tblIssue contains EquipmentID and StaffID...

Hi guys, I am trying to achieve the following- I want to query a table to see if a record exists with a particular field blank. If so, I would like to prompt the user for data. In real world terms, when assigning an item to a user I would like to first make sure that the item is not already...

Hey guys, Was wondering if anybody could help- I have a report which displays perfectly in Report and Print Preview modes but when I export to a pdf, the document width is clipped and does not show properly. Is this a known issue with a simple fix? I have googled and searched the forum but was...

Hi, I'm trying to achieve the following- ButtonA on MainForm to open FormA. When ButtonA is clicked, an inputbox prompts the user for a value and filters the records on FormA based on that value. I have a Select Case function on the On Open event of FormA, which inspects a field value on...

Hey guys, I have a couple of questions which I'm sure have simple answers- I'm just struggling to work it out myself. I would like to make a report consisting of multiple subreports. The main report is based on a query which has the following fields: JobNumber, EquipmentID, EquipmentType...

Ok, thanks guys managed to make this work :)

Hi Galaxiom, Could you lay that out for me in noob terms? I am not familiar with aggregate functions... My table names are tblEquipment, tblInspectionLog and the field names used are Inspection_ID, Inspection_Date and Equipment_ID Have tried a few variations of code I have found through...

Hello, I am trying to figure out how to query data in my database based on a number of different criteria. I have reached a stage where I can get all the data I need from one query, however I can't figure out how to further query this data to return records from a table with the most recent...

Wow. This is brilliant, thanks again for your help CJ- the setup you suggested works perfectly. I have tried it out with a few scenarios (jobs overlapping, staff leaving, equipment changing hands) and I'm very happy with the results. A few of the tools used are beyond my level of understanding...

Ok, managed to set up the screenshot you provided and I am able to query data as before, however I am still missing something- I'm sure you will be able to provide the answer! At present I am able to assign equipment from Kit_1 to staff through tblssue_1 and assign staff to jobs through...

Wow, that's more help than I'd ever anticipated- you have practically designed the entire database for me! I will look at this later tonight (6:45am here in Adelaide at the moment) and let you know how I get on. Thanks very much for all your help so far CJ!

Annnnd the system fails! I hadn't considered that possibility, and just like that it's back to the drawing board. In reality each staff member is assigned a harness, helmet and a few other bits when they start and that equipment stays with them until they leave the company or the equipment is...