Recent content by Newbwan

That's good to know. Look-up not good to use under any circumstances.

This is defiantly a design flaw, I thought I understood, but do not and thus now must correct. :)

I see.. it is not a query problem but a straight up design problem. Got it.. not sure about fixing it, but as rain lover mentioned there is no foreign key. So in short table look-up is bad bad bad... at least the like criteria. Thanks

Brian - I think yes. The fields ITEM and COMPANY in Price:Table are a look-up to DESCRIPTION in Item:Table and COMPANY in Company:Table.

jdraw - and anyone else that wants clarification - :D - You got it :rolleyes: - I think I got that :confused: - Possible problem In post 17 you identified yourself as the Customer. :D You Purchase Parts from different Suppliers.:D These different Suppliers have different identification...

I think Brian understands what my issue is, but seems to be at a loss like myself. I hope this post can clarify things for you guys. 1. Yes the way to identify items is using the description, I have used the auto number as the primary key. 2. I have systematically stripped all like statements...

Slow down my friend, My brains about to explode. I am not selling anything. This entire database is supposed to list where to buy. I am the customer here. What I mean is that for every part there are multiple companies to purchase from. Each company has its own price and part number for each...

Yes, yes I can :) Company:Table Id (KEY),Company,Phone,Contact 1,Gregg's Lugs,895.965.1258,Lisa 2,Bobs Wheel,895.965.1856,Sam Item:Table Id (KEY),Description 3,5/8" Chrome Plated Lug 4,1/2" No Plate Lug 5,5/8" No Plate Lug Price:Table Id (KEY),Company,Item,Part Number,Price 6,Gregg's lugs,5/8"...

I have started a Thread in queries, but it has been mentioned that the query looks good and it may be a design flaw. I have link the other thread (best I can) below... I can't I haven't posted enough uhm - add website to front? NOPE. here is the title then.. maybe now? Like "*" & [What Item] &...

Thanks but this is not a sales database, it is a purchasing database. The price is different for each company on similar parts. (And is updated once every two months) ex. Item - Company - Price - Part Number Blue Towel - Bobs Clothes - 1.50 - 15698bl Blue Towel - Lisa's - 1.29 - bltwl12 The...

Company : TableFields Id (KEY)- Company - Phone - Fax - Contact - Location - Shipping -Manager - Regional Sales Item : TableFields Id (KEY)- Description Price : TableFields Id (KEY)- Company (see below) - Item (see below) - Part # - Price The PRICE:TABLE pulls the COMPANY:FIELD from...

That's too bad, for me. Thanks for the help anyway... anyone else out there? ;) Enjoy your food, and being all busy in your retirement :D.. some day I will be busy too.

Yeah the data looks right in the table. Everything matches to where it is supposed to. This query is the only thing I have other then tables. No other query's no forms, nothing. :banghead::confused: :banghead:at the moment these smiley represent my thinking process :D there are three tables...

Well, then something odd must be going on.... I do not know if it makes a difference, the Item field and Company field are being pulled from separate tables. When I type a number ( ex 8 )into the search parameter I come up with results, is it a possibility that access is searching the ID field...

I didn't code this, this is the result of access after typing the LIKE "*"... into the criteria section of the query, I hope this helps. SELECT Price.Stock, Price.Company, Price.Price, Price.[Part Number] FROM Price WHERE (((Price.Stock) Like "*" & [What Item] & "*") AND ((Price.Company) Like...