If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Multitable searching
I'm posting this in the design group because I'm actually trying to think of
different ways to design this thing. I say thing because it's become more of a monster then a dbase. And one quick note, please don't comment on my naming conventions. I'm not a professional nor will I ever expect to be one. But I am far more capable then anyone else in my company and figure I will continue to be the closest thing to an MVP that they'll have without outsourcing. No offense to anyone. : ) On to the problem. I've got 7 facilities that have to keep up with "bad" product produced. I've got the table design built and implemented at one facility already. It's working great, but my original plan was to use one table and have the users select a location which would store a location ID# in the main table. I could then use another form attached to a query that would search the main table based on the location chosen and some other variables available. Well, come to find out, not everyone can use a mouse correctly. I can't trust that the user will choose the correct location. So my plan was to make 7 identical tables and just set the input form to change it's source table based on which location they choose on the Main Menu. My issue is that I can't use my queries or reports anymore. Is it possible to query the same field over multiple tables. For example, every table has the TicketNum field. Can I search for a specific TicketNum across 7 tables? Or is this just a bad design all together? I can code the form to change the source table based on which location button is chosen, but I can't do the same for the queries. It has to search all tables for the same thing. I'm pretty sure I'm not making the best sense, but any suggestions would be helpful. And if I need to clarify something, please let me know. Garrett |
#3
|
|||
|
|||
Stevie, our local troll is at it again
"Steve" wrote in message
news BTW, if you need to outsource any Access, Excel or Word work, I provide help for a very modest fee. Just contact me at . Steve Okay class, repeat after me, "These newsgroups are provided by Microsoft for FREE peer to peer support. Stevie is a known troll who really does not grasp that simple fact" Stevie, your proposal is totally immodest and it is obvious that you lack the skills for competing with the professionals. We are still waiting for you to update your PCDatasheet website with a hint of content. What is it? About six years of "Coming Soon!!!" John... Visio MVP |
#4
|
|||
|
|||
Stevie, our local troll is at it again
"John... Visio MVP" schreef in bericht ... "Steve" wrote in message news BTW, if you need to outsource any Access, Excel or Word work, I provide help for a very modest fee. Just contact me at . Steve Okay class, repeat after me, "These newsgroups are provided by Microsoft for FREE peer to peer support. Stevie is a known troll who really does not grasp that simple fact" Stevie, your proposal is totally immodest and it is obvious that you lack the skills for competing with the professionals. We are still waiting for you to update your PCDatasheet website with a hint of content. What is it? About six years of "Coming Soon!!!" Steve is not "Coming soon!!!" He is just breathing heavily.... ;-) Arno R |
#5
|
|||
|
|||
Multitable searching
Steve,
Thanks for the help. I hadn't thought of that. It would definately cut down the tables and prevent mistakes. As for the outsourcing, I'll keep you in mind, but I hate to tell you, one of our key principals is to be the "lowest cost provider" which usually gets me a big fat NO when I request to spend money. But like I said, I'll keep you in mind. Thanks again, Garrett "Steve" wrote: Seven tables is a bad idea! Consider using seven identical forms except for LocationID. Make the LocationID field on the forms hidden and on each form set the default value for LocationID appropriate for the location where the form is being used. With this setup, anytime someone enters data on their form, Access will automatically assign the appropriate LocationID for the location where the data is being entered. BTW, if you need to outsource any Access, Excel or Word work, I provide help for a very modest fee. Just contact me at . Steve "CorporateQAinTX" wrote in message ... I'm posting this in the design group because I'm actually trying to think of different ways to design this thing. I say thing because it's become more of a monster then a dbase. And one quick note, please don't comment on my naming conventions. I'm not a professional nor will I ever expect to be one. But I am far more capable then anyone else in my company and figure I will continue to be the closest thing to an MVP that they'll have without outsourcing. No offense to anyone. : ) On to the problem. I've got 7 facilities that have to keep up with "bad" product produced. I've got the table design built and implemented at one facility already. It's working great, but my original plan was to use one table and have the users select a location which would store a location ID# in the main table. I could then use another form attached to a query that would search the main table based on the location chosen and some other variables available. Well, come to find out, not everyone can use a mouse correctly. I can't trust that the user will choose the correct location. So my plan was to make 7 identical tables and just set the input form to change it's source table based on which location they choose on the Main Menu. My issue is that I can't use my queries or reports anymore. Is it possible to query the same field over multiple tables. For example, every table has the TicketNum field. Can I search for a specific TicketNum across 7 tables? Or is this just a bad design all together? I can code the form to change the source table based on which location button is chosen, but I can't do the same for the queries. It has to search all tables for the same thing. I'm pretty sure I'm not making the best sense, but any suggestions would be helpful. And if I need to clarify something, please let me know. Garrett |
#6
|
|||
|
|||
Multitable searching
"CorporateQAinTX" wrote in
message ... I'll keep you in mind. Please also keep this in mind: http://home.tiscali.nl/arracom/whoissteve.html |
#7
|
|||
|
|||
Multitable searching
Man, I just went through the link you posted. Jeez, does this guy have an ego
or what?!? I'm glad I learned quickly, but isn't there some way for the group administrators to get together and block this guy somehow? Anyway, I saw the post and had to check it out. "Keith Wilby" wrote: "CorporateQAinTX" wrote in message ... I'll keep you in mind. Please also keep this in mind: http://home.tiscali.nl/arracom/whoissteve.html |
#8
|
|||
|
|||
Multitable searching
On Mon, 8 Dec 2008 08:39:01 -0800, CorporateQAinTX
wrote: Man, I just went through the link you posted. Jeez, does this guy have an ego or what?!? I'm glad I learned quickly, but isn't there some way for the group administrators to get together and block this guy somehow? If there were group administrators, that would be reasonable; but this is an open, peer-to-peer support group without moderators. -- John W. Vinson [MVP] |
#9
|
|||
|
|||
Multitable searching
I thought of one other thing. I've already got 2 forms for entering data. One
is used to enter new data and its source is the main table. The second is for editing data and its source is a query. The query prompts the user for a ticket number and then produces the previously completed form for editing, or at least that's the way it looks to the user. Is it possible to use the same form for both. I've set the form's Data Entry Only property to yes. So they can't just scroll through all of the records. Is there a search code that I can put in the background to find a record when the user enters a ticket number? If not, then 7 forms turn into 14. Thanks again "Steve" wrote: Seven tables is a bad idea! Consider using seven identical forms except for LocationID. Make the LocationID field on the forms hidden and on each form set the default value for LocationID appropriate for the location where the form is being used. With this setup, anytime someone enters data on their form, Access will automatically assign the appropriate LocationID for the location where the data is being entered. BTW, if you need to outsource any Access, Excel or Word work, I provide help for a very modest fee. Just contact me at . Steve "CorporateQAinTX" wrote in message ... I'm posting this in the design group because I'm actually trying to think of different ways to design this thing. I say thing because it's become more of a monster then a dbase. And one quick note, please don't comment on my naming conventions. I'm not a professional nor will I ever expect to be one. But I am far more capable then anyone else in my company and figure I will continue to be the closest thing to an MVP that they'll have without outsourcing. No offense to anyone. : ) On to the problem. I've got 7 facilities that have to keep up with "bad" product produced. I've got the table design built and implemented at one facility already. It's working great, but my original plan was to use one table and have the users select a location which would store a location ID# in the main table. I could then use another form attached to a query that would search the main table based on the location chosen and some other variables available. Well, come to find out, not everyone can use a mouse correctly. I can't trust that the user will choose the correct location. So my plan was to make 7 identical tables and just set the input form to change it's source table based on which location they choose on the Main Menu. My issue is that I can't use my queries or reports anymore. Is it possible to query the same field over multiple tables. For example, every table has the TicketNum field. Can I search for a specific TicketNum across 7 tables? Or is this just a bad design all together? I can code the form to change the source table based on which location button is chosen, but I can't do the same for the queries. It has to search all tables for the same thing. I'm pretty sure I'm not making the best sense, but any suggestions would be helpful. And if I need to clarify something, please let me know. Garrett |
#10
|
|||
|
|||
Multitable searching
Steve,
Nevermind...I figured it out on my own. And John, I understand that this is a place for FREE help and I'm pretty sure everyone else does as well. I'm the one that made the note regarding outsourcing. Please keep the public downgrading off of my posts. I may not be a professional db programmer, but at least I act with some professional ettiquette. (Which is far more important in the business world!) Thanks again Steve! |
Thread Tools | |
Display Modes | |
|
|