A few questions. Is it possible through a query in the subform property to reference two different tables without issue?
The reason i ask is once i do this none of the items in my subform show when the subform is called up.
Maybe the problem is how i have the relationship setup.
I have one main table that shares universal information across all items/reviews in the db.
Then linked to that main table i have 20 other tables each different enough to warrant having that many.
My goal was to add another set of tables do to field limitations within a single table. So for each of the 20 tables there would one more table. In sum another 20 tables each one for a specific table. Each table shares the same primary key and unique fields to make sure they line up correctly. Question is what is the best way to link these tables. Is it best to have the one main table linked to all 40 tables? Or have it so it looks like 1-20-20 where the last set of tables is linked to the first set of 20? I hope this makes sense. I have this split and running on a server with access front and back end and my experience level is limited and still in learning mode.
I have included a copy of my db and back end which is empty. You can relink the fe/be and get it to work.
Once the main form loads you can see that when you select the cnr renewal form the form itself is empty. However the other forms will come up which im thinking is most likely to me having two tables either linked wrong or it isnt allowed in the same form.
My goal is to add an error field which you can see in the cnr cancellation and cnr endorsement forms. But, I was trying to come up with a date field for each item that would be triggered upon a selection and updated with each selection. So if someone selected open or closed etc a new date would pop up in a table. It owouldnt need to be viewed in the form. I am hoping there is an easy way to do this or repeat this as I am no vba expert. Is there a way to link a field based on a click or change of choice in another field to populate that field with an =date() or =now(result)?
I am more than open to help/input on this. The db is currently in use so i cant do drastic changes to the structure do to the prexisting data.
The reason i ask is once i do this none of the items in my subform show when the subform is called up.
Maybe the problem is how i have the relationship setup.
I have one main table that shares universal information across all items/reviews in the db.
Then linked to that main table i have 20 other tables each different enough to warrant having that many.
My goal was to add another set of tables do to field limitations within a single table. So for each of the 20 tables there would one more table. In sum another 20 tables each one for a specific table. Each table shares the same primary key and unique fields to make sure they line up correctly. Question is what is the best way to link these tables. Is it best to have the one main table linked to all 40 tables? Or have it so it looks like 1-20-20 where the last set of tables is linked to the first set of 20? I hope this makes sense. I have this split and running on a server with access front and back end and my experience level is limited and still in learning mode.
I have included a copy of my db and back end which is empty. You can relink the fe/be and get it to work.
Once the main form loads you can see that when you select the cnr renewal form the form itself is empty. However the other forms will come up which im thinking is most likely to me having two tables either linked wrong or it isnt allowed in the same form.
My goal is to add an error field which you can see in the cnr cancellation and cnr endorsement forms. But, I was trying to come up with a date field for each item that would be triggered upon a selection and updated with each selection. So if someone selected open or closed etc a new date would pop up in a table. It owouldnt need to be viewed in the form. I am hoping there is an easy way to do this or repeat this as I am no vba expert. Is there a way to link a field based on a click or change of choice in another field to populate that field with an =date() or =now(result)?
I am more than open to help/input on this. The db is currently in use so i cant do drastic changes to the structure do to the prexisting data.
