Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Sep 2006
    Thanked 0 Times in 0 Posts

    Table relationships (Access 2000)

    I am in the process of revamping my form for issuing offers and i think the best way is to ask for the correct way from the very beginning in order to avoid greater mistakes later on.My first question is as to the correct relationship between the tables.Up to now i had 2 tables related, i.e. tblClients and tblOffers
    and in the table offerd i put the field Clientid.Now i want to improve my form for the offers and want to include also the table Customers in order to be able to make an offer either for a client or for a customer.I have tried to make a combined query for both tables however i cannot make the form with it.Also, i do not know how to relate the tables in a relationship.Is it possible to make such a form ?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Table relationships (Access 2000)

    I wouldn't use separate tables for customers and clients, but a single table. Add a Yes/No field that can be set to Yes for a customer and No for a client.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts