I have a query based on a combobox on a form. Of course only the number is stored. I cannot for the life of me figure out how to get the data not the number to show either in the query or a report. The data is stored in a table by itself.
query showing wrong data
- Thread starter joeatact
- Start date
joeatact said:
Sorry for not suppling more details I have attached copy of the database. I again cannot seem to figure out how to show the actual data not the stored index number. And I am a beginner.
For example Instead of motherboard type it should print ak79 not 1.
Joe
Fizzio
Chief Torturer
- Local time
- Today, 17:30
- Joined
- Feb 21, 2002
- Messages
- 1,884
Your link fields to in the main table should be Number and not Text. To show the model in the query. Your Db needs a little bit work. I have had to alter the relationships to reflect the new structure and re-built the frm... query to look correct.
The Db does need work and I would strongly recommend doing some background reading before you go any further. Look at the MS site for tutorials and topics on normalis(z)ation. You are nearly there but if you get deeper in, you will undoubtedly come across problems.
I note that you have used the caption in the Table Design for each field. While this makes building forms easier, it makes queries a bit harder to fathom out. Because you have done this, the Processor, Op Sys and M/board all are displayed as 'Model Number'. I would also (in my opinion) avoid using the same fieldnames for many tables - I would have used ProcessorModel etc to make the fields easier to differentiate between.
I cannot for some reason get the file size down enough to post back
There seems to be some problems compacting the Db even after importing the Database into a clean File
The Db does need work and I would strongly recommend doing some background reading before you go any further. Look at the MS site for tutorials and topics on normalis(z)ation. You are nearly there but if you get deeper in, you will undoubtedly come across problems.
I note that you have used the caption in the Table Design for each field. While this makes building forms easier, it makes queries a bit harder to fathom out. Because you have done this, the Processor, Op Sys and M/board all are displayed as 'Model Number'. I would also (in my opinion) avoid using the same fieldnames for many tables - I would have used ProcessorModel etc to make the fields easier to differentiate between.
I cannot for some reason get the file size down enough to post back
There seems to be some problems compacting the Db even after importing the Database into a clean File
Thanks for the help. I have tried to create one table with 6 items in it one being mboard_ID, model.manufactor,cost,sell,vendor1,vendor2
I created another table with a keyid no, and a number field to hold the info from the other tables model's field. It works the number is there for the item but I guess I cannot get the relationship right for all that I see is the number the data doesnot show up
Joe
I created another table with a keyid no, and a number field to hold the info from the other tables model's field. It works the number is there for the item but I guess I cannot get the relationship right for all that I see is the number the data doesnot show up
Joe
