Search results

I decided to put the invoice item number in the invoice detail table... now...how do I set it up so when I input the invoice item number, rest of the details are filled up using previous invoice detail table's records?(if there is any). and also how I do show the details of the product on the...

The attachment is the database Im working on and I have a problem. I need to add a supplier Product number in there some where so I could keep the numbe as reference and so it may be easier to enter items recieved. in the form section, I will have Invoice with a sub form Invoice details. I need...

In the order form of the northwind database you could enter the product name or scroll through and pick the product. How do I set it up like that so I could enter manually with word Predict(dont know if that's what its called)and also if the product is not on the product table, make a product...

Thanks Pat! That did the Trick...

how do I set up supplier name in the order table like the example in the northwind database? what I mean is set supplier ID so that it shows combo box with names instead of numbers.

I have table with item details...in the item details, I need to put the weight of the item in order to calculate the Price Per Pound. but the problem is that not all items are calculated by pound and some of them just need to have individual weight entered to so we could identify which is large...

Thanks scott...gotta replan.... this is driving me nuts...

ok...I understand about names and calculations... but what do I do about ones without item number...? the items that I get come with an item number and most of them have it, but not all. I would like to use the item numbers that come with it since they're all different from company to company...

hmm...what I was gonna do was break up all the vendors by table...like tblvendor1,tblvendor2,and so on...so your saying that isnt the way to go? what I was thinking was if I had all that in one table, since what I get is not small amount every week, it would get crowded...and would fill up a...

Thanks Scott... but this is for my invoices that I get...not give out...:) I get lots of stuff from different company as this is for a retail store.. what I am trying to do is input all of the invoices so I could track price changes and price difference between companies. and Thanks Wayne...

Thank but Im getting errors... run-time error "3464" Data type mismatch in criteria expression...

Thanks for the reply but... how do I do this automatically? meaning I wouldn't have to create buttons or whatever...just input the item number and it would automatically search for last record of that particular item number if there was one and auto fill. or is this a bad idea? Sorry Im a...

I have a table with date,item number,quantity,price.and so on... Im using form to input new record and is there a way to automatically search the table and if I enter the item number, it will fill in the rest of the values with the previous record of the specific item number? since the only...

What Im trying to do is make invoices that I have in to data base... reason for it is to keep a close watch on the price fluctuation since the stuff we get are from different country. We don't really need it but this is my own little project just for myself...I have all the tables made and form...