Hi there,
I have 5 tables, one for each company.
Each table holds invoice information for each company.
They are seperate because the invoices come in completely different formats depending on the company.
I would like to assign string values, such as "Company A" to the table corresponding to Company A.
That way when a user selects Company A from a combo box, the database knows that its supposed to use its corresponding table.
Any idea on how I am supposed to do that?
I have 5 tables, one for each company.
Each table holds invoice information for each company.
They are seperate because the invoices come in completely different formats depending on the company.
I would like to assign string values, such as "Company A" to the table corresponding to Company A.
That way when a user selects Company A from a combo box, the database knows that its supposed to use its corresponding table.
Any idea on how I am supposed to do that?