Re: DB2, MsSQL, and MS Access, How to maintain 3 data sources

Hi, there,

Thanks for the response.

The information stored will be customer names, and addresses. Each
customer will have an area code, and it is this code that will be used
to split the data over the 20 laptops. This means that no two salesmen
will ever have the same customers in there database. The salesmen will
have the ability to create quotes, and call logs for a specified
customer. This data will obviously be stored in separate tables to the
customer?s names and addresses.

A quick example:

The salesmen selects a customer with a unique ID of 103, He then create
a quote for this customer causing a record to be created in the quote
header table. The customer ID of 103 is assigned to FK_customer ID in
the quotes header table.

Salesmen will be allowed to add new customers to there database, and
create quotes for them. Imagine two salesmen add two separate and
different customers to there database and both copies of MS Access
assign a customer ID of 107. When both salesmen synchronize then will be
a duplicate customer ID. I could have the SQL server ignore there
customer ID and create a new one, but what happens to all the quote
records?

This is really the problem, how can I work it so that I can have both
the SQL server, and all copies of the ms access databases generate
unique customer ID?s? As they will all be capable of creating new
customer records.

Thanks
Dave




*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Need help setting up a Parent form with three subforms
    ... PartNumandDesc -- no ned to store this in Access, it can be easily combined anytime to display or let the users pick from in a combo or listbox ... you should make a Manufacturers table with MfgID autonumber and MfgName. ... yes -- but you need to make sure the same customer is not in there multiple times -- this often happens when you bring data in from other places. ... What you are calling 'Quote Details' I would call Quotes -- whatever is your header information. ...
    (microsoft.public.access.forms)
  • Re: Need help setting up a Parent form with three subforms
    ... you should have additional tables if you are going to include inventory control... ... (customer name, customer address)" ... For instance, a company may have two addresses -- ie, for billing and shipping. ... I am assuming this is your Quotes table ...
    (microsoft.public.access.forms)
  • Re: Need help setting up a Parent form with three subforms
    ... (customer name, customer address)" ... Addresses (with an AddrTypeID specified -- billing, shipping, or both) ... I am assuming this is your Quotes table ... CustEqID and store a long integer CustEqID in the Quote table -- by ...
    (microsoft.public.access.forms)
  • Re: Need help setting up a Parent form with three subforms
    ... introduction to the essence of access; however, I am having trouble applying ... CUSTOMER TABLE: This excel table exists and was imported into access. ... TotalPrice -- this would go in the Quotes table, if you store it at all ...
    (microsoft.public.access.forms)
  • Re: Table/Query Lookup
    ... >and how it will be stored in the database. ... You do NOT want to "add more than one customer to the quoted to ... but (by design) doesn't deal with relational design or ... you'ld use a Form for Quotes with a Subform based on ...
    (microsoft.public.access.gettingstarted)
Loading