choose more than one value from a table list

[Orson9750]

My database has several tables. 2 tables are set up with a one to many relationship with a 3rd tble right now called tbljoin. Main table is a list of agencies with physical address, etc. the detail table is a list of 47 care options. So one agency can have many care options. I created a form listing the major table of agency information and now I am at a loss as to how to add care options from the care options table so that each agency record shows which care options it offers. I did attempt a sub-form but that did not work as you will see.

I have attached the DB for convenience.

Your expertise is appreciated.

 

[ezfriend]

You will need to change couple things:

tblJoin
pkFacilID - should be a number (not AutoNumber) since it is foriegn key.

For you form "CCL Residential Care Facilities", the subform needs a view that contains link between the tblJoin and Care Options table.

This will allow you to link the "CCL Residential Care Facilities" and the subform by pkFacilID (Link CHild Fields & Link Master Fields)

For this type of relationship, you will need to create a form where user can select different care options and apply to the facility. Meaning, insert the pkFacilID and pkCareOptionsID into tblJoin.

 

[Orson9750]

Thanks for your quick response. I will make the changes.

 

[Orson9750]

Your advise did the trick. Thanks much