ereyes
New Member
Hi
Hope you can help me.
I have three tables: Inventory, Companies and Invoices
Inventory fields
I also need to show the name of the company in the inventory table -> 4. Company Name
The problem is that from the inventory table I can only access the id of the company through the invoice table.
How I can access the name of the company?
Inventory table -----> Invoices table <--------> Companies table
Thank you very much for your help.
Hope you can help me.
I have three tables: Inventory, Companies and Invoices
Inventory fields
- Id_Inventory (key)
- Item
- Id_Invoice (Invoices databasejoin - Label: Invoice Number )
- Id_Company (key)
- Company name
- Id_Invoice (key)
- Invoice Number
- Id_Company (Company databasejoin - Label: Company name)
I also need to show the name of the company in the inventory table -> 4. Company Name
The problem is that from the inventory table I can only access the id of the company through the invoice table.
How I can access the name of the company?
Inventory table -----> Invoices table <--------> Companies table
Thank you very much for your help.