whoknows361
Technical User
Hello all.
I have 2 tables:
tbl_Referral_Data
Referral ID (autonumber) PK
client name
client address
client dob
etc.
tbl_Open_Episode
Referral ID (as each referral ID has only one Open Episode)
Admit Date
Date Sent to Billing
I want to create a form which will display a combo box where users will be able to pick the client name which has an open episode form completed. So they would pick the client name.. Then fill in the Admit Date and Date Sent To Billing Fields, and this would automatically add the record to the tbl_Open_Episode, including adding the Referral ID frm tbl_Referral_Data to the Referral ID field in tbl_Open_Episode. But I can't seem to identify how to do this. Your help is appreciated..
I have 2 tables:
tbl_Referral_Data
Referral ID (autonumber) PK
client name
client address
client dob
etc.
tbl_Open_Episode
Referral ID (as each referral ID has only one Open Episode)
Admit Date
Date Sent to Billing
I want to create a form which will display a combo box where users will be able to pick the client name which has an open episode form completed. So they would pick the client name.. Then fill in the Admit Date and Date Sent To Billing Fields, and this would automatically add the record to the tbl_Open_Episode, including adding the Referral ID frm tbl_Referral_Data to the Referral ID field in tbl_Open_Episode. But I can't seem to identify how to do this. Your help is appreciated..