Help required with simple task

[odobo]

I am writing a small database that will track jobs - i have created tables that store clients, people, jobs and quotes - so far i can create a job with a serial number - assign it to a client with a drop down and this pulls in the people assigned to that client so i can chose who requests the job

in the quotes i need to select the job number from a drop down and have that pull all the information into the quote from the job table that has been set previously

this i cannot seem to do

any advice would be grateful

thanks

Edited March 13, 2006 by Guest