Difficult Form Design and Functionnality: require guidance

[DajTwo]

Hi all,

Despite several combinations of form/subforms, I am unable to achieve the following and I am asking for guidance and ideas to achieve this functionality.

Background

A group of customer is created by the user, each group has a unique ID ([group_id]) and a group has several Customers.
Each customer has a unique ID ([ccan_rel])
These 2 fields are stored in table [tbl_group_rel]

Each customer (within each group) has at least one (and up to 20) credit limit (one per manufacturer) stored in tbl_crd_lmt. That table has an autonumber ID, each customer is identified with their ccan number and each customer cannot have more than one line with a specific manufacturer and the list of manufacturers is available through a combo box lookup.

1) The goal of the form ([frm_crd_adm]) is upon drop down selection by the user (that works)
2) Display read only information on the different Customers associated with the group (that works in a subform ([crm_crd_adm_sub_info])
3) Then allow the user to enter data in tbl_crd_lmt (though a query) only for the Customers of the group, which [ccan] should be available in a droop down. (that I cannot do)

Any ideas on how to achieve # 3?

I hope this overview was clear.

Thanks in advance


If I did not say it before, I really appreciate the time and expertise of the users on this forum.

 

[DajTwo]

I decided to simplify the form and allow the user to enter the ccan himself contrary to have the CCAN in a drop down. Larger margin of error but will put an error code on the exit form btn.

Thanks

If I did not say it before, I really appreciate the time and expertise of the users on this forum.