Search results

Hi Guys, I decided to normalize my addresses out of COMPANY and CONTRACT entries into a seperate table. This idea works fine until I try to add new entries or update existing entries. Normalization has made it impossble for my database to function properly. Heres the situation: Company...

Hi Guys, I'm trying to create a simple form that allows me to enter information about a new customer into my database. I've normalized Addresses into another table. I've attached a stripped down example of my problem to this thread. Everything works fine when I'm viewing exisitng records...

Hi Guys, I have a big issue I'm not sure on: 1. I have a combo box in my "NewOrder" form that I use to select a customer for the order. I'd like to have a button that would open my NewCustomer form if a new customer was needed.. I can do that.... but how to I make it so that the new customer...

Hi Guys, For the company I'm working with, I'm required to allow for two contract types. One for a single on-going service, and one for installation (many one-time services). Right now I've got the single on-going service listed in a products table with a "ContractType" lookup field...

Hi Guys, I need a hand understanding receipts... heres the way I see it: Many Customers can at Many Times, buy Many Products. Resolution: Customers to Times (or Instances) = Receipt (or Order) Times (or Instances) to Products = LineItems LineItems within Receipts within Customers Fairly...

Please Help -- "Same as Billing Address" Checkbox --- is this possible!?!?!? Hey Guys, I'm looking to create a "Same As Billing Address" check box that would automatically udpate the address in an order to reflect the customer's billing address. I understand how to sync a combo box to an...

Hey Guys, I'm looking to create a "Same As Billing Address" check box that would automatically udpate the address in an order to reflect the customer's billing address. I understand how to sync a combo box to an option group ([URL="http://www.fontstuff.com/access/acctut10.htm"] -- great...

Hi Guys, One of the things Im most struggling with from a theoretical standpoint is simply the signifigance of having more than one primary key in a table... and the overall purpose of a foreign key. Whats your understanding of this... perhaps give an example or one or the other... im...

Hi Guys, My company maintains properties, some of which ARE the address of the billing company, some of which ARE NOT... I've normalized my database by creating a seperate table for addresses so as to eliminate the redundancy of typing the address in twice in the case of the maintaned property...

Hi Guys, Hopefully a simple question here. I looking to create a form that creates a contract for a particular client we deal with (grounds maintenance). In that form I'm looking to give the end user the option of selecting an existing billing address (for a property mgmt. company for example)...

Hey guys, Im working on a project for a landscaping company that does Installation and Maintenance Services that wants to be able to build contracts, bid and log its customers into a simple database and I've run into an issue I cant resolve. I've normalized data so far as follows...