One thing I've noticed in my quest for knowledge with this database is in the Access forums when you ask a question, you get a lot of "Just don't" responses. That being said, I don't learn from "just don't". I know what I need/want to do, this is how (in my limited knowledge) I think I can get it to work, but it's not working. If there is a different/better way, please explain so that I can learn.
That being said I have two tables (Customer & Plant) that I want to use as a lookup for a field in a third table (Details). Instead of having two fields (ShippedToCust and ShippedToPlant, only one of which would ever be filled at a time) on the Details table, I would like just one ShippedTo field. As far as I know, you can't do a lookup from two tables. I've tried to do a simple select query and I've tried to do a union query. The union query just dumped all of my plant records into the customer columns. When I run the select query, it runs, but it brings back nothing.
Is there a way to do this, or do I just need to put two fields in my table and then on the report make whichever one is blank not visible?
Thank you in advance for all your help.
That being said I have two tables (Customer & Plant) that I want to use as a lookup for a field in a third table (Details). Instead of having two fields (ShippedToCust and ShippedToPlant, only one of which would ever be filled at a time) on the Details table, I would like just one ShippedTo field. As far as I know, you can't do a lookup from two tables. I've tried to do a simple select query and I've tried to do a union query. The union query just dumped all of my plant records into the customer columns. When I run the select query, it runs, but it brings back nothing.
Is there a way to do this, or do I just need to put two fields in my table and then on the report make whichever one is blank not visible?
Thank you in advance for all your help.