OK, I really shouldn't be asking for help with this but I'd be greatful if you could get this tidied up quickly. :o
OK, I'm working on a database of people's daily activities. The main form I use is based off various tables including an acivity table. How do I add a new entry to the activity table?
Ok, here it goes:
Got these tables:
CompanyTbl:
CompanyID (PK)
Name
Street
etc.
NAICS1(this is a standard industrial code, a 6 digit number telling about their product/service)
NAICS2
NAICS...6 (company can have 1-6 NAICS codes)
A layman has no clue what these NAICS code are, so each and one of them has a descriptive title, like NAICS 32330 = Canned Vegetables Manufacturing
For this puropse, I designed a second table:
ProductTbl
ProductTitle (PK)
NAICScode
Purpose:1. Be able to query by ProductTitle and get all companies with that profile.
2. Be able to retrieve Company ID with all its NAICS code/s and corresponding ProductTitle/s.
Now one company can have up to 6 NAICS codes and one NAICS code can appear under the descirption of multiple companies. So a many-to-many relationship. But how? A third table, probably....But how?
I just found out something that was pretty cool about Office 2007, specifically Access 2007 and Outlook 2007. Working with them together, you can create an email form to gather data for Access and when the email is returned, all filled out, Outlook will export the data into your specified Access table.
I just played with it a little and it appears to have some issues when dealing with multiple tables, but for a simple data gathering it would seem pretty cool. In fact you can set it up so that it won't automatically process until you want to, or you can have it process right when the email comes in.
Supposing you have 4 Tables
1.)User
2.)Admin
3.)Teacher
4.)Pupil
Now the "User" table has the ff. fields: ID(auto num),FName,MName,LName,User,Pass,Type.
Now what I want to do is, if I add a new a record in the table "User" and if the record has the data "Admin" in the field "Type" then the record should also be saved in the table "Admin" but if the data is "Teacher" or "Pupil" then it should be also saved in their respective tables.
Question is: Is that possible? If yes, then how??