Search results

  1. M

    Create one search box that will search across tables and fields

    I am trying to create a search box within a form that will search for information in four fields and in two different tables. I have created a query but do not know how to add it my form where I can select fields from either table then have a search box to execute against those fields. Please...
  2. M

    Calculated text field

    I am trying to calculated our companies email addresses instead of having to enter them. I need it to come out as follow: [FirstName].[LastName]@company.com Please help. Thanks, Mandy
  3. M

    Creating a pk with a calculated autonumber to create relationships

    I am trying to create four tables: Company, Contact, Activities, and Opportunities. I want them to relate hierarchically. A Company can have many contacts, contacts can have multiple Activities and Opportunities. But you can't have contacts without a company and you can't have Activities and...
Top Bottom