- Joined
- May 1, 2013
- Messages
- 1
- Reaction score
- 0
I am using infopath form connected with MS Access Database
Such DB contain two tables
1. client details
2. billing
Client details table contain following fields
Client ID (autonumber)
Name
Address
Billing table contain following fields
bill no. (autonumber)
Client ID
Name
Date
Description
Amount
i have also design form to insert data of client in client details table
my query is that by inserting only client ID in billing form, the field of client name fill automatically, is this possible? if yes then HOW?
Such DB contain two tables
1. client details
2. billing
Client details table contain following fields
Client ID (autonumber)
Name
Address
Billing table contain following fields
bill no. (autonumber)
Client ID
Name
Date
Description
Amount
i have also design form to insert data of client in client details table
my query is that by inserting only client ID in billing form, the field of client name fill automatically, is this possible? if yes then HOW?