field from another table...

doran_doran

Registered User.
Local time
Yesterday, 23:32
Joined
Aug 15, 2002
Messages
349
Form Name: frmgroups

I would like to show couple of fields from another table. Most of the field in my form is from one particular table called tbl_groups. However, I need to show phone number from another table called tbl_admin. Field name for phone is [phone].

frmgroups is based on tbl_groups.

Prompt respond will be appreciated.

tbl_groups has a field call primary_administrator. tbl_admin table has the same value for the name for that primary_administrator is contact. I did relationship.

Help will be appreciated.

Dianna Jamil
 
Two possible methods:

1. Create a SubForm

2. Use a Listbox control
 
Add your text field or label where you want the phone number to display. Then select the properties for this item and link it's source to tbl_admin.phone.
 

Users who are viewing this thread

Back
Top Bottom