Search results

So just to clarify i make a prices table and i list all the product numbers and leave the client number blank and that becomes my generic price list?? then any clients that have special prices i make another entry in the datasheet and insert their client id number followed by their price.

Thanks Geotch I would appreciate a quick example. I think I understand most except how to formulate a generic price that goes by defult when there is no secondary price for that client/product.

Hey there i am looking for a way to have different prices saved for each individual client. I would have one main price list but i want to set certain items to have special prices for different clients. How is this possible in Access in excel its so simple. Thank:D

Watched the videos and it was good for a bit of background information but i still dont see how to make this relationship work. Depending on the client i need the order details table only show certain products... Would i combine all products in one table instead of 2 separate ones and then...

Hi guys i realized that i was a bit over my head and took a few steps back using the sample north wind data base as a stepping stone to correct my tables and relationships. Attached is what i have so far in relationships but now i need to add a few things to my data base that work for my...

Thanks So far i have updated my relationships because they were not done correctly in the first place, i managed to create some combo boxes but not baced on 2 different fields still having trouble with that... I also dont think im out of the woods yet because in my order details table it...

Hey there i am very new to access and am having trouble wraping my head around the logic and method needed in order to create a data base that records weekly orders. What types of tables do i need? How can i input more than one product per order? How do o group the information in a organized...

Private Sub ComboArticolo_AfterUpdate() On Error Resume Next ComboTaglia.RowSource = "Select ProdotiPescaT.Taglia " & _ "FROM ProdotiPescaT " & _ "WHERE ProdotiPescaT.NomeProdoto = '" & ComboArticolo.Value & "' " & _ "ORDER BY ProdotiPescaT.Taglia;" On...

Hi there very new access user and im sure this is a very simple question. Basically in my order details table i have the following fileds Product Unit Size At the moment i have the Product field with a dropdown that gives me all the products from my ProductT. But once i choose the correct...

Hello Access users, i am a beginner access user. I am looking to learn as much as i can as quick as possible. I am Canadian but living in Italy at the moment running my business. Looking forward to start posting and say thanks in advance for all the help i will defiantly need. My first project...