newbee needs help with query

  • Thread starter Thread starter Yiannis
  • Start date Start date
Y

Yiannis

Hi Newbee here need some help :)
i have three tables, One has Product, one has Type of Product, and
the 3 rd. has storage type.
Now to make a query to filter the product name based on product type or
product storage,
How will it be the easiest and most efficient way?
Should it be done threw sort? or Criteria: and if someone can please
show me a example so i can try to put this together.
Thanks in advance for the help, going threw the books and the help
files but having
trouble finding what i need.
Thanks again John
 
Yiannis said:
Hi Newbee here need some help :)
i have three tables, One has Product, one has Type of Product, and
the 3 rd. has storage type.
Now to make a query to filter the product name based on product type
or product storage,
How will it be the easiest and most efficient way?
Should it be done threw sort? or Criteria: and if someone can please
show me a example so i can try to put this together.
Thanks in advance for the help, going threw the books and the help
files but having
trouble finding what i need.
Thanks again John
Click to expand...

More details please. At least tell us the relevant field names and
datatypes, as well as which fields are used to relate the data in the three
tales.

Better yoet, in tabular formt, show us some sample data from each table,
and, also in tabular format, the desired result based on the sample data
provided.
 
Hi Bob;
the tables are a)TBL-table b)TBL-storage c)TBL-type
A)tbl Fields are a)productID primary key, datatype AutoNumber (no
duplicates)
b)ProductName, datatype, text
c)ProductStorage, DataType, lookup
wizard Text
d)ProductType, dataType, lookup wizard
Text

B)tbl= Primary key a)Product Name, datatype Text
b)ProductStorage, datatype text

C)tbl= Primary key a)Product Name, datatype Text
b)ProductType, datatype text

Product ID Name of Product ProductStorage ProductType
1 Turkey Breasts Frozen Poltry
3 Pepper Jack Loaf Refrig. Dairy
6 Chopped Spinich Refrig. Vegetables
7 Salad Mix Refrig. Vegetables
9 Chick Peas Dry Goods Can Goods
10 Kidney Beans Dry Goods Can Goods

ProductName ProductStorage
Chick Peas Dry Goods
Chopped Spinich Refrig.
Kidney Beans Dry Goods
Pepper Jack Loaf Refrig.
Salad Mix Refrig.
Turkey Breasts Refrig.

Name of Product ProductType
Chick Peas Dry Goods
Chopped Spinic Vegetables
Kidney Beans Dry Goods
Pepper Jack Loaf Condoments
Salad Mix Vegetables
Turkey Breasts Poltury
And also how can I make it to update the fields in TBL-Storage and
TBL-Type every time I put an item in TBL-Products? Thanks again for
taking the time to help me.

John
 
Yiannis said:
Hi Bob;
the tables are a)TBL-table b)TBL-storage c)TBL-type
Click to expand...

These are the table names? TBL-table?
A)tbl Fields are a)productID primary key, datatype AutoNumber (no
duplicates)
b)ProductName, datatype, text
c)ProductStorage, DataType, lookup
wizard Text
d)ProductType, dataType, lookup wizard
Text

B)tbl= Primary key a)Product Name, datatype Text
b)ProductStorage, datatype text

C)tbl= Primary key a)Product Name, datatype Text
b)ProductType, datatype text
Click to expand...
I do not understand this structure. What is the purpose of tables B and C?
You appear to be storing the same information that is contained in table A
.... with some strange exceptions: why is the product storage for "Turkey
Breasts" "Frozen" in table A but "Refrig." in table B?

And also how can I make it to update the fields in TBL-Storage and
TBL-Type every time I put an item in TBL-Products? Thanks again for
taking the time to help me.
Click to expand...

Let's take this one thing at a time. I think if you correct your database
design, you won't be storing the same data in two separate places, so this
question will become moot.
 
Back
Top