It uses Access in Office XP.
It is a case management system which ties volunteers to "clients".
There are many tables but the ones which seem to give the problems are as follows:
volunteers (the usual fields id, name, email, phone etc)
client (similar)
case (id, date received, date placed, notes etc)
junction (linking caseid and volunterid)
There is a form which shows the client details and then a tab. In the tabbed part is a list of all cases. Double clicking on this goes to another main case edit form which lists all of the dates, notes etc.
I can currently enter data into the volunteers pages but can put nothing into the case edit part using the forms.
Is that enough or are other details needed?
