Search results

Hi everyone! I'm working with three tables: tblclient, tblassessment, tblchild. tblclient is linked one-to-many to tblassessment. tblassessment is linked one-to-many to tblchild. I've got three forms: frmclient, frmassessment, frmchild. What I'd like is when the client opens frmchild...

Argh! I'm screwing up something with my table relationships but I just can't figure it out. Basically, I've got a main table with several tables linked to it via one-to-one relationships. I broke the data into several smaller tables (11, to be precise) so as to keep it manageable. The...

Hi everyone: I've got two tables, TblClient and TblAssessment. I've linked them through clientID. I've placed an Open Form button on FrmClient. It opens FrmAssessment. It works correctly in that clicking the button opens FrmAssessment with the correct clientID. However, it opens to the last...

I'd like to know if I can autopopulate a numeric field in a table based on the text in another field. For example, TblMain contains two fields: Status and Value. Status field is listbox of values such as Yes and No. I'd like to automatically populate Value field with a number based on the value...

Still very much a newbie at Access, so apologies up front for the raw simplicity of this question. I've got a main table TblMain and a junction table TblJunction with a one-to-one relationship. I'm using TblMain as the form and TblJunction as a subform. Clearly, I'm missing the bit where a...

I'm having trouble figuring out how to best structure the tables for the following scenario and I'm hoping you'll have some brilliant ideas. The db is for taking assessments. Each assessment consists of numerous items for which the user must assign a level of importance (i.e., Very important...