A
Avyn
I have a database to track potential customers.
First table is customer information (company number, name, address, and product types).
Second table is contact information (contact name at each company with their phone number, email, etc.).
Three other tables contain specific product information based on the product types associated with that customer in the first table.
Primary key is company number (and contact name in second table).
I have a form to enter new companies. I have buttons on that form to go to contact information, and each product type. Is there a way to automatically add a company number to the contacts table, so that when the user clicks the contact button, they can enter contact information without re-entering the company number? Also, I would like to do the same thing with the product tables, only when the product type is set to Y in the first table.
I am not familiar with changing the VB, so I have been trying to work with only macros.
Thank you in advance!
First table is customer information (company number, name, address, and product types).
Second table is contact information (contact name at each company with their phone number, email, etc.).
Three other tables contain specific product information based on the product types associated with that customer in the first table.
Primary key is company number (and contact name in second table).
I have a form to enter new companies. I have buttons on that form to go to contact information, and each product type. Is there a way to automatically add a company number to the contacts table, so that when the user clicks the contact button, they can enter contact information without re-entering the company number? Also, I would like to do the same thing with the product tables, only when the product type is set to Y in the first table.
I am not familiar with changing the VB, so I have been trying to work with only macros.
Thank you in advance!