Database Design | Forum profile

On Fri, 4 Dec 2009 08:07:01 -0800, Terri (donotspam) wrote: OK here goes, hope this is clear I am wanting to set up a database where info is selected in one field and then multiple fields are populated. EG entering username from drop down list automatically fills in Name, Dept and Ext so save looking all those up each time. In excel I would use the lookup function and put formulae in each cell. Is this possible in access? Any help greatly...

Steve, FK = Foreign Key. When you relate a Primary Key to a field, that field is referred to as a Foreign Key. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Steve Haack" wrote in message ... Gina, Can you tell me what you mean by FK? "Gina Whipp" wrote: Steve, Ummm, do you get a message? What...

smile -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Keith Wilby" wrote in message ... "Gina Whipp" wrote in message ... You are looking for a reason to argue and I was simply answering a post. Don't try to engage in a battle of wits with an un-armed opponent.

In a very simplified way, your existing tables presumably look something like: TblCustomer CustomerID FistName LastName TblRentalItem RentalItemID RentalItem RentalItemPrice TblRental RentalID RentalDate CustomerID TblRentalDetail RentalDetailID RentalID RentalItemID Invoices are then created from the four tables. Rental Price is gotten from RentalItemPrice in TblRentalItem. In your new system, you need to add a new field, RentalPrice, to...

How is this a "tablesdbdesign" question? You'd probably get a lot more response if you posted in a forms-related newsgroup... Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered...

perhaps I need a junction table between the staff and the kit Yep! AssetIssue -- AssetIssueID - autonumber - primary key AssetID - Number - Long Integer - foreign key StaffID - Number - Long Integer - foreign key DateOut - DateTime - Default - Now() DateIn - DateTime EstReturn - DateTime IssueBy - Number - Long Integer - foreign key Create one-to-many relationships between Staff and AssetIssue & Asset and AssetIssue, selecting...

Gina, Can you tell me what you mean by FK? "Gina Whipp" wrote: Steve, Ummm, do you get a message? What happens when you try? I'm going to make a suggestion here... I would have set up the table differently... tblPeople pPeopleID (PK - Autonumber) pBadgeID (Set to no duplicates but I can change when I like) tblEvents eEventID (PK) eDirector (FK-linked to pPeopleID) eManager (FK-linked to pPeopleID) The above way allows...

"Steve" wrote: I would like to offer to help you. I provide fee-based basic help with Access, Excel and Word applications. Let me design and create your database for you. My fee would be very modest. If interested, contact me. Go away. We don't want you here. Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog -...

This is a rare casse where I disagree with the other respondents. An invoice is an entity, and, roughly speaking, a one time event. At the time of the event it is derived from other data, but, after that, the result becomes an entity. Like taking a photograph of an event ....at that moment, it is "derived" from the scene, but then the photograph becomes and entity to be stored. You can't "re-derive" it...

Thank you John, It is really a small db and should be simple, but I haven't had much experience setting up a db and appreciate an help you can give me. The amount values that will be entered into the db are the totals for the year (going forward we might include quarters, but for now it's just yearly totals). Type Item 2009 2008 2007 Average N Num. attend 234 210 198 214 N Total hours 10.25 20.45 17.65 16.12 P % completed 0.101%...