Recent content by bharathsadanand

Oops.. Sorry .. am a few down... it should read 1.1 2.1 3.1 4.1 5.1 .... etc... got the numbers mixed up. For the second Order Id it should read 1.2 2.2 3.2 4.2 5.2.... etc... Sorry about that my bad ... just saw it...

Ok so what I thought was like this... Each Order has a number of Order Items... Like Order 1 may have Line items 1-50.... So I wanted to create the OrderDetails Primary Key in a way that shows all the line items sequentially associated with the particular order.... So if I had order 1 with 5...

I think Im confusing myself... I already have an autonumber PK in that table... which I can use to reference each ID..... guess I dont need more than that..... will figure out... and shout out if I need help. Thanks B

Getting close.... So what I Did was pasted the following in my Line No field. =LTrim(Str(DCount("OrderID","[Order Details]","OrderID=" & [OrderID]))) & "." & LTrim(Str([OrderID])) It is picking up the max entry as per order number i.e. for Order no 1 - which has 2 records. It is filling up...

HI All, I have 2 tables Orders and OrderDetails. The Order ID is the primary key in Orders and is a foreign key in OrderDetails. OrderDetailID is the primay key in the OrderDetails table. Now I have an Orders form with an OrderDetailsSubform What I want to do is create a sequential record...

Thanks Paul... got it to work. Used the following. Private Sub RetailorProject_Change() If Me.RetailorProject = "Retail" Then Me.Order_Details_Subform.Form.UnitPrice = Me.Order_Details_Subform.Form.ProductID.Column(2) Else Me.Order_Details_Subform.Form.UnitPrice =...

Sorry to bug you Paul... but still struggling... I have entered =IIf([Forms]![Orders]![RetailorProject]="Retail",[Me].[UnitPrice]=[Me].[ProductID].[Column](3),[Me].[UnitPrice]=[Me].[ProductID].[Column](4)) in my control source for my UnitPrice text box field. Is that correct??

Ok I think i got that part right for ProductID in the sub form... next step is to try to link the result of the chosen value of RetailorProject to this link..... I have typed in the following into the Control Source of "Unit Price" in the sub form...

So im trying to put in "SELECT RetailorProject.Orders,UnitPriceRetail.Products,UnitPriceProject.Products From Orders, Products" into the Row Source of RetailorProduct combo box in the Orders form... is that correct... ]

Hmm... "not the way Id go"... is something that we need to discuss... coz I want this built proper.... I tried to normalize it as much as possible... but my concepts are a bit hazy.... dont want to build something that will break later... so plz comment on what I have done so far and I will...

Paul if the zip file asks for a password... type in livingwatersystemz and it should get you through. Regards Bharath

Hi Paul, I am herewith attaching my work so far... please let me know if I have built the db correctly. The problem Im having is with the form Orders. Thanks for the help. Appreciate it.

Thanks for your reply but I have already gone through that thread.... and quite didnt know how to implement. Dont know if im doing something wrong... need hand holding. So what Ive got is Parent Form with Field: RetailorProject - that has its record source as the Orders table. ( In the...

Hi All, I have 3 tables. 1) Products 2) Orders 3) Order Details. I have created a form that has the order on top and it has a sub form with the order details in the bottom. (So basically 1 order will have multiple rows) I have a combo box that shows "Retail" or "Project". Based on what the...

First of all a big HI!! to all you folks out there. Just joined this forum as I am currently working on creating an access db for my friends company. It is about 30% done and I need your help in completing it. Have been in the IT field for over 11 years and I am pretty good with Excel...