Looking for Database Update Tables Example

[Kristi.owen091010]

Hello! I am new to Access and I am working on a database that has five different tables in it.

Businesses
Employees
Employee Security Method
Employee Accounts
Business Comments
Employee Comments
Business Repetative Form

I am looking for an example of a database that has a form attached that easily updates multiple tables. Ideally I would like a form that has the options:

Add New Business (this leads to adding new Employees and updating all of the other tables)
Add New Employees (this would just skip the add new Business part)
Edit Business


Edit Employee

There are more fields I will need to build but this is where I am starting. Eventually I need a cancel employee button that would move it to a cancelled table. A cancel Business and Employees button (same idea). I am also going to be generating ID number for them and re-issuing them as needed. So I will need to figure out something for that too. Any help would be greatly appreciated!!!!

[rpeare]

Your best bet is to build a form/subform for your businesses/employees tables, then whenever you entered an employee in the subform it would automatically be attached to the business represented in the main form, especially if you're not keen on coding/unbound controls.

if the relationship between your businesses and employees is 1 to many I would keep enforcing that, so let's say you had a bunch of self employed people you could have a 'self employed' company with all of your self employed people under that company, or, if it's more practical, give each individual person their own company name.