Recent content by J.Burt

@GaP42 Thank you for your input. I understand to the degree that I am able. The database is live, I do have a copy of the database, test on the copy, identify and fix issues, and then migrate/make changes to the live database. I realize the example given is very simple and I am using these...

Thank you for the offer. This is still a project I am slowly working on. While I would like for it to be done and not have to think about it anymore, I do need to understand and figure out some of the issues for myself, so I can speak intelligently about the database when I pass it on at some...

All of this has been really helpful. The discussion and being able to see how the tables are connected is greatly beneficial. I have yet to take a look at the files, but I will let you know.

Can you explain this? For a given rescue or call a crew member may have multiple activities that we keep track of, ie. Hoist operator, hover load operator, NVG's, ALS Assist etc. I'm not understanding how this will track these for each crew member without having a multivalued field.

For clarification, tblCrewActivity will assign a Primary Key number for each entry? CrewID and OperationID are both foreign keys, so for example, on a given operation, tblCrewActivity would produce a unique number for each entry, each employee would have their unique ID, but the Operation ID...

That sounds right to me.

By chance how big can the zip file be? I have down to 16mb, but obviously too big. Is it best to just delete a bunch of records? Still seems to big even doing that. I can't express enough gratitude for the help and offers to help everyone has given me. Thank you.

Passengers are for documentation purposes only and are either classified as a medical transport, trauma transport or a rescue. These are a public service and the passengers are not billed. We bill government agencies, mostly for Wildlands fire responses but occasionally for other flights such...

GaP42 thank you for your input and advice. Currently just trying to conceptualize what needs to be done and put a frame work on paper to work off of. Ha ha! So do I, thank you for the offer to help.

Thank you for the response Pat. I will have to decode some of this in my head and then ponder on it for a bit. Thank you for the sample database, I will definitely take a look at it.

Good Morning, Afternoon, or Evening where ever this happens to find you. I have inherited a database that was created with the intention for tracking flight and crew information for a helicopter operation. The database was designed by a member of our organization with minimal experience in...

Good Evening, I have a flight card database that I am attempting to use to show currency for personnel. Without listing everything the database has, for this question I am pulling three types of records (medic, flight date, medic activities) from one table [Flight Card]. The medic activities...

Good Evening, Morning, or Afternoon! After searching through the forum for a couple days, I decided to register. I currently live and work in Southern California and somewhat recently took over managing an Access database. I work at an Aviation Unit for the county I live in which happens to...