Search results

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.

To be honest I have not got to that point yet. I am sitting on dozens of excel sheets and need to convert them into one big database. I am in the planning and learning stage at this point. The data base will be used for the following 1. Sales persons requests for estimates 2 Estimator...

:confused: Could Someone point me in the direction of some info on relationships. I have a basic understanding but I start to get lost on when to use certin types of joins.

Clarification: I will be building a form that will ask for the State and City. County Should auto fill in And a combo box should offer the zip codes in that area. I will then need to Autofill in other items: Tax Rates , Distance, Drive Time And Hotel Rates Tax Rates Depend on State, County...

With the following tables tblStateList IDStateList (AutoNumber Key) StateName tblCountyList IDCountyList (AutoNumber Key) CountyName tblCityList IDCityList (AutoNumber Key) CityName tblZipCodes tblZipCodes (AutoNumber Key) Zipcode What would be the best way to set up...

Solved. Thank you, That worked perfect.