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

Adding a table causes query data to disappear,,,

stonward
100+
P: 145
Hi Guys,

I'm currently updating (major overhaul) a database system I built a few years ago. As part of that update, my Order Details table has several new fields: one of these is linked to a new table (one to many relationship from the new table to Order Details). When I add the new table to my query (that runs my point of sale subform) the data disappears.

Is there a way out of this - can you see what is happening? I have joined the table in the relationships window, enforcing referential integrity.

Thanks,

Stonward.
Sep 12 '07 #1
Share this Question
Share on Google+
4 Replies


stonward
100+
P: 145
Ah, hang on....is there a way by using sub queries? If i change the relationship type, I begin to get the data back...but so far not all the fields...
Sep 12 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Ah, hang on....is there a way by using sub queries? If i change the relationship type, I begin to get the data back...but so far not all the fields...
Forget about the forms for the moment. This is a structural / relationship problem. Look at it as a query and see how you get on.

Also check out this tutorial for guidance.

Database Normalisation and Table Structures
Sep 12 '07 #3

stonward
100+
P: 145
Hi Mary,

Yeah, thought I had everything at 3NF; but adding tables, and particularly fields to a system causes all sorts of troubles, eh?!

Thanks


R.
Sep 13 '07 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
Hi Mary,

Yeah, thought I had everything at 3NF; but adding tables, and particularly fields to a system causes all sorts of troubles, eh?!

Thanks


R.
No problem. Let me know if you run into difficulties.
Sep 13 '07 #5

Post your reply

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