TheArgyll
New Member
- Joined
- Oct 26, 2015
- Messages
- 14
Hello All,
I am continuing work on my database and I am now at the point where I am putting a user interface together.
I have Employees (t_People) who each may have multiple of each of the following:
Addresses (t_Address).
Email Addresses (t_Email).
Telephone Numbers (t_Telephone).
The Employees are stored in one table and the Addresses/Email Addresses/Telephone Numbers are in 3 separate tables. How can I count the number of Addresses/Email Addresses and Telephone Numbers the currently displayed Employee has and set three textboxes on my form to display these values?
Thanks!
Rob
I am continuing work on my database and I am now at the point where I am putting a user interface together.
I have Employees (t_People) who each may have multiple of each of the following:
Addresses (t_Address).
Email Addresses (t_Email).
Telephone Numbers (t_Telephone).
The Employees are stored in one table and the Addresses/Email Addresses/Telephone Numbers are in 3 separate tables. How can I count the number of Addresses/Email Addresses and Telephone Numbers the currently displayed Employee has and set three textboxes on my form to display these values?
Thanks!
Rob