Hi I'm using access 2010 to access db2  data from 4 tables, using the  linked tables option to connect the data, this all works fine. I have created a form with the main organisation table and 3 subforms for location people and inventory, for editing and adding to these tables. I am using an unbound combo box to look up search for organisations and this seems to work fine except the records between location and people and location and inventory they don't seem to get added to the correct location, the same if I add a new record it always gets added to the last location record.

The location table has a link Master fields of Organisation_Identity with link child field of organisation identity. The People table has a Link Master fields  of [MASTER_LOCATIONS].Form![LOCATION_IDENTITY] and link child fields LOCATION_IDENTITY.

How do I filter the people when a specific location is selected, I am pretty new at access so your help would be appreciated.

    

---

Reply from Richard Rost:

I would need to see your database to really help you with this. It sounds like you have a pretty complex setup there and I can't visualize all of it based solely on your description.

As long as you have the Parent/Child fields set up correctly, you should be able to add multiple subforms without a problem. I've covered this in a couple of my lessons. Problems can come in, however, if you have multiple subforms based on different KEY FIELDS (one on customers, another on orders, for example).

If you want to send me your database to take a look at it, you can use the TechHelp page... but without seeing it, it's really hard to get an idea of what the problem is.