Search results

That's great, many thanks. I'll give it a go trying to auto-generate the records in the subform.

I've attached a screenshot of my current table relationships which is hopefully relatively self-explanatory. The database keeps track of who worked various shifts at various depot locations. There are always 2 employees crewing each shift (never more, never less). As things stand at the...

Thank you very much for the links. This is my first foray into access; I've done simple customer - order - product databases in Lotus (blast from the past!) and tracking duty times in HSQL (Openoffice base). I still have plenty to learn but I think I have the raw basics down OK. I'll try to...

Thank you once again for the reply. I am trying to achieve a lot (perhaps too much!) I need to retrospectively track what occurred on each work shift - who worked the shift (always 2 people), which vehicle they used, how long the shift lasted and how much they used the vehicle. To complicate...

I am still struggling on this one, but I wonder if perhaps there is a more fundamental problem with what I am attempting to achieve. Is it possible to have two fields within the same table which are linked to one field in another table? A simple example of what I mean- tblEmployee with fldName...

Thank you very much for the prompt reply. I've been reading about junction tables as a means to many-to-many relationships but I am struggling to understand the examples sufficiently to solve my problem - I'll keep at it and return if I really can't make any headway. Many thanks once again

Hello all, My first post and so my apologies for it being a request for help! I have 2 tables. Table 1 contains a list of employees. Table 2 contains the work shifts. There are 2 employees per shift, call them 'Person 1' and 'Person 2'. Employees are referenced by their employee number...