Recent content by mikecohn

Thank you all. You've really been a good help. I'll input the data I've collected over the last few months and play around with it.

Thanks for your help. Is there anything else I should complete before I begin to tackle forms?

Yikes, I think I see what I did there. My sample data wasn't up to par. I'm with you on Warranty and Paid, they're going to stay in TripInfo, because they vary by trip. However, the same Shop Order will pop up in multiple different trips. As in, Trip 1 and 4 were both to the same Shop Order...

Mihail, I believe I gave a pretty decent explanation of the business in my first post, but I'll try and repeat it more clearly for you. I don't know where this "employees and salaries" thing is coming from, though. I think you might be getting lost in translation, perhaps. Anyway. Like I said...

For example: TripID......ShopOrder.....Warranty .. 1............50000............x .. 2............40000............ .. 3............87655............ .. 4............50000............x The technician went to the same job-site ("50000") twice in this illustration. Does it...

Thanks for your input, folks. I've taken EmployeeID out of tblTripInfo and slimmed down tblFlightInfo. So here's my next catch: I know I'll have a different TripID for every trip, that's a given. However, many trips will be to the same site. (For example, travel to fix Shop Order# 12345...

Hi all, First-time poster, long-time reader. I'm endeavoring to make a small database for my Field Service dept. I'm getting stuck in a few places, but I was thinking I could show you all my tables/fields and let you pick at them, and then maybe move on from there. As a background, I have...