Matrix Form to update table

[ali32j]

Hi All

I am trying to use a matrix type form with following items

Tables -
CustomerSupplierMatrix - holds information on the customer and the suppliers they use, this is the table to be updated

SupplierMatrix - Holds fixed details of suppliers

Ideally what i would like is, each time i open the form, i would like every supplier to show, using a check box onclick event it will add that supplier to the table customersuppliermatrix associated with the current customer.

Does anyone know the best approach for doign this?

Thanks

Ali

 

[Remou]

An append query would work. You will need to check if the customer already has that supplier if you don't want duplicates.

The normal way of doing this in Access would be to have CustomerSupplierMatrix in a subform of the main Customer table with the link child and master fields set to the customer ID and a combobox listing all suppliers (bound column would be supplier ID). The user would then choose suppliers from the list in each new record.