Populating Multiple Facilities

[mpaulbattle]

I have searched for weeks on this request, but cannot find anything. My team has asked if there is a way to populate the facility locations per practice. For example Practice A has one location and Practice B has four locations. When Practice B is selected they would like all four locations to show on the form, but if Practice A is selected only show that one location. I have two tables, Practices and Facilities. They are related by the PracticeID as the FK in the Facilities table. I have looked into the DoWhile Loop but I'm not sure if that is going to produce what they're asking. I haven't written anything yet.Just trying to get pointed in the right direction.

Can this be done? All responses will be greatly appreciated

Thanks in advance.

[pbaldy]

Is this what you're looking for?

Baldy-Cascading Combos

[mpaulbattle]

Not quite.
On the Practice form, there is a search box where usually they search for by the Mnemonic field in the Practice table. When that practice pulls up they click open and it opens to the practice detail form. On the form it has three tabs. The Practice's information regarding the programs they participate in, Notes, and Facilities. Right now it only shows the first location of each practice. If it has more than one they would like those to show as well. I thought about adding enough text boxes and making them invisible if isnull, but someone said we can just have the facilities populate. I think the most would be 15 facilities for one practice.

[pbaldy]

I don't think I'm visualizing what you want. Can you attach a sample db here that shows it?

[John_G]

The data structure you are describing is a one-to-many relationship between practices (the "one") and facilities (the "many").

This very common structure is often implemented using a form-subform arrangement. In your case, one of the tabs on the main form would contain a subform to display data for the different facilities for the practice currently shown on the main form.