Question How do i associate a coverage panel to record through a form?

[krazieddi]

I have a list of customers in a table (tblCUSTOMERS) and a list of hundreds of items in another table (tblITEMS). The relations ship between customers and items are many to many.

The form i'm using needs to have a coverage panel showing what parts are associated to the customer when updating their information. Ultimately, the data will be queried by what customers associate to specific parts.

I have an array of check boxes with the different part numbers displayed, but i don't know if or how this can be queried against.

My question is for suggestions on how I can go about achieving this many to many relationship.

PLEASE HELP!


Thanks all!


-ed

 

[CJ_London]

1. make tblcustomers the recordsource of your main form
2. make tblitems the recordsource of your subform
3. in the subform control set the linkchild and link master values to the relevant fields in the subform and main form respectively

 

[krazieddi]

CJ_London:

how would a user choose the items for a customer? would they use a list box and select everything that applies?

-ed

 

[David R]

Subform should either be Continuous or a datasheet. Each entry will have the CustomerID as a Foreign Key, and an individual item on that line (combobox is probably best, multi-select listboxes are problematic). Next line will have the next item for that Customer/order/whatever...

 

[CJ_London]

can you post the details of the tables you have at the moment that relate to this problem I expect it to be along the following lines

tblCustomers
CustomerID autonumber PK
CustomerName text
etc

tblItems
ItemID autonumber PK
ItemName text
ItemPrice currency
etc

tblLink
LinkID autonumber PK
CustomerID long FK
ItemID long FK

But I am concerned on what basis you are linking customers to items - I would expect this to be through an invoice table structure