CustomerID Form - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

CustomerID Form

Amina Jones

4 years ago

I have a database where I have two types of clients. Employee and Customers. I have two separate tables for each. I also have a pymt table to track payments for each client. The pymt table identifies the type of customer (employee or regular customer) I have two forms, one for employee & one for customer, and each form has a pymt button. I also created a pymt form for the pymt button to view and add pymts.

The issue I am having is adding both the CustomerID and the EmployeeID to the field to the pymt form. I have to add them in order for the pymt to show but it leaves a blank box for the employeeId field if I am viewing the customer form and the same when I view the employee form. Is there a way to get both IDs to show without the blank box showing but still showing the ID number for that type of customer?

	Amina Jones OP @Reply 4 years ago

	Amina Jones OP @Reply 4 years ago

Scott Axton @Reply

4 years ago

Short answer is it depends.
Please give us some additional screen shots and description on your data source.
It kind of sound like to me that you're trying to use the same form for two different tables.

You may need to re-visit your table structure as well. People are people no matter how you classify them.
You might, for instance, have John Smith as both an Employee and a Customer. He could also be a Vendor.
So instead you are looking at a Person Table and a Group Table to classify them.

Amina Jones OP @Reply

4 years ago

the database is for a fitness center at a college. Faculty/staff that work for the school have to pay a fee each semester to use the service and they have the option to refer family and friends who will pay a fee mthly (so the customers are linked to the employees as referrals. I did created one table for the pymts because i thought i can use there PK as FK to track their pymts and from the pymt table I created one pymt form.

	Amina Jones OP @Reply 4 years ago

	Richard Rost @Reply 4 years ago
To make things much easier for yourself, I would put customers and employees together in the same table (call it People) and just indicate which is which with a field IsCustomer or even a number. 1=Employee, 2=Customer, 3=Faculty, etc.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View