Recent content by enigma12121

But that would fill the list box with every thing in the So Deatil table not just the ones for the particular so I want.

how can I write the sql query to only include the part numbers of the parts that are in the SO right now this is the SQL behind the brop down box SELECT [tblSODetail].[Part_ID] FROM tblSODetail WHERE [tblSODetail].[SO_Num]= (What ever the SO number is) Also will this work for list boxes...

Here's the set up. Right now I have a drop-down box, that contains Part numbers that are in a certain Sales Order. Those part numbers are listed in tblPart, with a part type. Is there anyway that I can easly find out the parttype with just the part number. I need to be able to so differnt...

The porblem is is that I don't want to copy all of the sales orders. I only want to copy over the ones that match the Sales order number + the part number But thanks for letting me see a differnt way of attacking the problem

I want to know an easy way to fill a record of a table with the data from another table Here is goes. Right now I have two tables one is for shipping the other is the Sales Order behind it. When I want to ship an item I open the subform for shipping and it copies the Sales order number into...

I have a table that conatians the line items for each Sales Order that is contained in a different table. What i want to do is have each set of line items be autonumbered either in the table or in the form so that when it gets displayed in a form you can see exactly which line of the SO it is.