T
Tim
I'm out of practise and need some help.
I have a datbase, a section of which, allocates tools to
staff. All staff get the full compliemtn (eg 20) of
tools.
Schema is
Staff------<Tool_allocation>------tool
I have the database set so that every new staff member
gets all 20 tools allocated straight away.
My problem. I need to add a new tool. I need to make an
update or append query that will add this new tool to all
the existing staff who have the existing 20 tools and now
need the 21st adding.
Bit lost, help appreciated.
Tim
I have a datbase, a section of which, allocates tools to
staff. All staff get the full compliemtn (eg 20) of
tools.
Schema is
Staff------<Tool_allocation>------tool
I have the database set so that every new staff member
gets all 20 tools allocated straight away.
My problem. I need to add a new tool. I need to make an
update or append query that will add this new tool to all
the existing staff who have the existing 20 tools and now
need the 21st adding.
Bit lost, help appreciated.
Tim