Hello,
I am completely new to MS Access however, I’ve been learning my way through. I have created several tables that are linked via a primary key of “patient ID.” Unfortunately, whenever I try to place all the fields from each of these tables onto a single form or even a multiple tab form, the “wizard” says that I am “Out of range.” I think that means I cannot add that many fields using the wizard.
So, I’ve created 3 forms; each containing a multitab form with approx. 4 tabs each. Is there a way to link the forms so that when I type in a unique patient ID in the first form, that patient ID is carried throughout the other 2 forms thereby create one large record for that particular patient?
Any comments or advice would be greatly appreciated.
Regards,
Anthony