Help! Help! Help!

[Guest]

Thanks for replying let me provide more info?

tbl_companies
company_id (Auto)
company_name (text)
company_address (text)
company_city (text)
etc...

tbl_submittals
sub_id (auto)
sub_projectname (text)
sub_description_of_item (text)
sub_manufacturer (number) <--------this is where the link must occur to
sub_supplier (number) <--- same the companies table or query.
etc...

Now, thought i could take the companies table and insert a check for
manufacture, supplier, etc then run two queries to generate a select from
list. I could do this with no problem but when i put a query that contains
these two queries and project table to pull the addresses my records do not
generate because for some reason it does not like to querries that are
generated from the same table present in a query. I dont know, help me out
here. key thing is that i must be able to print both addresses even if they
were for the same company which would be manufacturer and supplier.

feedback please

 

[John Vinson]

tbl_submittals
sub_id (auto)
sub_projectname (text)
sub_description_of_item (text)
sub_manufacturer (number) <--------this is where the link must occur to
sub_supplier (number) <--- same the companies table or query.
etc...

Now, thought i could take the companies table and insert a check for
manufacture, supplier, etc then run two queries to generate a select from
list. I could do this with no problem but when i put a query that contains
these two queries and project table to pull the addresses my records do not
generate because for some reason it does not like to querries that are
generated from the same table present in a query. I dont know, help me out
here. key thing is that i must be able to print both addresses even if they
were for the same company which would be manufacturer and supplier.

YOu need to add the Company table to the query TWICE - Access will
alias the second company tbl_companies_1 or something like that. Join
one instance to sub_manufacturer, and the other to sub_supplier; pull
the manufacturer address from the first instance, and the supplier
address from the second.

John W. Vinson[MVP]