Recent content by MLBall

OK. That's easy enough. But I still don't understand how to populate tblTripStaff through the subform. At this point, every time I try to select someone, I just get a BING sound, without any indication why.

Ahh. Good point. Though, I don't think so. Because I'm just using an autonumber for external people and we're using the 'last 4' of SSN for internal people. Can I get my autonumber to always be a 5-digit number, just in case? Or is the Union query not really worth it?

Right now I have tblTrip - tblTripStaff as a one-to-many relationship and both tblStaff and tblExtPersonnel as a one-to-many relationship with tblTripStaff. I think that's wrong, but not my entire issue.

Thanks for the quick reply. I have those three tables. I just don't know how to set up the (I assume) subform to allow users to select which staff member(s) to attach to each trip and then add new or select existing external people to add to the trip.

Thank you for the super-speedy reply! No. There won't ever be overlaps between internal and external people. They are definitely either one or the other, though they will combine in various combinations on trips.

I feel like this shouldn't be the huge challenge that it's becoming, but after days for searching for an answer, here I am begging for help. I have the following tables: tblTrip, tblStaff, tblExtPersonnel and tblTripStaffing. My main form is frmSite, with a subform called sfrmTrips. The subform...