Recent content by bnickelsen

I am building a database and need a little push in the right direction. This database will be used to build estimates for our customers. Here are the steps. 1. Sales Person turns in a request for a new estimate to one person who will log the request and setup the basic info for the request...

Here is what I have: tblItemList: IDItemList AutoNumber Field ItemName Text Field tblGroupingList IDGroupingList AutoNumber Field GroupName Text Field tblItemDetail: IDItemDetail AutoNumber Field fkToItemList Number Field Joined to tblItemList ItemVender...

Yes every Job has a uniqe number, I planed on using that as the filter.

That would be posable.

I am still learning as I go... I Guess I am still trying to understand how Append and update work. If I am understanding correctly Append add new records. Update changes records. So for this task, I would need an append query to add new Jobs. And then an update for the ones I already have...

Let’s say I have a text (Delimited) file. I have a linked table to this file. The file is updated weekly. I want to track each update. First question: Can you have both an Append and an Update query from the linked table to the tracking table? Or will it take some code to pull that off...

I think I am on the right track. I attached what I have so far. I know I need to work on naming the tables. Just looking for oppions on Relationships. Any comments would be appreciated

More info. As I try to think of the best solution I keep coming up with more questions. So I thought I might expand on what I need in hopes that I might work it out or someone may see what I am missing. Ok from the Tables above Item is actually Locations and the variable is a cost rate for...

Another Question? I can see how this might work. But As I Think about the form I will need to make I am not sure this will work. For the imput form I would like to Have a drop down box with a list to select the item to work with. Then have a data sheet layout for the varible. Showing all...

Thank you. Will give that a try.

I am having trouble visualizing how to break out the following info into functional Tables I have a table to hold Items tblListG1Items IDItemList ITemNumber ItemName I then have a detail table tblDetailG1Items IDItemDetail FKToItemList ItemMFG ItemMSP ItemLead Here is where...

Solved Thx Doc Thank you for the info.

I imported an Excel Sheet into a database. In this sheet were several coulums list travel time from one place to another. In this sheet the time in minutes. ie 120 was the same as 2 hours. Anyway Now that it is in my database it is still in the number format. Is there an easy way to convert...

I have 3 table Table 1 is a list of parts. IDParts (PKAutonumber) PartNumber PartName Table 2 is a list of System the parts can be used in. IDSystem (PKAutonumber) SystemNameShort SystemNameLong Table 3 is a join table for the firts two IDPartToSysJoin (PKAutonumber) FKToPartList...

For the most part.