I'm looking for advice on how to handle this. I have a members table. And I have a Committees table. A member may belong to one or more committees.
So I assume in the members table I need a committee ID field that stores the committee ID number that the member belongs to. But what if they belong to more than one committee? How can I handle the storage of multiple committee IDs?
you have to create a third table
table name - MembersCommitte
fields ID, memberId, CommitteId
see this demo
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved. W…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…