Jump to content

Help pulling information from other tables


This topic is 5720 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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 automatic serial number - assign it to a client with a drop down and this pulls in the people working for 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 (client, people etc... from the job table that has been set previously

this i cannot seem to do

any advice would be grateful

thanks

Link to comment
Share on other sites

Are you relating:

People - Clients - Jobs - Quotes

Or are you relating:

People - Clients - Jobs

&

Jobs - Quotes

If the former double check all your relationships, i.e. that quotes is related to jobs by a foreign key to your jobs primary key... If not the former... make it the former :D

~Genx

Link to comment
Share on other sites

This topic is 5720 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.