I’m using Access 97 and have created two main tables. The first is the patient demographic data, the second is their appointment(s) information/results. The problem is that there under the appointment information there could be procedure(s) that could have taken place. I’ve tried two thing: First I tried splitting up the appointment(s) table and took the procedure information out. Then created a query to link the patient demographic data and the appointment(s)data. Then took that query and linked the procedure table. But when I tried to enter data, it says the recordset is not updateable.
The second thing I tried was, keeping just the two tables, I linked them in a query and in my form (I’ve been using tab controls), I created a subform (using tab controls) and brought in the procedure data. My problem doing this is that since there can be multiple appointment dates, the subform is not picking up the current date. Is there a way I can set a tab control within a tab control page.
I don’t know vb, so any suggestions without using it would be greatly appreciated.
