By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 2,334 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Added field in related table messes up records on form

P: 3
I have 4 tables, 1 'main' and 3 others. All 4 tables are related by the same common feild. One of the others is related to the main by a one to many relationship. The other two are related to the main by a one to one. All these tables feed one form. The table with the one to many relationship is a subform, the other two tables are simply 'feilds' on the form. Works beautifully. That is until I add an additional field to one of the one to one tables. When I return to the form, it no longer shows any records. They still exist in the main table, but I cannot see them. I need to be able to make changes to all the tables and still use the form. Does anyone know what is wrong here? I appreciate any help.
Aug 2 '12 #1
Share this Question
Share on Google+
4 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,062
Seeman,

How do you have the record source for your form set up? The subform makes sense for the one to many table. Do you have a query that feeds the main table? You should be able to create a query, with all required fields, that populates that main form, and still use the primary key to master/child the subform.

I'd need to see how it is set up first in order to recommend changes. If you can post a sample of your DB....

Let me know, and we'll try to figure this out.
Aug 3 '12 #2

P: 3
twinnyfo,
I certainly appreciate that you are willing to help me figure this out, but it may be a challenge. I'm certainly no Access expert and I do not even know what you mean by your very first question. I do not know how I have the record source set up. Or what that means. Or where to look to see, if I knew what I was looking for. And I'd love to post something for you, but I'm not sure what you need to see. All I did was create the 4 tables, go to a blank form, pull the one to many over to create a subform and pulled the feild from the other table onto the form using the 'add existing feilds' tool. Does that provide you any information to help me? And I do not have any queries at this time. I didn't know queries fed tables, I thought they just pulled and organized informtion from them. See, no expert here...lol
Aug 3 '12 #3

twinnyfo
Expert Mod 2.5K+
P: 3,062
Seeman,

Please don't take offense to this, but although this forum is for assisting those with questions and conundrums, the assumption is that posters will have a basic knowledge of database management. Before we try to get too deep in to answering your question, I would recommend you take a look at some more foundation principles concerning db management. This forum has many good articles on db normalization and basic, as do other sites. Please take a bit of te to understand the basics, so that we can talk the same language, and I will be glad to assist.

I would provide some links, but I am working from my phone right now.
Aug 3 '12 #4

P: 3
twinnyfo,

No offense taken. I was just taking a stab at getting some help. I've spent so much time looking through the help and stuff online and I cannot find anything to help me. I found this place and took a shot. After everything I've already searched through and all the time I've already spent I think I'm just too frustrated to continue searching for answers and reading stuff I do not understand. But I do thank you for your attempt.
Aug 3 '12 #5

Post your reply

Sign in to post your reply or Sign up for a free account.