TurboDieselOne
Registered User.
- Local time
- Today, 16:48
- Joined
- Jan 16, 2003
- Messages
- 39
Now I have a table Called Actions
This has A field: Clients That Looks Up as below in Table Design view Lookup
SELECT Names.IDNames, Names.Company, Catagory.Type FROM Catagory INNER JOIN [Names] ON Catagory.IDCatagory=Names.Catagory WHERE (((Catagory.Type)="Client")) ORDER BY Names.Company;
Next Field is Called Job
And is meant to lookup up the Job in Table Jobs
Which has the same Client as the Field “Clients” as above
What do I need to add to
SELECT Names.IDNames, Names.Company, Catagory.Type FROM Catagory INNER JOIN [Names] ON Catagory.IDCatagory=Names.Catagory WHERE (((Catagory.Type)="Client")) ORDER BY Names.Company;
So I only see the Jobs relating to the company that are in the previous field which is called
Any Clues
Thanks I have been on excel so long forgot too many database skills
Thanks again
Any Clues
This has A field: Clients That Looks Up as below in Table Design view Lookup
SELECT Names.IDNames, Names.Company, Catagory.Type FROM Catagory INNER JOIN [Names] ON Catagory.IDCatagory=Names.Catagory WHERE (((Catagory.Type)="Client")) ORDER BY Names.Company;
Next Field is Called Job
And is meant to lookup up the Job in Table Jobs
Which has the same Client as the Field “Clients” as above
What do I need to add to
SELECT Names.IDNames, Names.Company, Catagory.Type FROM Catagory INNER JOIN [Names] ON Catagory.IDCatagory=Names.Catagory WHERE (((Catagory.Type)="Client")) ORDER BY Names.Company;
So I only see the Jobs relating to the company that are in the previous field which is called
Any Clues
Thanks I have been on excel so long forgot too many database skills
Thanks again
Any Clues