Adding records from one table to another

[JanTore]

Hi all,
I'm trying to find a solution to add records from one table to another using a selectbox with different options.

Background:
I've put together a database to organise a "warehouse" and I want to control outgoing and incomming equipment. On each job I have several items going out as standard items, depending on the size of the work crew.
IE:
Small crew
Torqwrench - 4 pieces
Hammer - 3 pieces
Medium crew
Torqwrench - 8 pieces
Hammer - 6 pieces
Big crew
Torqwrench - 12 pieces
Hammer - 9 pieces

So made the tables:

Jobs: JobID, ClientID, Date, Location
JobDetail: JobID, EQID, NumberOfItems, NumberOfReturn
Equpment: EQID, EQCategoryID, Item, ItemInStock
EqupmentCategory: EQCategoryID, Description
Crew :CrewID, CrewDescription(Small, Medium Big)
CrewDetail: CrewDetailID, CrewID, EQID, NumberOfItems, NumberOfReturn

I’ve tried the append query to append the records to the table JobDetail but that didn’t work.

As I mentioned above I’m looking for a way to select from a selectbox/combobox the standardset depending of size of the crew witch is located in the tables Crew/CrewDetail to append to the table JobDetail,
So I don’t have to put in 30 or more items in the table/form JobDetails every time I send out Equipment.

Hopefully I've managed to describe my problem in sensible way for you to understand, if not please ask for more info

regards
JanTore

 

[MazeWorX]

For starters somewhere in your "Jobs" or "Job Details" table you' ll need to store the CrewID. Right now I dont see a link between the tables. Remember amateurs built the ark - professionals built the Titanic