Sales Forum

[ainstien]

Hi,

I am new to access and was working on a project to record a sales process for a company.. I have made the following tables as shown in the image.



I have completed the customer form but am stuck on the sales form. I cannot get to make a sales form that will update all the existing tables when the process is recorded.

The requirement is :

1. The agent must have the ability to enter new customers into the database.
2. The sales contract form should be fully automated. This includes automation of the original data entry by the agent, approval by the supervisor, and indication of payment status by the cashier.
3. The supervisor must have the ability to enter the amount of the daily deposit into GL Cash account.

Any help would be appreciated?

[ainstien]

Also, I was hoping any assistance could be provided in how to use dlookup. I need to derive the description in the order form from the inventory table, such as the description for a car would be generated when its id is punched in.. Something along the lines of a vlookup for excel..


Thanks

[alansidman]

Here is a link on how to use DLOOKUP http://www.techonthenet.com/access/f...in/dlookup.php