Recent content by nickdawes28

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...