Search results

I need to make use of this value multiple times so it would be extremely helpfull if I could write it back to a table.

I have a form called Account with the following fields on it as textboxes which pull values from an underlying table called Account. OriginalBalance TerminMonths DiscountFactor Additionally there is another textbox called PaymentDue which has the following formula under the Control Source...

I have a form called Account with the following fields on it as textboxes which pull values from an underlying table called Account. OriginalBalance TerminMonths DiscountFactor Additionally there is another textbox called PaymentDue which has the following formula under the Control Source...

Pat thank you for your reply and sorry for not responding sooner, I went ahead and moved my managers into my employee table but the next problem that comes to mind is now I have a many to many relationship. A department can have 1 to many employees and An employee can manage 1 to many...

and the ER diagram

Here is the Form

I have several tables as follows. Department DepartmentID(Primary Key) DepartmentName(Text) MgrEmployeeNumber(Text) Foreign Key from Manager Table. Manager MgrEmployeeNumber(PrimaryKey) LastName(Text) FirstName(Text) Employee UserEmployeeNumber(PrimaryKey)...

If you need to fire an event upon inserting a record into a field its time to upgrade to SQL Server 2000

Thanks for your help Tim. I moved the data to a backup table, made a new table with the Autonumber field, imported the data into my new table, changed the foreign keys from text to number, and reset the relationships and everything works perfectly now. Thanks again for your help.

I have several tables as follows. Department DepartmentID(Primary Key) DepartmentName(Text) MgrEmployeeNumber(Text) Foreign Key from Manager Table. Manager MgrEmployeeNumber(PrimaryKey) LastName(Text) FirstName(Text) Employee UserEmployeeNumber(PrimaryKey)...

This link is neccessary since a managers first and last names are fed to the employee form from the managers table.

ERD Diagram Here's the ERD Diagram which didn't make it here the first time around.

I'm working on a Access Database to manage different employees in a company. I have 5 different tables but the important tables are Managers, Employees, and Departments. A manager can manage one to many employees and departments, and a department can have one to many employees. I have a form...