Hi everyone
This will be simply answered I know but I am having trouble getting my head round relationships (of the Access kind and generally day to day but to keep things simple lets stick to my Access problems!)
OK, could someone explain in as simple terms as possible how I can do the follow, I know its easy for you guys but for me I have a headache.
So, in simple terms I want to create a data base where I have a list of companies (my table called "companies") with their address and telephone number. I then want a second table that contains all of the employees (my "employee" table) for each company.
I then want to create a form where I can input the data of the companies (I have no problem doing this) and a second form where I input the list of employees. In the second form I want a drop down box where I can select the name of the company from table "companies" but I also want to display the "companies" address and telephone number (also held in table "companies" as soon as I choose the company name. Also if I change the company name on the "employees " form it should update the table "companies"
As I have said I have a headache as I know I am nearly there but not quite....
Cheers everyone, paracetemol please
This will be simply answered I know but I am having trouble getting my head round relationships (of the Access kind and generally day to day but to keep things simple lets stick to my Access problems!)
OK, could someone explain in as simple terms as possible how I can do the follow, I know its easy for you guys but for me I have a headache.
So, in simple terms I want to create a data base where I have a list of companies (my table called "companies") with their address and telephone number. I then want a second table that contains all of the employees (my "employee" table) for each company.
I then want to create a form where I can input the data of the companies (I have no problem doing this) and a second form where I input the list of employees. In the second form I want a drop down box where I can select the name of the company from table "companies" but I also want to display the "companies" address and telephone number (also held in table "companies" as soon as I choose the company name. Also if I change the company name on the "employees " form it should update the table "companies"
As I have said I have a headache as I know I am nearly there but not quite....
Cheers everyone, paracetemol please